As ever, the answer is dependent on the current
state of play.
If the tablespaces for the data do not currently
exist, then Oracle will try to create them on
the wrong drive.
If the tablespaces do exist, it doesn't matter
where they exist - so long as they are large
enough.
Exporting with COMPRESS=Y was probably
a mistake, though. This tends to ensure that
all the imported objects will be different sizes
and give you the maximum opportunity for
future re-org hassles.
If you have the time, I would export again
without the compress, then pre-create the
tablespaces on the target machine using
locally managed tablespaces of uniform
extent sizes.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
-----Original Message-----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 04 September 2001 20:24
|I have a question about how the export/import utility works. My
situation
|is that damagement had me put my live and test environments on the
same
|server. Now they realize that this is not a good situation(test has
crashed
|the server a few times and required a re-boot, imagine that). I have
Oracle
|8.1.7 running on Windoze NT 4.0. I have to move my live database to
another
|server. From reading the fine manuals and from posts that I have
seen I
|have decided to use the export/import utility to make my move. My
database
|is inactive for the weekend. What I am not sure of is this, on my
current
|live database my datafiles(.dbf) reside on drive E. The server I am
moving
|to has a drive F that will be for my data. I have done the export
using
|this command;
|
|EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y
|
|The export ran with no errors or warnings. Now, since my datafiles
reside
|on drive e will the import then be looking for drive e to place the
data in.
|I do not see any option to specify where I want the data to go. Or
if I run
|the import from the f drive of the destination server will the import
|utility place the data in drive F.
|
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
