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

The shortest way is to drop the application users(not the ones created by oracle like sys, system, outln ..) with cascade option, and recreate them before the import, because if the users did not exists some import versions will create them on the system tablespace. So you better already have the users an the tablespace on the database before doing the import. You can create a script to produce the script you will use for users creation.

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 - 13:36:20 CST