Oracle | DBMS

Oracle DBMS_RCVVPC Version 23c

General Information

Library Note

Morgan's Library Page Header

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 -- this package is automatically created as part of the CREATE CATALOG process in RMAN -- use the link at page bottom to go to the DBMS_RCVCAT package link.

Subprograms

FILTER_PASS_ALL	F_FB	F_SERVER
F_AL	F_GRSP	F_SITE_DFATT
F_BCB	F_NODE	F_SITE_TFATT
F_BCF	F_NRSP	F_TF
F_BCR	F_OFFR	F_TS
F_BDF	F_ORL	F_TSATT
F_BP	F_ORSEVENT	F_VPC_DATABASES
F_BRL	F_PDB	F_VPC_USERS
F_BS	F_PDBINC	F_WATERMARKS
F_BSF	F_PDB_DBINC	F_XAL
F_CCB	F_PDB_NODE	F_XCF
F_CCF	F_RCFILE	F_XDF
F_CDF	F_RLH	F_XMLSTORE
F_CFS	F_ROUT	G_TENANT_CSI
F_CKP	F_RR	G_TENANT_GVPC
F_CONF	F_RRCACHE	G_TENANT_KEY
F_CONFIG	F_RSR	G_TENANT_NAME
F_DB	F_RT	G_TENANT_STATUS
F_DBINC	F_SBT_TEMPLATE_DB	IS_TENANT_GVPC
F_DELETED_OBJECT	F_SCR	SET_CONTEXT
F_DF	F_SCRL	SET_TENANT_CTX
F_DO_SEQ

FILTER_PASS_ALL

Undocumented dbms_rcvvpc.filter_pass_all( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.filter_pass_all(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_bal(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_bcb(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_bcf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_bcr(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_bdf(USER, 'T')

      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;

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'))

F_BRL

Undocumented dbms_rcvvpc.f_brl( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_brl(USER, 'T')

      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

      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'))

F_BSF

Undocumented dbms_rcvvpc.f_bsf( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_bsf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_ccb(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_ccf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_cdf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_cfs(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_ckp(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_conf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_config(USER, 'T')

      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

      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)

F_DBINC

Undocumented dbms_rcvvpc.f_dbinc( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_dbinc(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_deleted_object(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_df(USER, 'T')

      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;

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)

F_FB

Undocumented dbms_rcvvpc.f_fb( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_fb(USER, 'T')

      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

      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'))

F_NODE

Undocumented dbms_rcvvpc.f_node( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_node(USER, 'T')

      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

      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'))

F_OFFR

Undocumented dbms_rcvvpc.f_offr( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_offr(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_orl(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_orsevent(USER, 'T')

      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

      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))

F_PDBINC

Undocumented dbms_rcvvpc.f_pdbinc( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_pdbinc(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_pdb_dbinc(USER, 'T')

      FROM dual;

      

      DBMS_RCVVPC.F_PDB_DBINC(USER,'T')

      ----------------------------------------

      pdb_key IN (SELECT pdb.pdb_key FROM pdb)

F_PDB_NODE

Undocumented dbms_rcvvpc.f_pdb_node( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_pdb_node(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_rcfile(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_rlh(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_rout(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_rr(USER, 'T')

      FROM dual;

      

      DBMS_RCVVPC.F_RR(USER,'T')

      ------------------------------------------------

      dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)

F_RRCACHE

Undocumented 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)

F_RSR

Undocumented dbms_rcvvpc.f_rsr( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_rsr(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_rt(USER, 'T')

      FROM dual;

      

      DBMS_RCVVPC.F_RT(USER,'T')

      ------------------------------------------------

      dbinc_key IN (SELECT dbinc.dbinc_key FROM dbinc)

F_SBT_TEMPLATE_DB

Undocumented 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)

F_SCR

Undocumented dbms_rcvvpc.f_scr( schema_p IN VARCHAR2, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_scr(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_scrl(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_server(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_site_dfatt(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_site_tfatt(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_tf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_ts(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_tsatt(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_vpc_databases(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_vpc_users(USER, 'T')

      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;

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)

F_XAL

Undocumented dbms_rcvvpc.f_xal( schema_p IN VARCHAR2,, table_p IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_rcvvpc.f_xal(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_xcf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_xdf(USER, 'T')

      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;

SELECT dbms_rcvvpc.f_xmlstore(USER, 'T')

      FROM dual;

      

      DBMS_RCVVPC.F_XMLSTORE(USER,'T')

      -----------------------------------------------------

      created_user = SYS_CONTEXT('USERENV', 'SESSION_USER')

G_TENANT_CSI

Undocumented dbms_rcvvpc.g_tenant_csi RETURN NUMBER;

SELECT dbms_rcvvpc.g_tenant_csi

      FROM dual;

      

      G_TENANT_CSI

      ------------

G_TENANT_GVPC

Undocumented dbms_rcvvpc.g_tenant_gvpc RETURN VARCHAR2'

SELECT dbms_rcvvpc.g_tenant_gvpc

      FROM dual;

      

      G_TENANT_GVPC

      ---------------

G_TENANT_KEY

Undocumented dbms_rcvvpc.g_tenant_key RETURN NUMBER;

SELECT dbms_rcvvpc.g_tenant_key

      FROM dual;

      

      G_TENANT_KEY

      -------------

G_TENANT_NAME

Undocumented dbms_rcvvpc.g_tenant_name RETURN VARCHAR2;

SELECT dbms_rcvvpc.g_tenant_name

      FROM dual;

      

      G_TENANT_NAME

      -----------------

G_TENANT_STATUS

Undocumented dbms_rcvvpc.g_tenant_status RETURN VARCHAR2;

SELECT dbms_rcvvpc.g_tenant_status

      FROM dual;

      

      G_TENANT_STATUS

      ----------------

IS_TENANT_GVPC

Undocumented dbms_rcvvpc.is_tenant_gvpc RETURN TRUE;

BEGIN

        IF dbms_rcvvpc.is_tenant_gvpc THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

SET_CONTEXT

Undocumented dbms_rcvvpc.set_context( attribute IN VARCHAR2, value IN VARCHAR2);

TBD

SET_TENANT_CTX

Undocumented dbms_rcvvpc.set_tenant_ctx;

exec dbms_rcvvpc.set_tenant_ctx;

      

      PL/SQL procedure successfully completed.