Home » RDBMS Server » Server Utilities » ORA-31684 with datapump for sequences
ORA-31684 with datapump for sequences [message #236656] Thu, 10 May 2007 09:41 Go to next message
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
Hi all

I have a problem with an import with datapump on a DB.
I set the TABLE_EXISTS_ACTION=REPLACE, but this does not affect Sequences or synonyms. For such objects we will get an error, but we need to import also existing sequences.

Does anyone has a solution for this or do i need to delete anything of the user before importing, especially sequences ?

Re: ORA-31684 with datapump for sequences [message #379146 is a reply to message #236656] Mon, 05 January 2009 02:18 Go to previous message
Messages: 18
Registered: August 2007
Location: Dhaka
Junior Member

you can first delete all existing sequences then import
Previous Topic: exp related
Next Topic: Import of a dump from a full database export
Goto Forum:

Current Time: Fri Jul 21 06:03:52 CDT 2017

Total time taken to generate the page: 0.12728 seconds