| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Move ALL Data from 1 Database into Another
Vivek - If it is critical, I would test each alternative on a small amount
of data. I have had pretty good results from the data link. Depending on the
number of CPUs, you can run multiple imports or multiple data links
simultaneously. Also watch your disk storage conflicts. For example, you
wouldn't want the source tables and destination tables on the same disk. The
more you can spread I/O the better because that is likely to end up as your
bottleneck.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, November 13, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
Qs What would be the FASTEST way to Load ALL Data from a Source Database Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ?
NOTE - Creation Fresh (NEW) Database is a Must because Some of the Data Dictionary Objects have got Corrupted & the Standard Migration of the Same Oracle 7 Database to Oracle 8i did NOT Correct the Corruption Either.
Qs Would Creating a Database Link between the 2 Databases & using CREATE TABLE <TABLE NAME IN 8i DB> NOLOGGING PARALLEL (DEGREE n) AS SELECT * FROM <TABLE NAME IN 7.3.4 DB>@DB_LINK be FASTER than taking Full Database Export (exp) of the Oracle 7 Database & Importing (imp) to the Oracle 8i Database ?
ASSUMPTION - Both Databases Exist on the SAME Storage Box & thus on the Same Machine
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 13 2002 - 11:21:14 CST
 |
 |