Re: full import

aleicaro_at_libero.it wrote:
> Hi,
> I've an export (a .dmp file) created with "exp system/manager_at_MYDB
> FULL=Y FILE=....."
>
> I try to restore this dump on an existing database but it gives me a
> lot of errors "Primary key violated" and other errors of "Existing
> objects". I tried to specify the option DESTROY=Y but the errors still
> appears..
>
> There is a way to remove all the objects of a database before the
> import of a full DB dump?
>
>
> Thank you in advance
> Alessandro.

You should have used IGNORE=Y
If the target tables are non-empty the errors were expected, and that is good.
Destroy=Y should have destroyed entire tablespaces. You could have removed users by issuing
drop user <username> cascade
/

--
Sybrand Bakker
Seniuor Oracle DBA