Oracle | DBMS_ARCH_PROVIDER

Oracle DBMS_ARCH_PROVIDER_INTL Version 21c

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 Database File System Store Content API

AUTHID DEFINER

Dependencies

DBFS_HS$_PROPERTY	DBMS_ASSERT	DBMS_STANDARD
DBFS_HS$_RSEQ	DBMS_DBFS_CONTENT	DBMS_SYSTEM
DBMS_APBACKEND	DBMS_DBFS_CONTENT_ADMIN	DUAL
DBMS_APBACKEND_LIB	DBMS_DBFS_HS

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtpspi.plb

Subprograms

APPENDCACHEJOURNAL	CREATETRACETBL	GETSTORETBLNAME
APTRACE	DELETELRUENTRY	GRANTSELECT
CREATEACCESSTBL	DROPPROVIDERTABLES	REGISTERSTORE
CREATECACHESIZETBL	DROPSTORETBL	RENAMELRUENTRY
CREATECJRNLTBL	DROPSTORETBLS	RENAMELRUSUBENTRIES
CREATEDELBFTBL	GETLOBCACHEUSAGE	SETSTOREPROPERTY
CREATELRUENTRY	GETSTOREGUID	UNREGISTERSTORE
CREATESTORETBLS	GETSTOREPROPERTY	UPDATEACCESSFORLRU
CREATETARBALLTBL

APPENDCACHEJOURNAL

Undocumented dbms_arch_provider_intl.appendCacheJournal( store_name IN VARCHAR2, store_owner IN VARCHAR2, sign IN VARCHAR2, quantity IN NUMBER);

TBD

APTRACE

Undocumented dbms_arch_provider_intl.apTrace( store_name IN VARCHAR2, store_owner IN VARCHAR2, pkg_id IN VARCHAR2, func_name IN VARCHAR2, msg1 IN VARCHAR2, msg2 IN VARCHAR2, msg3 IN VARCHAR2, msg4 IN VARCHAR2, msg5 IN VARCHAR2, msg6 IN VARCHAR2, msg7 IN VARCHAR2, msg8 IN VARCHAR2);

TBD

CREATEACCESSTBL

Undocumented dbms_arch_provider_intl.createAccessTbl( access_tbl_name IN OUT VARCHAR2, tbsname IN VARCHAR2, char_guid IN VARCHAR2);

TBD

CREATECACHESIZETBL

Undocumented dbms_arch_provider_intl.createCacheSizeTbl( cache_usage_tbl_name IN OUT VARCHAR2, tbsname IN VARCHAR2, char_guid IN VARCHAR2);

TBD

CREATECJRNLTBL

Undocumented dbms_arch_provider_intl.createcJrnlTbl( cache_jrnl_tbl_name IN OUT VARCHAR2, tbsname IN VARCHAR2, char_guid IN VARCHAR2);

TBD

CREATEDELBFTBL

Undocumented dbms_arch_provider_intl.createDelBFTbl( delbf_tbl_name IN OUT VARCHAR2, tbsname IN VARCHAR2, char_guid IN VARCHAR2);

TBD

CREATELRUENTRY

Undocumented dbms_arch_provider_intl.createLRUEntry( store_name IN VARCHAR2, store_owner IN VARCHAR2, path IN VARCHAR2, lru_ts_upd_freq IN VARCHAR2);

TBD

CREATESTORETBLS

Undocumented dbms_arch_provider_intl.creatStoreTbls( access_tbl_name IN OUT VARCHAR2, tarball_tbl_name IN OUT VARCHAR2, cache_jrnl_tbl_name IN OUT VARCHAR2, cache_usage_tbl_name IN OUT VARCHAR2, trace_tbl_name IN OUT VARCHAR2, delbf_tbl_name IN OUT VARCHAR2, tbspace IN VARCHAR2, char_guid IN VARCHAR2);

TBD

CREATETARBALLTBL

Undocumented dbms_arch_provider_intl.createTarBallTbl( tarball_tbl_name IN OUT VARCHAR2, tbsname IN VARCHAR2, char_guid IN VARCHAR2);

TBD

CREATETRACETBL

Undocumented dbms_arch_provider_intl.createTraceTbl( trace_tbl_name IN OUT VARCHAR2, tbsname IN VARCHAR2, char_guid IN VARCHAR2);

TBD

DELETELRUENTRY

Undocumented dbms_arch_provider_intl.deleteLRUEntry( store_name IN VARCHAR2, store_owner IN VARCHAR2, path IN VARCHAR2);

TBD

DROPPROVIDERTABLES

Undocumented dbms_arch_provider_intl.dropProviderTables;

exec dbms_arch_provider_intl.dropProviderTables;

      

      PL/SQL procedure successfully completed.

DROPSTORETBL

Undocumented dbms_arch_provider_intl.dropStoreTbl(tbl_name IN VARCHAR2);

TBD

DROPSTORETBLS

Undocumented dbms_arch_provider_intl.dropStoreTbls( store_name IN VARCHAR2, store_owner IN VARCHAR2);

TBD

GETLOBCACHEUSAGE

Undocumented dbms_arch_provider_intl.getLOBCacheUsage( store_name IN VARCHAR2, store_owner IN VARCHAR2) RETURN NUMBER;

TBD

GETSTOREGUID

Undocumented dbms_arch_provider_intl.getStoreGUID(char_guid IN OUT VARCHAR2);

DECLARE

       ioVal dbms_id := SYS_GUID();

      BEGIN

        dbms_output.put_line(ioVal);

        dbms_arch_provider_intl.getStoreGUID(ioVal);

        dbms_output.put_line(ioVal);

      END;

      /

      D5FB742105B64941873D4C9405591C20

      ORABASE21

      

      PL/SQL procedure successfully completed.

GETSTOREPROPERTY

Undocumented dbms_arch_provider_intl.getStoreProperty( store_name IN VARCHAR2, store_owner IN VARCHAR2, prop_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GETSTORETBLNAME

Undocumented dbms_arch_provider_intl.getStoreTblName( store_name IN VARCHAR2, store_owner IN VARCHAR2, tbl_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GRANTSELECT

Undocumented dbms_arch_provider_intl.grantSelect obj IN VARCHAR2, grantee IN VARCHAR2);

TBD

REGISTERSTORE

Undocumented dbms_arch_provider_intl.registerStore( store_name IN VARCHAR2, store_owner IN VARCHAR2, schema_name IN VARCHAR2, meta_store_name IN VARCHAR2, meta_store_mnt IN VARCHAR2, lob_tbs_name IN VARCHAR2, lob_tbl_name IN VARCHAR2, access_tbl_name IN VARCHAR2, cache_jrnl_tbl_name IN VARCHAR2, cache_usage_tbl_name IN VARCHAR2, tarball_tbl_name IN VARCHAR2, trace_tbl_name IN VARCHAR2, delbf_tbl_name IN VARCHAR2, deljob_name IN VARCHAR2);

TBD

RENAMELRUENTRY

Undocumented dbms_arch_provider_intl.renameLRUEntry( store_name IN VARCHAR2, store_owner IN VARCHAR2, oldpath IN VARCHAR2, newpath IN VARCHAR2);

TBD

RENAMELRUSUBENTRIES

Undocumented dbms_arch_provider_intl.renameLRUSubEntries( store_name IN VARCHAR2, store_owner IN VARCHAR2, old_parent_prefix IN VARCHAR2, new_parent_prefix IN VARCHAR2);

TBD

SETSTOREPROPERTY

Undocumented dbms_arch_provider_intl.setStoreProperty( store_name IN VARCHAR2, store_owner IN VARCHAR2, prop_name IN VARCHAR2, prop_value IN VARCHAR2, prop_type IN VARCHAR2);

TBD

UNREGISTERSTORE

Undocumented dbms_arch_provider_intl.unregisterStore( store_name IN VARCHAR2, store_owner IN VARCHAR2);

exec dbms_arch_provider_intl.unregisterStore('UWSTORE', 'C##UWCLASS');

      

      PL/SQL procedure successfully completed.

UPDATEACCESSFORLRU

Undocumented dbms_arch_provider_intl.updateAccessForLRU( store_name IN VARCHAR2, store_owner IN VARCHAR2, path IN VARCHAR2, lru_ts_upd_freq IN VARCHAR2, force_upd IN BOOLEAN);

TBD