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

Hello!

Don't crosspost!

Since full export contains also CREATE TABLESPACE statements you could just drop all tablespaces including contents except SYSTEM tablespace and you might also want to drop all users except SYS.

Before dropping tablespaces you should verify first, that SYS user doesnt have any objects in tablespaces to be dropped, if you have some sys objects in TOOLS tablespace for example, don't drop this tablespace just drop the objects from it which do not belong to sys.

(normally you shouldn't have sys objects outside system tablespace, but sometimes it is the case - AUD$ for example)

Import creates the datafiles with REUSE option, so your old (unused) datafiles will be overwritten in the operating system.

You should do a backup of your current DB before trying to import, in case something goes wrong..

Tanel.

"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.
>
> 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.
>
> Any help would be appreciated.
>
> Thanks,
> Bombadil.
Received on Sun Feb 23 2003 - 16:49:18 CET