Re: Import full database

Lynne Nyhan <lnyhan_at_bidmc.harvard.edu> wrote:

>Situation:
>We're moving platforms from Sun Solaris to HP-UX 10.01.

I believe there were problems with Oracle on 10.01. Check with Oracle on this. They'll probably recommend that you upgrade to HPUX 10.10 before running Oracle.

>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?

Create your tablespaces first - with datafiles configured the way you want. Then run your import with the IGNORE=Y option. Any errors generated because the tablespaces already exist will then be ignored.

If any of your tables are large, you'll probably want to use the COMMIT=Y option too. This prevents you from exceeding the size of your rollback segments.

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!