With these sizes, I usually only export the schema structures using
rows=n and tables are transferred over dblinks in direct mode (there is no
direct mode import possibility until 10g, and even then it's done using data
pump, Oracle's new exp/imp toolset)
Also I build indexes only after import, in nologging and parallel
mode.
Tanel.
----- Original Message -----
Sent: Thursday, November 06, 2003 3:09
PM
Subject: Re: IMP using the same DMP
file
On the subject of export/import, has anyone exported a 1 TB db
and imported it into another db? The largest I have done is 300gb w/out
problems.
>>> [EMAIL PROTECTED] 11/05/03
05:04PM >>> You can import the same file into two instances
simultaneously, because "imp" doesn't lock the import file, unless the
import file was produced by simultaneous export into the same file from two
different instances, in which case you have something what is
scientifically known as "monster mess" and is really appropriate for the
Halloween time.
On 11/05/2003 04:49:36 PM, Whittle Jerome Contr NCI
wrote: > Hi, > > We were just wondering if you can IMP into
two instances using the same dmp file at the same time? We need to refresh
both our development and test instances with data from our production database
and doing both at once might save some time. 8.1.7 and Unix. > >
Jerry Whittle > ASIFICS DBA > NCI Information Systems Inc. >
[EMAIL PROTECTED] > 618-622-4145 >
Mladen
Gogala Oracle DBA
Note: This message is for the named
person's use only. It may contain confidential, proprietary or legally
privileged information. No confidentiality or privilege is waived or
lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy
any hard copies of it and notify the sender. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this message
if you are not the intended recipient. Wang Trading LLC and any of its
subsidiaries each reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender is
authorized to state them to be the views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
Mladen Gogala 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).
|