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 ..?
Printable View
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..?
you want to import into one db from the same file that the export is in the middle of producing?Quote:
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 can but if the process interrrupts you have to start all over again which can be longer than doing export then import seperately!
Why don't you clone the database to the other server (with RMAN). That's very fast method.Quote:
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 ..?
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?Quote:
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
Through pipes and rsh.
Tamil
copy is the best & fastest.