General Information
Library Note
Morgan's Library Page Header
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
Streams Replication Recovery Internal Utilities
AUTHID
DEFINER
Dependencies
DBMS_ASSERT
DBMS_STANDARD
RECO_SCRIPT$
DBMS_LOGREP_UTIL
DBMS_STREAMS_ADM_UTL
RECO_SCRIPT_BLOCK$
DBMS_RECOVERABLE_SCRIPT
DBMS_STREAMS_RPC
RECO_SCRIPT_ERROR$
DBMS_RECO_SCRIPT_INVOK
DBMS_SYS_ERROR
RECO_SCRIPT_PARAMS$
Documented
No
Exceptions
First Available
Not known
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/prvthrse.plb
{ORACLE_HOME}/rdbms/admin/prvtbrse.plb
Subprograms
ADD_FORWARD_BLOCK
Undocumented
dbms_reco_script_int.add_forward_block(
script_id IN RAW,
block IN CLOB,
canon_dblink IN VARCHAR2,
block_comment IN VARCHAR2,
block_num OUT NUMBER);
TBD
CREATE_SCRIPT
Undocumented
dbms_reco_script_int.create_script(
invoking_pkg_owner IN VARCHAR2,
invoking_pkg IN VARCHAR2,
invoking_proc IN VARCHAR2,
invoking_user IN VARCHAR2,
script_comment IN VARCHAR2,
script_id OUT RAW);
TBD
GET_DBLINKS
Undocumented
dbms_reco_script_int.get_dblinks(script_id IN RAW)
RETURN sys.dbms_reco_script_int.dblink_type;
TBD
GET_ERROR_BLOCK_NUM
Undocumented
dbms_reco_script_int.get_error_block_num(script_id IN RAW) RETURN NUMBER;
TBD
GET_FORWARD_BLOCK
Undocumented
dbms_reco_script_int.get_forward_block(
script_id IN RAW,
block_num IN NUMBER,
forward_block OUT CLOB,
canon_forward_dblink OUT VARCHAR2);
TBD
GET_FORWARD_BLOCKS
Undocumented
dbms_reco_script_int.get_forward_blocks(script_id IN RAW)
RETURN sys.dbms_reco_script_int.script_block_type;
TBD
GET_SCRIPT_OWNER
Undocumented
dbms_reco_script_int.get_script_owner(script_id IN RAW) RETURN VARCHAR2;
TBD
GET_UNDO_BLOCK
Undocumented
dbms_reco_script_int.get_undo_block(
script_id IN RAW,
block_num IN NUMBER,
undo_block OUT CLOB,
canon_undo_dblink OUT VARCHAR2);
TBD
GET_UNDO_BLOCKS
Undocumented
dbms_reco_script_int.get_undo_blocks(script_id IN RAW)
RETURN sys.dbms_reco_script_int.script_block_type;
TBD
INSERT_PARAM
Undocumented
dbms_reco_script_int.insert_param(
script_id IN RAW,
p_name IN VARCHAR2,
p_value IN VARCHAR2,
p_ind IN NUMBER);
TBD
MODIFY_FORWARD_BLOCK
Undocumented
dbms_reco_script_int.modify_forward_block(
script_id IN RAW,
block_num IN NUMBER,
forward_block IN CLOB,
canon_dblink IN VARCHAR2,
action IN VARCHAR2);
TBD
MODIFY_UNDO_BLOCK
Undocumented
dbms_reco_script_int.modify_undo_block(
script_id IN RAW,
block_num IN NUMBER,
undo_block IN CLOB,
canon_dblink IN VARCHAR2,
action IN VARCHAR2);
TBD
RECORD_ERROR
Undocumented
dbms_reco_script_int.record_error(
script_id IN RAW,
block_num IN NUMBER,
error_num IN NUMBER,
error_msg IN VARCHAR2);
TBD
SYS_PURGE
Undocumented
dbms_reco_script_int.sys_purge(script_id IN RAW);
TBD
SYS_PURGE_LOCAL
Undocumented
dbms_reco_script_int.sys_purge_local(script_id IN RAW);
TBD
UPDATE_BLOCK_STATUS
Undocumented
dbms_reco_script_int.update_block_status(
script_id IN RAW,
block_num IN NUMBER,
block_status IN NUMBER);
TBD
UPDATE_COMMENT
Update a script's comment
dbms_reco_script_int.update_comment(
script_id IN RAW,
script_comment IN VARCHAR2);
TBD
UPDATE_DONE_BLOCK_NUM
Undocumented
dbms_reco_script_int.update_done_block_num(
script_id IN RAW,
block_num IN NUMBER);
TBD
UPDATE_STATUS
Sets the status for a recovery script
dbms_reco_script_int.update_status(
script_id IN RAW,
script_status IN NUMBER);
TBD
USER_PURGE
Undocumented
dbms_reco_script_int.user_purge(script_id IN RAW);
TBD