Objects Option
These views provide information relating to objects created using Oracle’s Objects Option:
- DBA_COLL_TYPES
Lists collection types created.
- DBA_METHOD_PARAMS
Lists all parameters for methods defined in DBA_TYPE_METHODS.
- DBA_METHOD_RESULTS
Lists all method results for methods defined in DBA_TYPE_METHODS.
- DBA_NESTED_TABLES
Lists all nested tables created using features from the Objects Option.
- DBA_OBJECT_TABLES
Lists all tables created using features from the Objects Option.
- DBA_REFS
Lists the REF columns and attributes for objects.
- DBA_TYPE_ATTRS
Lists attributes of all types.
- DBA_TYPE_METHODS
Lists methods created to support each type defined in DBA_TYPES.
- DBA_TYPES
Lists all types created.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.