Oracle 18cR3 DBMS_FILE_GROUP_EXP

Oracle DBMS_FILE_GROUP_EXP_INTERNAL Version 18.3.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 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;