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
Uwe
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
Hi all

I have a problem with an import with datapump on a 10.2.0.2 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 ?

regards
Uwe
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
hasan_uiu
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: Sat Dec 10 09:19:09 CST 2016

Total time taken to generate the page: 0.08401 seconds