1) To see all source code stored in the catalog
===================================
SQL> desc rc_stored_script
Name Null? Type
-------------------------- -------- ------------------------------------------------
DB_KEY NOT NULL NUMBER
DB_NAME NOT NULL VARCHAR2(8)
SCRIPT_NAME NOT NULL VARCHAR2(100)
SQL> desc rc_stored_script_line
Name Null? Type
-------------------------- -------- -------------------------------------------------
DB_KEY NOT NULL NUMBER
SCRIPT_NAME NOT NULL VARCHAR2(100)
LINE NOT NULL NUMBER
TEXT NOT NULL VARCHAR2(1024)
COLUMN script_name FORMAT A10
COLUMN text FORMAT A65
SELECT
a.script_name,
a.text
FROM rc_stored_script_line a,
rc_stored_script b
WHERE a.db_key = b.db_key
AND b.db_name='&target_db_name'
ORDER BY
a.line;
SCRIPT_NAM TEXT
---------- -----------------------------------------------------------------
full_back {backup database;
full_back }
2) To monitor potential corruption