RE: Export Dump of of Large Table (Size = 200 GB) in 9.2 & Import into 10.2?

Folks

Need to take Export Dump of a Large (200 GB) Table in Minimum possible Time?

NOTE - Table is range partitioned by date.

Some Options:-

1. Should Multiple Export processes be fired concurrently on different Data ranges thereby exporting multiple Partitions / Date Ranges concurrently? Any Sample Examples / Link showing "exp with where condition for Partition / Conditional Exports"? if so, will this Slow down the export process? Such Dumps should be usable by Multiple Concurrent imports too.
2. Optionally, Using a single Export Process, Can the Export Dump file be broken into multiple dump files of Smaller Size instead of 1 Single BIG Dump file, during exp? Any Sample Examples to break a Large Export Dump File based on Size? Can these multiple dump files(thus obtained) be imported Concurrently by Multiple import processes or NOT? Any Size Limitation on MAX Size of Export Dump file in 9.2?

NOTE - Source Database - in version 9.2, Single-Byte, NOT Production Target Database is in version 10.2, Multi-Byte, NOT Production, internal DB.

NOTE - Source & Target Databases are in different NON-Networked geographies.

Cheers & Thanks

Vivek

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l