Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Undocumented
AUTHID
CURRENT_USER
Dependencies
ALL_CAPTURE_PREPARED_TABLES
DBMS_FLASHBACK
DBMS_STREAMS_ADM
ALL_SYNC_CAPTURE_PREPARED_TABS
DBMS_INTERNAL_SAFE_SCN
DBMS_STREAMS_DATAPUMP_UTIL
DBA_CAPTURE_PREPARED_TABLES
DBMS_LOGREP_IMP_INTERNAL
DBMS_STREAMS_DECL
DBA_SYNC_CAPTURE_PREPARED_TABS
DBMS_LOGREP_UTIL
DBMS_STREAMS_PUB_RPC
DBMS_DATAPUMP
DBMS_STANDARD
DBMS_STREAMS_RPC
Documented
No
Exceptions
Error Code
Reason
ORA-31623
a job is not attached to this session via the specified handle
dbms_streams_datapump.get_export_dml_scn(
schema IN VARCHAR2,
tablename IN VARCHAR2,
cookie IN VARCHAR2,
flashback_scn IN NUMBER)
RETURN NUMBER;
SELECT current_scn FROM v$database;
CURRENT_SCN
-----------
63077734
DECLARE
retVal NUMBER;
BEGIN
retVal := dbms_streams_datapump.get_export_dml_scn('C##UWCLASS', 'SERVERS', 'TEST', 63077734);
dbms_output.put_line(retVal);
END;
/
DECLARE
*
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 4747
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4494
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5973
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 18
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 80
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP", line 428
ORA-06512: at line 4
dbms_streams_datapump.need_scn(
dblink IN VARCHAR2,
interest OUT BOOLEAN,
cookie IN OUT VARCHAR2);
DECLARE
intVal BOOLEAN;
cookVal dbms_id := 'TEST';
BEGIN
dbms_streams_datapump.need_scn('CN01.ORACLEVCN.COM', intVal, cookVal);
dbms_output.put_line(cookVal);
IF intVal THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
DECLARE
*
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 4747
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4494
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5973
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 18
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 80
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP", line 219
ORA-06512: at line 5
dbms_streams_datapump.need_scn_common(
interest OUT BOOLEAN,
cookie IN OUT VARCHAR2);
DECLARE
intVal BOOLEAN;
cookVal dbms_id := 'TEST';
BEGIN
dbms_streams_datapump.need_scn_common(intVal, cookVal);
dbms_output.put_line(cookVal);
IF intVal THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
TESTS:47:TEST21DB.SUB07212035450.TESTVCN01.ORACLEVCN.COM:
F
dbms_streams_datapump.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)
RETURN BOOLEAN;