Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_datapump.start_job over network gives "ora-39004: invalid state"

504330Mar 3 2009 — edited Mar 3 2009

I'm getting "ORA-39004: invalid state" every time I attempt to import a table over the network by calling dbms_datapump.start_job in a stored procedure.

I've narrowed the problem down to the name of the database link to the source database. The link contains a connection qualifier using the '@' symbol (for example 'wiley.acme.com@src_db'). If I remove the qualifier '@src_db' then the import runs smoothly.

Why doesn't Oracle like the qualifier here? And is there a way to perform a network import using a database link with a connection qualifier?

Edited by: ec on Mar 3, 2009 7:15 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2009

Added on Mar 3 2009

#database-key-features, #export-import-sql-loader-external-tables

4 comments

3,834 views