Re: Export/Import question

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 <ORACLE-L_at_fatcity.com> 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: jonathan_at_jlcomp.demon.co.uk

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: ListGuru_at_fatcity.com (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).