Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Import question

Re: Oracle Import question

From: tojo <Tojo_at_hotmail.com>
Date: Thu, 19 Aug 2004 16:46:17 +0200
Message-ID: <MPG.1b8edba8cebba2e39896ff@news.t-online.de>


In article <bd11d7fb.0408190539.3eae0947_at_posting.google.com>, li369 @verizon.net says...
> Hi,
>
> I want to move my database from server A to server B using the import
> utility. On my server B, the oracle home is on the D drive. When I do
> the import, I want the data files imported to the E drive, but
> instead, they were all imported to the D drive under the oracle home
> direction. Is there a way to control the destination of the data files
> when doing the import?
>
> Thank,
> Jeff
>

Import has no say in the matter. Oracle just imports the objects into the designated tablespaces, which consist of one or more datafiles. You can move your datafiles to another drive if you want, but that has nothing to do with Import. See the Administrator's Guide under "Managing Datafiles"

Received on Thu Aug 19 2004 - 09:46:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US