Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Import question
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"