What about foreign keys, functions, procedures, synonyms, roles, grants and triggers (if any)? I've used the db link and it's faster than imp/exp but it doesn't do anything for other database objects. Also, if you do have foreign keys then a certain amount of pre-planning is necessary to move data in the right order.
DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <DWILLIAMS cc: @LIFETOUCH.CO Subject: RE: Move ALL Data from 1 Database into Another M> Sent by: root 11/13/2002 12:21 PM Please respond to ORACLE-L 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. [EMAIL PROTECTED] -----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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).