Thanks Tom and others that replied,
That was the explanation that I needed. I also was informed that exporting
with COMPRESS=Y is a mistake due to sizing issues so I will do another
export with COMPRESS=N.
Dave
-----Original Message-----
Sent: Tuesday, September 04, 2001 3:48 PM
To: Multiple recipients of list ORACLE-L
Dave,
You will need to create the tablespaces before you do the import. When you
create the tablespaces, you will be creating the physical files to support
those tablespaces.
Import simply imports data to tablespaces (or, optionally, other
tablespaces).
Sooo, when you re-create your new tablespaces, you can place the physical
files anyplace you want on the new server.
hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, September 04, 2001 4:02 PM
To: Multiple recipients of list ORACLE-L
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.
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
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).
