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_at_posting.google.com>
Date: 23 Feb 2003 06:46:38 -0800
Message-ID: <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,