Re: Export / Import

Fiona,

Create an identical tablespace structure in the target database, placing the datafiles on E:\. When import trys to import the tablespaces, it will fail (which is expected), and then continue to import all the objects into the tablespaces you created, which reside in the the R:\ datafiles.

Cheers

Chris

Fiona McKee wrote:
>
> Hi
>
> I've been trying to move a database from one server to another using Import
> / Export. However the database on the first server has the path
> c:\orant\database\datafiles or whatever for the datafiles. When I try and
> import the file onto the second server it tries to put it in the c:\ instead
> of the e:\ which is where the new database needs to go. The import fails so
> how do I tell it to go to the e:\
>
> Thanks
>
> Fiona
Received on Tue May 25 1999 - 20:38:49 CDT