OraFAQ Forum: Server Utilities » ORA-31684 with datapump for sequences

Home » RDBMS Server » Server Utilities » ORA-31684 with datapump for sequences

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-31684 with datapump for sequences [message #236656]

Thu, 10 May 2007 09:41

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