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 |