Re: Import full database

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/01/08
Message-ID: <32D3C718.4E79@ebmud.com>#1/1

Lynne,
This works for us. We are porting between platforms (IBM mainframe to SGI Unix) and pre-create the database with larger tablespaces, then do a full export/import to migrate the data. Our version mis-match and EBCDIC-to-ASCII conversion makes it a little more complex that your project, but at least this part works.

Lynne Nyhan wrote:
>
> Situation:
> We're moving platforms from Sun Solaris to HP-UX 10.01. The Oracle
> RDBMS's are the same version of software. However, the Sun production
> database is spread over many datafiles for it's data. What I would like
> to do is create the database on the new machine (HP) with larger datafiles
> and then import a full export of the database coming off of the Sun
> machine.
>
> Question:
> Will the import bomb because the database already exists?
Received on Wed Jan 08 1997 - 00:00:00 CST