-
Is it possible to make Export and Import at the same time..
Hi,
Have tablespace 20 GB of data. I want to export it and import it to another database.
I want to have less down time..
Export itself takes long time. Can export and import be done at the same time. Any way out ..?
-
Perhaps if you used files?
-
Please elaborate a little bit more..
The databases, both are in same server.. I want to send compressed file with PIPE and at the same time also I want to import to other database from the same compressed file....
Is it possible..?
-
Originally posted by skdas
Please elaborate a little bit more..
The databases, both are in same server.. I want to send compressed file with PIPE and at the same time also I want to import to other database from the same compressed file....
Is it possible..?
you want to import into one db from the same file that the export is in the middle of producing?
I'm stmontgo and I approve of this message
-
you can but if the process interrrupts you have to start all over again which can be longer than doing export then import seperately!
-
Re: Is it possible to make Export and Import at the same time..
Originally posted by skdas
Hi,
Have tablespace 20 GB of data. I want to export it and import it to another database.
I want to have less down time..
Export itself takes long time. Can export and import be done at the same time. Any way out ..?
Why don't you clone the database to the other server (with RMAN). That's very fast method.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Export and Import can be done simultaneously using unix pipes. This is the faster than any other method I had used.
Tamil
-
Originally posted by tamilselvan
Export and Import can be done simultaneously using unix pipes. This is the faster than any other method I had used.
Tamil
Do you mean directly through a pipe, or through a fifo file/node?
-
Through pipes and rsh.
Tamil
-
copy is the best & fastest.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|