Re: Urgent question about export/import

Export files store datafile names and paths. When you import your full export file,
Oracle issues a CREATE TABLESPACE command to create tablespaces, and stored datafile names furnish necessary information for this command. If the database
files should be at different locations, you may want to precreate tablespaces, specifying
the datafiles at those locations. Oracle will attempt to create talespaces and will fail.
At this time you can set IGNORE import parameter to ignore the creation error,
and Oracle will put your data into desired tablespaces.

wozi wrote:

> 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:30:16 CDT