Dave,
Import does the things in a LOGICAL way, I mean to say,
what actually import does is, it connects to already existing database as
one of
the database users and does all necessary DDLs and DMLs (and whatever)to
have the data ready
for you, as per the contents of dmp file and your import options.So it is
not bothered
about the PHYSICAL locations of data files.
hth,
Suren
-----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: Tirumala, Surendra
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).
