prepared for the release of Oracle Database
18c ... the first autonomous database? We are here at the Library. It is
time for DBAs to stop fighting robots with their fingers and losing ...
time to start using our intelligence and winning.
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('','188.8.131.52','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