Re: Urgent question about export/import

Hi Wozi,

The datafile definition is in the create tablespace statement in the export. Import will just take this at face value and create the files. If this definition is not correct anymore you will need to precreate your tablespaces and run the import with IGNORE=Y.

Hth,

Sybrand Bakker, Oracle DBA

wozi <wozi_at_dhc.net> wrote in message
news:183354B3A69C8DD1.CB9AD500F7599ECF.A9045AF803473D4B_at_lp.airnews.net...
> I just did a full export from Oracle7.
> I want to import the entire dump file into Oracle8.
>
> It is my understanding that Oracle exports the tablespace definitions as
> well.
> But, how does it know where to create the datafile associated with the
> tablespace? The directory structure in Oracle7 instance is different from
> Oracle8 instance. For example, the datafiles in oracle7 may be
> c:\oracle\dbs,
> but in oracle8, I want the datafiles to be in d:\orant\database.
> (I know it can be manually moved through alter database). How does import
> handles this initially during import?
>
> Any help would be appreciated.
> Please, copy tyc77_at_hotmail.com
>
>
>
>
Received on Wed Aug 18 1999 - 13:23:24 CDT