RE: Export/Import question

From: Tirumala, Surendra <Surendra.Tirumala_at_am.sony.com>
Date: Tue, 04 Sep 2001 12:50:44 -0700
Message-ID: <F001.003825EE.20010904125156@fatcity.com>

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: DFarnsworth_at_Ashleyfurniture.com

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tirumala, Surendra
INET: Surendra.Tirumala_at_am.sony.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------