Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

full export oracle on aix

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users full export oracle on aix
# 1  
Old 03-01-2006
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
# 2  
Old 03-01-2006
You can adopt something like this widely used method:
Code:
mknod exp_pipe p
compress < exp_pipe > EXPORT.dmp.Z &
exp un/pw file=exp_pipe log=EXPORT.log

This simply compresses the export data as it is dumped.

Replace exp with a tar command and you should be able to dump straight to a tape drive.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. Shell Programming and Scripting

Command to view full data "export MAESTRO_OUTPUT_STYLE=LONG"

Hi, Always when I login to Unix, I need to give the following command to view the data properly; export MAESTRO_OUTPUT_STYLE=LONG The reason is that by default the settings export MAESTRO_OUTPUT_STYLE=SHORT Please let me know how I could make LONG as the default and avoid giving the... (1 Reply)
Discussion started by: jmathew99
1 Replies

8. Solaris

export oracle schemas

Hi, How do i export selected Oracle database schemas from HpUnix? Is it possible to export it to a windows shared drive? If so how do i do it? Pls advice. Thanks in advance. (4 Replies)
Discussion started by: nicky88
4 Replies

9. 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

10. 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
Login or Register to Ask a Question