ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
This package is created by the RMAN 'CREATE CATALOG' command along with other objects that belong to the repository and generates strings for dynamic SQL statements.
AUTHID
DEFINER
Dependencies
ALL_SYNONYMS
DBMS_SESSION
USER_USERS
ALL_USERS
PLITBLM
Documented
No
First Available
Not known
Security Model
This package is created by CREATE CATALOG in the RMAN catalog schema.
Source
{ORACLE_HOME}/rdbms/admin/recover.bsq
-- when the source code is extracted from recover.bsq and compiled the following results
-- package specification
SQL> sho err
Errors for PACKAGE DBMS_RCVVPC:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1 PLW-05018: unit DBMS_RCVVPC omitted optional AUTHID clause;
default value DEFINER used
284/5 PLW-06010: keyword "ATTRIBUTE" used as a defined name
285/5 PLW-06010: keyword "VALUE" used as a defined name
-- package body
SQL> sho err
Errors for PACKAGE BODY DBMS_RCVVPC:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLW-06010: keyword "NULL" used as a defined name
53/10 PLW-06009: procedure "IS_RA" OTHERS handler does not end in RAISE
or RAISE_APPLICATION_ERROR
756/5 PLW-06010: keyword "ATTRIBUTE" used as a defined name
757/5 PLW-06010: keyword "VALUE" used as a defined name
dbms_rcvvpc.f_bp(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_rcvvpc.f_bp(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_BP(USER,'T')
--------------------------
(db_key IN (SELECT db.db_key FROM db) AND (pdb_key IN (SELECT pdb.pdb_key FROM pdb) OR pdb_all = 'Y'))
dbms_rcvvpc.f_bs(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SELECT dbms_rcvvpc.f_bs(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_BS(USER,'T')
-------------------------------------
(db_key IN (SELECT db.db_key FROM db)
AND (pdb_key IN (
SELECT pdb.pdb_key
FROM pdb)
OR pdb_all = 'Y'))
dbms_rcvvpc.f_db(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SELECT dbms_rcvvpc.f_db(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_DB(USER,'T')
-----------------------------------
SYS_CONTEXT('SYS','DB_KEY') IS NULL
AND db_id IN (
SELECT vpc.db_id
FROM vpc_databases vpc)
dbms_rcvvpc.f_do_seq(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_rcvvpc.f_do_seq(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_DO_SEQ(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)
dbms_rcvvpc.f_grsp(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SELECT dbms_rcvvpc.f_grsp(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_GRSP(USER,'T')
----------------------------
(dbinc_key IN (
SELECT dbinc.dbinc_key
FROM dbinc)
AND (pdb_key IN (
SELECT pdb.pdb_key
FROM pdb)
OR pdb_all = 'Y'))
dbms_rcvvpc.f_nrsp(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SELECT dbms_rcvvpc.f_nrsp(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_NRSP(USER,'T')
----------------------------
(dbinc_key IN (
SELECT dbinc.dbinc_key
FROM dbinc)
AND (pdb_key IN (
SELECT pdb.pdb_key
FROM pdb)
OR pdb_all = 'Y'))
dbms_rcvvpc.f_pdb(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SELECT dbms_rcvvpc.f_pdb(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_PDB(USER,'T')
----------------------------------------------
SYS_CONTEXT('SYS','PDB_KEY') IS NULL
AND SYS_CONTEXT('SYS','APP_ROOT_GUID') IS NULL
AND SYS_CONTEXT('SYS','DB_KEY') IS NULL
AND ( guid IN (
SELECT v.guid
FROM vpc_databases v)
OR app_root_guid IN (
SELECT v.guid
FROM vpc_databases v)
OR db_key IN (
SELECT d.db_key
FROM vpc_databases v, db d
WHERE v.db_id = d.db_id
AND v.guid IS NULL))
dbms_rcvvpc.f_rrcache(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_rcvvpc.f_rrcache(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_RRCACHE(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)
dbms_rcvvpc.f_sbt_template_db(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_rcvvpc.f_sbt_template_db(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_SBT_TEMPLATE_DB(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)
dbms_rcvvpc.f_watermarks(
schema_p IN VARCHAR2,
table_p IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_rcvvpc.f_watermarks(USER, 'T')
FROM dual;
DBMS_RCVVPC.F_WATERMARKS(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)