Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: export oracle schemas
Operating Systems Solaris export oracle schemas Post 56724 by sdharmap on Friday 8th of October 2004 04:48:54 PM
Old 10-08-2004
Nicky,

Once you create a full dump file move it (FTP) to any OS in binary
format and you should be able to import it into the database there!

1. Create export of DB on UX

exp dba/passwd@yourDB FILE=exp_database.dmp COMPRESS=N CONSISTENT=N CONSTRAINTS=Y owner= <schema you want to export> foo GRANTS=Y INDEXES=Y RECORD=Y ROWS=Y Feedback=1000 LOG=exp_database.log

2. FTP file to Win2k
3. Create new db on Win2k
4. Create the tablespaces
5. Create the same users (foo)
6. Import the schema into the new database.

imp dba/passwd@newdb file=exp_database.dmp FROMUSER=foo TOUSER=foo commit=y LOG=imp_database.log


Note:: You can also export the database and redirect it to be compressed! - Check for this on oracle-> metalink

Hope this helps!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Retrieve Oracle export to tape

Hi! We have an Oracle db export that was compressed and written to DLT tape directly!- This is from box1 The next step is to restore the contents of the tape into the database on box2. The problem is that there is no DLT tape drive attached to box2. There is a box3 that has the tape drive... (1 Reply)
Discussion started by: sdharmap
1 Replies

2. Shell Programming and Scripting

export table from oracle database

i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it. thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies

3. UNIX for Advanced & Expert Users

full export oracle on aix

Hi I have an oracle 7.3.4 running on an aix 4.3, I need to make a full export of the db and I haven't space on disk. Can I export directly to a tape drive? Has anybody a script to do so or something that can help me to? thank you very much (1 Reply)
Discussion started by: andwhat
1 Replies

4. Solaris

how to capture oracle export log while running as background process

I ran the Oracle 9i export command from a terminal to export out a big table using "exp andrew/password file=andrew.dmp log=andrew.log" From the terminal I can see that the export is running as there is some output from the oracle export job. The export job is not complete yet. When i go check... (4 Replies)
Discussion started by: hippo2020
4 Replies

5. Shell Programming and Scripting

Oracle export

Hi Experts , Does anybody know the sheel scripts , which exports oracle tables into xls files . Thanks for your feedback. Regards Pranav (1 Reply)
Discussion started by: Heisonline
1 Replies

6. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies

7. Shell Programming and Scripting

How to do Parallel Export in Oracle DB

I intend to do parallel export of my Oracle db (i.e all the schema in my db). Currently I'm using the below exp command in my script: exp $uid/$pwd@$ORACLE_SID FILE=./DUMP/$today$username.dmp STATISTICS=NONE LOG=./LOG/$today$username.log For parallel export what should I use? Please... (1 Reply)
Discussion started by: priya001
1 Replies

8. Shell Programming and Scripting

Parallel export of all oracle DB schema.

In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one. But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)
Discussion started by: priya001
1 Replies

9. Homework & Coursework Questions

DB2 Export and Import Oracle

Hi Guys, I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle. db2 connect to Tablename user id using psswrd db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA" db2 "EXPORT TO... (3 Replies)
Discussion started by: Sonny_103024
3 Replies

10. Homework & Coursework Questions

DB2 Export and Import Oracle

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: is this enough to make the data perfect export into delimited file? there are some posted that i read, they... (9 Replies)
Discussion started by: Sonny_103024
9 Replies

LEARN ABOUT CENTOS

ftpusers

FTPUSERS(5)						     Linux Programmer's Manual						       FTPUSERS(5)

NAME

       ftpusers - list of users that may not log in via the FTP daemon

DESCRIPTION

       The  text  file	ftpusers  contains a list of users that may not log in using the File Transfer Protocol (FTP) server daemon.  This file is
       used not merely for system administration purposes but for improving security within a TCP/IP networked	environment.   It  will  typically
       contain	a  list  of  the  users that either have no business using ftp or have too many privileges to be allowed to log in through the FTP
       server daemon.  Such users usually include root, daemon, bin, uucp, and news.  If your FTP server daemon doesn't use ftpusers  then  it	is
       suggested  that	you  read  its	documentation  to find out how to block access for certain users.  Washington University FTP server Daemon
       (wuftpd) and Professional FTP Daemon (proftpd) are known to make use of ftpusers.

   Format
       The format of ftpusers is very simple.  There is one account name (or username) per line.  Lines starting with a # are ignored.

FILES

       /etc/ftpusers

SEE ALSO

       passwd(5), proftpd(8), wuftpd(8)

COLOPHON

       This page is part of release 3.53 of the Linux man-pages project.  A description of the project, and information about reporting bugs,  can
       be found at http://www.kernel.org/doc/man-pages/.

Linux								    2000-08-27							       FTPUSERS(5)
All times are GMT -4. The time now is 04:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy