: 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
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
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,
Title: IMP using the same DMP file
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
Title: IMP using the same DMP file
I do
not see a problem. The file can be read only.
-Original Message-From: Whittle Jerome Contr NCI
[mailto:[EMAIL PROTECTED]Sent: Wednesday, November 05,
2003 4:50 PMTo: Multiple recipients of list
ORACLE-LSubject: IMP using the same DMP
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
Jerry,
There shouldn't be any problem. It's better to use different log files or run
them in different directories.
Yong Huang
--- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote:
Hi,
We were just wondering if you can IMP into two instances using the same dmp
file at the same time? We
I agree with Waleed, I don't see any reason why it couldn't be done.
On the other hand, you could very likely find out where the
bottlenecks are on the box you are doing this on. If I were on a 4
processor box with lots of free bandwidth to my storage I'd do it in a
heartbeat.
-rje
K I do not