Oracle | DBMS_INTERNAL_SAFE

Oracle DBMS_INTERNAL_SAFE_SCN Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented but appears to relate to obtaining a safe System Change Number off the stack for use with DataPump.

AUTHID CURRENT_USER

Dependencies

DBMS_INTERNAL_LOGSTDBY	KUPM$MCP	KUPW$WORKER
DBMS_STREAMS_DATAPUMP

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE and LOGSTDBY ADMINISTRATOR roles

Source {ORACLE_HOME}/rdbms/admin/prvtlsss.plb

Subprograms

GET_EXPORT_DML_SCN	NEED_SCN	SET_SESSION_STATE
MATCHED_PRIMARY	SET_EXPORT_SCN	WAIT_FOR_SAFE_SCN

GET_EXPORT_DML_SCN

Undocumented dbms_internal_safe_scn.get_export_dml_scn( schema IN VARCHAR2, tablename IN VARCHAR2, cookie IN VARCHAR2, flashback_scn IN NUMBER) RETURN NUMBER;

TBD

MATCHED_PRIMARY

Returns 1 if the DBID is valid for the primary database dbms_internal_safe_scn.matched_primary(dbid IN NUMBER)RETURN NUMBER;

SELECT dbid, current_scn

      FROM v$database;

      

             DBID CURRENT_SCN

      ----------- -----------

       1405253007   228637960

      

      SELECT dbms_internal_safe_scn.matched_primary(428676178);

      

      DBMS_INTERNAL_SAFE_SCN.MATCHED_PRIMARY(228638000)

      -------------------------------------------------

                                                      
      0

NEED_SCN

Undocumented dbms_internal_safe_scn.need_scn( dblink IN VARCHAR2, dbversion IN VARCHAR2, compatibility IN VARCHAR2, interest OUT BOOLEAN, cookie IN OUT VARCHAR2);

-- this test seems to indicate that this must be run from within a datapump job

      DECLARE

       b BOOLEAN;

       c VARCHAR2(200) := 'TEST';

      BEGIN

        dbms_internal_safe_scn.need_scn('','23.0.0.0','23.4.0', b, c);

        dbms_output.put_line(c);

      END;

      /

      *

      ORA-31623: a job is not attached to this session via the specified handle

SET_EXPORT_SCN

Undocumented dbms_internal_safe_scn.set_export_scn( schema IN VARCHAR2, name IN VARCHAR2, type IN VARCHAR2, cookie IN VARCHAR2, SCN IN NUMBER, original_schema IN VARCHAR2, original_name IN VARCHAR2);

TBD

SET_SESSION_STATE

Undocumented dbms_internal_safe_scn.set_session_state(cookie IN VARCHAR2);

exec dbms_internal_safe_scn.set_session_state('TEST');

PL/SQL procedure successfully completed.

WAIT_FOR_SAFE_SCN

Returns the next, safe, SCN based above the current SCN dbms_internal_safe_scn.wait_for_safe_scn( schema IN VARCHAR2, tablename IN VARCHAR2, timeout IN VARCHAR2, scn IN NUMBER, dbid IN NUMBER) RETURN NUMBER;

SELECT current_scn

      FROM v$database;

      

      CURRENT_SCN

      -----------

         18766958

      

      DECLARE

       retVal NUMBER;

      BEGIN

        retVal := dbms_internal_safe_scn.wait_for_safe_scn('UWCLASS', 'SERVERS', '1', 1, 1405253007);

         dbms_output.put_line(TO_CHAR(retVal));

      END;

      /

      228638304

      

      PL/SQL procedure successfully completed.