Is it possible to make Export and Import at the same time..

[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 ..?

[stecal]

Perhaps if you used files?

[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..?

[stmontgo]

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?

[pando]

you can but if the process interrrupts you have to start all over again which can be longer than doing export then import seperately!

[julian]

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.

[tamilselvan]

Export and Import can be done simultaneously using unix pipes. This is the faster than any other method I had used.

Tamil

[slimdave]

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?

[tamilselvan]

Through pipes and rsh.

Tamil

[abhaysk]

copy is the best & fastest.