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).
