Oracle DBMS_RCVVPC
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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
Subprograms
 
FILTER_PASS_ALL
Undocumented dbms_rcvvpc.filter_pass_all(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.filter_pass_all(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_FILTER_PASS_ALL(USER,'T')
---------------------------------------
 
 
F_AL
Undocumented dbms_rcvvpc.f_al(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_bal(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_AL(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_BCB
Undocumented dbms_rcvvpc.f_bcb(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_bcb(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_BCB(USER,'T')
----------------------------------------
bdf_key IN (SELECT bdf.bdf_key FROM bdf)
 
F_BCF
Undocumented dbms_rcvvpc.f_bcf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_bcf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_BCF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_BCR
Undocumented dbms_rcvvpc.f_bcr(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_bcr(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_BCR(USER,'T')
------------------------------------
df_key IN (SELECT df.df_key FROM df)
 
F_BDF
Undocumented dbms_rcvvpc.f_bdf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_bdf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_BDF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_BP
Undocumented dbms_rcvvpc.f_bp(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_bp(USER, 'T')
  2  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'))
 
F_BRL
Undocumented dbms_rcvvpc.f_brl(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_brl(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_BRL(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_BS
Undocumented dbms_rcvvpc.f_bs(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SQL> SELECT dbms_rcvvpc.f_bs(USER, 'T')
  2  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'))
 
F_BSF
Undocumented dbms_rcvvpc.f_bsf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_bsf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_BSF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_CCB
Undocumented dbms_rcvvpc.f_ccb(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_ccb(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_CCB(USER,'T')
----------------------------------------
cdf_key IN (SELECT cdf.cdf_key FROM cdf)
 
F_CCF
Undocumented dbms_rcvvpc.f_ccf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_ccf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_CCF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_CDF
Undocumented dbms_rcvvpc.f_cdf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_cdf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_CDF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_CFS
Undocumented dbms_rcvvpc.f_cfs(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_cfs(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_CFS(USER,'T')
---------------------------------------
EXISTS (SELECT NULL FROM vpc_databases)
 
F_CKP
Undocumented dbms_rcvvpc.f_ckp(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_ckp(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_CKP(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_CONF
Undocumented dbms_rcvvpc.f_conf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_conf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_CONF(USER,'T')
------------------------------------
db_key IN (SELECT db.db_key FROM db)
 
F_CONFIG
Undocumented dbms_rcvvpc.f_config(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_config(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_CONFIG(USER,'T')
---------------------------------------
EXISTS (SELECT NULL FROM vpc_databases)
 
F_DB
Undocumented dbms_rcvvpc.f_db(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SQL> SELECT dbms_rcvvpc.f_db(USER, 'T')
  2  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)
 
F_DBINC
Undocumented dbms_rcvvpc.f_dbinc(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_dbinc(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_DBINC(USER,'T')
------------------------------------
db_key IN (SELECT db.db_key FROM db)
 
F_DELETED_OBJECT
Undocumented dbms_rcvvpc.f_deleted_object(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_deleted_object(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_DELETED_OBJECT(USER,'T')
--------------------------------------
db_key IN (SELECT db.db_key FROM db)
 
F_DF
Undocumented dbms_rcvvpc.f_df(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_df(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_DF(USER,'T')
----------------------------------------------------
pdbinc_key IN (SELECT pdbinc.pdbinc_key FROM pdbinc)
 
F_DO_SEQ
Undocumented dbms_rcvvpc.f_do_seq(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_do_seq(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_DO_SEQ(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)
 
F_FB
Undocumented dbms_rcvvpc.f_fb(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_fb(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_FB(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_GRSP
Undocumented dbms_rcvvpc.f_grsp(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SQL> SELECT dbms_rcvvpc.f_grsp(USER, 'T')
  2  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'))
 
F_NODE
Undocumented dbms_rcvvpc.f_node(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_node(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_NODE(USER,'T')
------------------------------------
db_key IN (SELECT db.db_key FROM db)
 
F_NRSP
Undocumented dbms_rcvvpc.f_nrsp(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SQL> SELECT dbms_rcvvpc.f_nrsp(USER, 'T')
  2  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'))
 
F_OFFR
Undocumented dbms_rcvvpc.f_offr(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_offr(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_OFFR(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_ORL
Undocumented dbms_rcvvpc.f_orl(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_orl(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_ORL(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_ORSEVENT
Undocumented dbms_rcvvpc.f_orsevent(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_orsevent(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_ORSEVENT(USER,'T')
---------------------------------------
EXISTS (SELECT NULL FROM vpc_databases)
 
F_PDB
Undocumented dbms_rcvvpc.f_pdb(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
-- output formatted for readability
SQL> SELECT dbms_rcvvpc.f_pdb(USER, 'T')
  2  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))
 
F_PDBINC
Undocumented dbms_rcvvpc.f_pdbinc(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_pdbinc(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_PDBINC(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_PDB_DBINC
Undocumented dbms_rcvvpc.f_pdb_dbinc(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_pdb_dbinc(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_PDB_DBINC(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_PDB_NODE (new 19c)
Undocumented dbms_rcvvpc.f_pdb_node(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_pdb_node(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_PDB_NODE(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_RCFILE
Undocumented dbms_rcvvpc.f_rcfile(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_rcfile(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_RCFILE(USER,'T')
---------------------------------------
EXISTS (SELECT NULL FROM vpc_databases)
 
F_RLH
Undocumented dbms_rcvvpc.f_rlh(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_rlh(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_RLH(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_ROUT
Undocumented dbms_rcvvpc.f_rout(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_rout(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_ROUT(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_RR
Undocumented dbms_rcvvpc.f_rr(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_rr(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_RR(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_RRCACHE (new 19c)
Undocumented dbms_rcvvpc.f_rrcache(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_rrcache(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_RRCACHE(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)
 
F_RSR
Undocumented dbms_rcvvpc.f_rsr(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_rsr(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_RSR(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_RT
Undocumented dbms_rcvvpc.f_rt(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_rt(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_RT(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_SBT_TEMPLATE_DB (new 19c)
Undocumented dbms_rcvvpc.f_sbt_template_db(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_sbt_template_db(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_SBT_TEMPLATE_DB(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)
 
F_SCR
Undocumented dbms_rcvvpc.f_scr(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_scr(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_SCR(USER,'T')
------------------------------------------------------
db_key IN (SELECT db.db_key FROM db) OR db_key IS NULL
 
F_SCRL
Undocumented dbms_rcvvpc.f_scrl(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_scrl(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_SCRL(USER,'T')
----------------------------------------
scr_key IN (SELECT scr.scr_key FROM scr)
 
F_SERVER
Undocumented dbms_rcvvpc.f_server(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_server(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_SERVER(USER,'T')
----------------------------------------------------
filter_user = SYS_CONTEXT('USERENV', 'SESSION_USER')
 
F_SITE_DFATT
Undocumented dbms_rcvvpc.f_site_dfatt(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_site_dfatt(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_SITE_DFATT(USER,'T')
------------------------------------
df_key IN (SELECT df.df_key FROM df)
 
F_SITE_TFATT
Undocumented dbms_rcvvpc.f_site_tfatt(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_site_tfatt(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_SITE_TFATT(USER,'T')
------------------------------------
tf_key IN (SELECT tf.tf_key FROM tf)
 
F_TF
Undocumented dbms_rcvvpc.f_tf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_tf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_TF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_TS
Undocumented dbms_rcvvpc.f_ts(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_ts(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_TS(USER,'T')
----------------------------------------------------
pdbinc_key IN (SELECT pdbinc.pdbinc_key FROM pdbinc)
 
F_TSATT
Undocumented dbms_rcvvpc.f_tsatt(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_tsatt(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_TSATT(USER,'T')
----------------------------------------------------
pdbinc_key IN (SELECT pdbinc.pdbinc_key FROM pdbinc)
 
F_VPC_DATABASES
Undocumented dbms_rcvvpc.f_vpc_databases(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_vpc_databases(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_VPC_DATABASES(USER,'T')
----------------------------------------------------
filter_user = SYS_CONTEXT('USERENV', 'SESSION_USER')
 
F_VPC_USERS
Undocumented dbms_rcvvpc.f_vpc_users(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_vpc_users(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_VPC_USERS(USER,'T')
----------------------------------------------------
filter_user = SYS_CONTEXT('USERENV', 'SESSION_USER')
 
F_WATERMARKS
Undocumented dbms_rcvvpc.f_watermarks(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_watermarks(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_WATERMARKS(USER,'T')
-------------------------------------------------------------
EXISTS (SELECT 1 FROM pdb, db WHERE pdb.pdb_key = db.pdb_key)
 
F_XAL
Undocumented dbms_rcvvpc.f_xal(
schema_p IN VARCHAR2,,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_xal(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_XAL(USER,'T')
------------------------------------------------
dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)
 
F_XCF
Undocumented dbms_rcvvpc.f_xcf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_xcf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_XCF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_XDF
Undocumented dbms_rcvvpc.f_xdf(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_xdf(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_XDF(USER,'T')
----------------------------------------
pdb_key IN (SELECT pdb.pdb_key FROM pdb)
 
F_XMLSTORE
Undocumented dbms_rcvvpc.f_xmlstore(
schema_p IN VARCHAR2,
table_p  IN VARCHAR2)
RETURN VARCHAR2;
SQL> SELECT dbms_rcvvpc.f_xmlstore(USER, 'T')
  2  FROM dual;

DBMS_RCVVPC.F_XMLSTORE(USER,'T')
-----------------------------------------------------
created_user = SYS_CONTEXT('USERENV', 'SESSION_USER')
 
SET_CONTEXT (new 19c)
Undocumented dbms_rcvvpc.set_context(
attribute IN VARCHAR2,
value     IN VARCHAR2);
TBD

Related Topics
Backup & Recovery
Built-in Functions
Built-in Packages
DBMS_BACKUP_RESTORE
DBMS_RCVCAT
DBMS_RCVMAN
RMAN
RMAN Demos
What's New In 18cR3
What's New In 19cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved