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

Report message to a moderator

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

Report message to a moderator

Previous Topic: exp related
Next Topic: Import of a dump from a full database export
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 08:05:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.