Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: IMP using the same DMP file

Re: IMP using the same DMP file

From: GKatteri <>
Date: Mon, 10 Nov 2003 16:49:24 -0800
Message-ID: <>

If the data volume is large, better import into one of the instances, and use TTS to copy the datafiles to the other instance. That way only one import will be taking place at a time and might result in significant improvement in import time.

As Tanel suggested, you can build indexs in nologging and parallel mode. I find SORT_AREA_SIZE beneficial.


On Sun, 09 Nov 2003 13:19:33 -0800, "Tanel Poder" <> said:
> 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 -----
> From: Gene Sais
> To: Multiple recipients of list ORACLE-L
> 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.
> >>> 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
> > NCI Information Systems Inc.
> >
> > 618-622-4145
> >
> Mladen Gogala
> Oracle DBA

-- - The way an email service should be
Please see the official ORACLE-L FAQ:
Author: GKatteri

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Mon Nov 10 2003 - 18:49:24 CST

Original text of this message