My Oracle Support Banner

Database Control Generated Scripts For Streams ORA-39001: Invalid Argument Value (Doc ID 399654.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.2]
Information in this document applies to any platform.


Running the generated scripts from Database Control to setup a Streams environment, gives the following errors when running export_import.sql -


ERROR at line 1:
ORA-39001: invalid argument value
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2926
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3958
ORA-06512: at line 14

The generated StreamImport_*.log file shows the following:



ORA-39170: Schema expression IN ('<schema>') does not correspond to any schemas.
ORA-39012: Client detached before the job started.



-- Steps To Reproduce:
Use Database Control and generate Streams replication scripts



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.