Oracle | DBMS_FILE_GROUP_UTL

Oracle DBMS_FILE_GROUP_UTL_INVOK 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 Internal utilities for building and managing a File Group repository.

AUTHID CURRENT_USER

Dependencies

DBMS_DATAPUMP	DBMS_STREAMS_TABLESPACE_ADM	KU$_JOBDESC
DBMS_FILE_GROUP	DBMS_STREAMS_TBS_INT	KU$_LOGENTRY
DBMS_FILE_GROUP_DECL	DBMS_STREAMS_TBS_INT_INVOK	KU$_LOGLINE1010
DBMS_FILE_GROUP_INTERNAL_INVOK	DBMS_SYSTEM	KU$_STATUS
DBMS_FILE_GROUP_LIB	DBMS_UTILITY	KUPCC
DBMS_FILE_GROUP_UTL	FGR$_FILE_GROUP_FILES	PLITBLM
DBMS_LOGREP_UTIL	FGR$_FILE_GROUP_VERSIONS	UTL_FILE
DBMS_STANDARD

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthfgr.plb
{ORACLE_HOME}/rdbms/admin/prvtbfgr.plb

Subprograms

AUTO_PURGE_FILE_GROUP	LOAD_DATAPUMP	PURGE_FILE_ONDISK
CHECK_PRIVILEGE_ON_FILE_GROUP	PURGE_FILE_GROUP	PURGE_VERSION
CHECK_SYSTEM_PRIVILEGE	PURGE_FILE_METADATA	UNLOAD_DATAPUMP

AUTO_PURGE_FILE_GROUP

Undocumented dbms_file_group_utl_invok.auto_purge_file_group( fg_rec IN sys.dbms_file_group_decl.file_group_rec);

TBD

CHECK_PRIVILEGE_ON_FILE_GROUP

Undocumented dbms_file_group_utl_invok.check_privilege_on_file_group( canon_file_group_own IN VARCHAR2, canon_file_group_name IN VARCHAR2, privilege IN BINARY_INTEGER);

TBD

CHECK_SYSTEM_PRIVILEGE

Undocumented dbms_file_group_utl_invok.check_system_privilege;

exec dbms_file_group_utl_invok.check_system_privilege;

      

      PL/SQL procedure successfully completed.

LOAD_DATAPUMP

Undocumented dbms_file_group_utl_invok.load_datapump( file_name IN VARCHAR2, canon_dir_obj IN VARCHAR2, canon_owner OUT VARCHAR2, canon_tab_view_name OUT VARCHAR2, canon_tts_view_name OUT VARCHAR2, canon_mt_name OUT VARCHAR2, dp_job_desc OUT public.ku$_jobdesc);

TBD

PURGE_FILE_GROUP

Undocumented dbms_file_group_utl_invok.purge_file_group( fg_rec IN sys.dbms_file_group_decl.file_group_rec, keep_files IN BOOLEAN);

TBD

PURGE_FILE_METADATA

Undocumented dbms_file_group_utl_invok.purge_file_metadata( file_name IN VARCHAR2, file_type IN VARCHAR2, version_guid IN RAW);

TBD

PURGE_FILE_ONDISK

Undocumented dbms_file_group_utl_invok.purge_file_ondisk( file_name IN VARCHAR2, canon_file_dir_obj IN VARCHAR2, file_type IN VARCHAR2);

TBD

PURGE_VERSION

Undocumented dbms_file_group_utl_invok.purge_version( version_guid IN RAW, keep_files IN BOOLEAN);

TBD

UNLOAD_DATAPUMP

Undocumented dbms_file_group_utl_invok.unload_datapump( canon_owner IN VARCHAR2, canon_tab_view_name IN VARCHAR2, canon_tts_view_name IN VARCHAR2, canon_mt_name IN VARCHAR2);

TBD