Import full database

From: Lynne Nyhan <lnyhan_at_bidmc.harvard.edu>
Date: 1997/01/07
Message-ID: <Pine.SUN.3.94.970107134407.562A-100000@mercury>#1/1

Happy New Year!

I need some information on importing a full export into an existing database. This may seem like a silly question but I need to be very sure that this will work.

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? The utilities guide talks about the import utility continuing when objects and users exist but not databases. Has anyone out there done something similar?

Thank you!

Lynne Nyhan

Beth Israel Deaconess Medical Center       Phone: 617-667-2738
330 Brookline Avenue BR-320		     Fax: 617-975-5094
Boston, Massachusetts 02115-5491	Internet:lnyhan_at_bidmc.harvard.edu



********************************************************************************

Received on Tue Jan 07 1997 - 00:00:00 CST