HS_EXTERNAL_OBJECTS
contains information about all of the distributed external objects accessible from the Oracle server.
Column | Datatype | NULL | Description |
---|---|---|---|
FDS_CLASS_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the FDS Class |
FDS_INST_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the FDS instance |
OWNER |
VARCHAR(30) |
NOT NULL |
Name of the user who created the object |
OBJECT_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object; unique for each instance |
OBJECT_TYPE |
VARCHAR2(13) |
NOT NULL |
Type of object: FUNCTION , PROCEDURE , PACKAGE , or LIBRARY |
OBJECT_TEXT |
LONG |
NOT NULL |
SQL text used to create the object |