re: Export/Import question

Dave,

Hopefully someone else already answered better, but if not, it is the database alias in your connect string.

Wherever the database is for that alias is where the import will end up.

Of course as with all things Oracle, it probably won't be quite that simple, you may need to change network config, pre-build tables and stuff, etc.

regards,
ep

>
> ------------------------------
>
> From: "Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com>
> Date: Tue, 4 Sep 2001 13:55:48 -0500
> Subject: Export/Import question

[via ORACLE-L Digest -- Volume 2001, Number 248]

...
> 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: Eric D. Pierce
  INET: PierceED_at_csus.edu

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