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 -> Re: Import Database from Another OS

Re: Import Database from Another OS

From: Venkat <vreddy_at_ix.netcom.com>
Date: Tue, 19 May 1998 11:46:01 -0400
Message-ID: <6js9fv$jam@dfw-ixnews8.ix.netcom.com>


Gary,
Create the tablespaces that the objects in the export file reference before starting the import. It does not matter if the data files are not in the same path as the source database. The tablespace name(s) HAVE to be the same.
Then use the IGNORE=Y option when importing

HTH
Venkat

>A client has provided me an Export file of their database from an AIX
>server. I have the same version of Oracle on NT 3.51 (both are Oracle
>7.3). When I try to import the databse, it appears to fail due to the
>AIX path designations in the Export file. Quesstions:
>
>1. Is there another/better bcakup format that I should use to transfer
>copy the database from AIX to NT?
>
>2. Are there parameters on the Export function that should be set
>differently when creating the Export file; or on the Import function
>when importing the database?
Received on Tue May 19 1998 - 10:46:01 CDT

Original text of this message

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