Oracle 12c DBMS_SCHED_FILE_WATCHER

Oracle DBMS_SCHED_FILE_WATCHER_EXPORT Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Note

General Information has been put together based on general interest and the fact that Oracle, while not documenting the package, has granted execute to PUBLIC. If anyone has success deciphering a valid value for version number or other functionality please email me and I will include your demo and credit you as the source. Thank you.

AUTHID

CURRENT_USER

Dependencies

DBMS_SCHED_JOB_EXPORT

DBMS_SCHED_MAIN_EXPORT

Documented

First Available

11.2.0.1

Security Model

Owned by SYS with EXECUTE granted to PUBLIC

Source

{ORACLE_HOME}/rdbms/admin/prvthest.plb

Subprograms

AUDIT_EXP	CREATE_EXP	GRANT_EXP
AUDIT_SYSPRIVS_EXP	DROP_EXP	GRANT_SYSPRIVS_EXP

AUDIT_EXP

Undocumented

dbms_sched_file_watcher_export.audit_exp(
objid IN NUMBER,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;

TBD

AUDIT_SYSPRIVS_EXP

Undocumented

dbms_sched_file_watcher_export.audit_sysprivs_exp(
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;

-- no version value input changes the return value of this demo so what is required is still not known

set serveroutput on

DECLARE
bi BINARY_INTEGER;
rv VARCHAR2(128);
BEGIN
rv := dbms_sched_file_watcher_export.audit_sysprivs_exp('999', bi);
dbms_output.put_line('Return Value: ' || rv);
dbms_output.put_line('Out Param: ' || TO_CHAR(bi));
END;
/

CREATE_EXP

Undocumented

dbms_sched_file_watcher_export.create_exp(
objid IN NUMBER,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;

TBD

DROP_EXP

Undocumented

dbms_sched_file_watcher_export.drop_exp(
objid IN NUMBER,
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;

TBD

GRANT_EXP

Undocumented

dbms_sched_file_watcher_export.grant_exp(
objid     IN NUMBER,
isdba     IN BINARY_INTEGER,
grantor   OUT VARCHAR2,
version   IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;

TBD

GRANT_SYSPRIVS_EXP

Undocumented

dbms_sched_file_watcher_export.grant_sysprivs_exp(
version IN VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;

-- no version value input changes the return value of this demo so what is required is still not known

set serveroutput on

DECLARE
bi BINARY_INTEGER;
rv VARCHAR2(128);
BEGIN
rv := dbms_sched_file_watcher_export.grant_sysprivs_exp('11.2.0.2', bi);
dbms_output.put_line('Return Value: ' || rv);
dbms_output.put_line('Out Param: ' || TO_CHAR(bi));
END;
/