| 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
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 <ORACLE-L_at_fatcity.com>
<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.
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 servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: tday6_at_csc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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 - 12:09:33 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |