Re: Oracle 8i: how to do a full import to the same database?
From: Donovan R. <mdonovan_at_hotmail.com>
Date: Sun, 23 Feb 2003 14:36:20 -0500
Message-ID: <fa8i5v0umltsi6k4ktrofugk42rq087uka_at_4ax.com>
Date: Sun, 23 Feb 2003 14:36:20 -0500
Message-ID: <fa8i5v0umltsi6k4ktrofugk42rq087uka_at_4ax.com>
On 23 Feb 2003 06:46:38 -0800, bombadil_at_fastmail.fm (Bombadil) wrote:
>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 - 20:36:20 CET