RE: Questions re datapump import

From: John Dunn <>
Date: Thu, 19 Nov 2009 13:34:50 -0000
Message-ID: <2F802216565E44489600A03F763219A875158A_at_mia.SEFASBRISTOL>


That works for tables, but I am also getting "already exists" errors on other objects (LIBRARY, TYPE and SEQUENCE, PACKAGE, FUNCTION, etc etc)  

Does this means these objects have not been imported?  

How can I ensure these objects are replaced?      

ORA-31684: Object type PACKAGE_BODY:"PRODUCER"."SERVER_JES_MONITOR" already exists

ORA-31684: Object type PACKAGE_BODY:"PRODUCER"."SERVER_JOB_RECEPTION" already exists

ORA-31684: Object type PACKAGE_BODY:"PRODUCER"."SERVER_LOGGING" already exists  

etc etc        

John Dunn

Sefas Innovation Limited.

Tel: + 44 (0) 117 373 6122  

P Please consider the environment before printing this email    

From: [] Sent: 19 November 2009 13:00
To: John Dunn
Cc:; Subject: Re: Questions re datapump import

impdp help=y is your friend :)

TABLE_EXISTS_ACTION Action to take if imported object already exists.

                      Valid keywords: (SKIP), APPEND, REPLACE and

Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage? Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.

From: 	"John Dunn" <> 
To: 	<> 
Date: 	11/19/2009 07:53 AM 
Subject: 	Questions re datapump import 
Sent by:


I want to use datapump export and import as simple method of backing up schemas in our development environments.   

i.e. to restore the schema to a previous state, I would import back into the same schema.   

If I do a full schema import using datapump, will the fact that the database objects already exist cause issues? Will data rows in tables be duplicated?   

Or is there a better way of backing up and restoreing a single schema?   

I do not want to drop the schema between doing the export and the import.         


Received on Thu Nov 19 2009 - 07:34:50 CST

Original text of this message