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

From: Bombadil <bombadil_at_fastmail.fm>
Date: 23 Feb 2003 06:46:38 -0800
Message-ID: <eedb1e6a.0302230646.4d8a6242@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 - 08:46:38 CST