Re: Oracle 8i: how to do a full import to the same database?

"Bombadil" <bombadil_at_fastmail.fm> wrote in message news:eedb1e6a.0302230646.4d8a6242_at_posting.google.com...
> Hello,
>
> we are running Oracle 8i (8.1.6) on Windows 2000 Server.
>
> I have a dump file that I got a while ago using "exp full=y ...".
> I now want to import it back into the same database replacing the data
> that is currently there.

I assume you do not have hot or cold backups because recovering the entire database from a hot or cold backup would be a lot less trouble.

>
> How do you do a full import to the same database?
> Could someone please give me instructions as to how this can be
> achieved?
>
> If I try to just run "imp full=y ..." on the existing database, I
> think I will get lots of errors because the tables, records,
> contraints are already in the db.
>

Yep. If you are really going to do this, first backup what you have.

Make sure you did not create anything while connected as internal ( / as sysdba) or SYS. If so, save this off before the next step.

Then, delete the entire database and rerun the create database scripts that you saved . If you did not save them, then rerun the dbassistant or something to create the scripts and then edit them.

Then, run the import against your new empty database and be prepared for something to fail. There is always something you can't imagine will happen that will happen. For, example any database links to databases that are down while you do the import will not get created and so any Plsql relying on these database links will fail to compile or in some cases fail to import.

Good luck.

> Any help would be appreciated.
>
> Thanks,
> Bombadil.
Received on Sun Feb 23 2003 - 18:43:11 CET