Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Import question
li369_at_verizon.net (Jeff) wrote in message news:<bd11d7fb.0408190539.20bd40ef_at_posting.google.com>...
> 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?
>
> Thanks,
> Jeff
Maybe create the empty tablespaces first on the E drive and then do the import?