Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Urgent question about export/import

Urgent question about export/import

From: wozi <wozi_at_dhc.net>
Date: Wed, 18 Aug 1999 12:39:00 -0700
Message-ID: <183354B3A69C8DD1.CB9AD500F7599ECF.A9045AF803473D4B@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 - 14:39:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US