"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible.
I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Undocumented but appears to relate to obtaining a safe System Change Number off the stack for use with DataPump.
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE and LOGSTDBY ADMINISTRATOR roles
DBLINK IN VARCHAR2,
DBVERSION IN VARCHAR2,
COMPATIBILITY IN VARCHAR2,
INTEREST OUT BOOLEAN,
COOKIE IN OUT VARCHAR2);
-- a test seems to indicate that this must be run from within a datapump job
c VARCHAR2(200) := 'TEST';
dbms_internal_safe_scn.need_scn('','22.214.171.124','12.1.0', b, c);
ERROR at line 1:
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3874
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5041
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 18
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 72
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP", line 219
ORA-06512: at "SYS.DBMS_INTERNAL_SAFE_SCN", line 48
ORA-06512: at line 5