Oracle | DBMS_RECO_SCRIPT

Oracle DBMS_RECO_SCRIPT_INT Version 21c

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

Error Code	Reason

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	GET_UNDO_BLOCK	SYS_PURGE_LOCAL
CREATE_SCRIPT	GET_UNDO_BLOCKS	UPDATE_BLOCK_STATUS
GET_DBLINKS	INSERT_PARAM	UPDATE_COMMENT
GET_ERROR_BLOCK_NUM	MODIFY_FORWARD_BLOCK	UPDATE_DONE_BLOCK_NUM
GET_FORWARD_BLOCK	MODIFY_UNDO_BLOCK	UPDATE_STATUS
GET_FORWARD_BLOCKS	RECORD_ERROR	USER_PURGE
GET_SCRIPT_OWNER	SYS_PURGE

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