Oracle 12cR2 DBMS_FILE_GROUP_EXP

Oracle DBMS_FILE_GROUP_EXP_INTERNAL Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.

Purpose Given an object_id returns the object's schema name. Why anyone thought they needed a stand-alone PL/SQL package for this eludes me

AUTHID DEFINER

Dependencies

DBMS_FILE_GROUP_EXP	OBJ$	USER$
DBMS_STANDARD

Documented No

First Available Unknown

Security Model Owned by SYS with no privileges granted

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

OBJECT_OWNER

Given an object_id returns the object's schema name dbms_file_group_exp_internal(obj_id IN NUMBER) RETURN VARCHAR2;

SELECT object_id

      FROM dba_objects

      WHERE object_name = 'DBMS_FILE_GROUP_EXP_INTERNAL';

      

      SELECT dbms_file_group_exp_internal.object_owner(14026)

      FROM dual;