This content has been marked as final. Show 4 replies
what is the total DB size ? is is much larger than 1T ? (meaning much larger than the table to copy) -
if no, and the DB in archive mode,
you might consider using RMAN ?
does this table on its own tablespace ? - if so , what about transportable tablespace ?
does the two DB (source and target) on same location (lan) ? or on remote sites (wan) ?
Fastest way will be using datapump export/import (expdp/impdp). using this method, you have following options.
Do tablespace export using transportable tablespace option and plug in this tablespace into the other database holding this large table. This should be the fastest way.
Do export (wil parallel option), move dump file to the other server and do import (with parallel option).
If you have less space for dump file, use compression=all to have a reduced size of dump file during export(this will increase export/import time a bit and will not fastes way).
Use dblink to directly import from the current production which is holding this 1TB table. This will be a bit slower but will not require any space for the dump file on the file system.