Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: full import

Re: full import

From: sybrandb <sybrandb_at_yahoo.com>
Date: 29 Jun 2006 02:37:22 -0700
Message-ID: <1151573842.355200.104740@m73g2000cwd.googlegroups.com>

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
Received on Thu Jun 29 2006 - 04:37:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US