Supported Object Types
Here is a glimpse of the supported object types that can be
input to the two previous function calls. Look at the Oracle documentation to
determine the granularity you can achieve.
|
ASSOCIATION
|
associate
statistics
|
|
AUDIT
|
audits
of SQL statements
|
|
AUDIT_OBJ
|
audits
of schema objects
|
|
CLUSTER
|
clusters
|
|
COMMENT
|
comments
|
|
CONSTRAINT
|
constraints
|
|
CONTEXT
|
application
contexts
|
|
DB_LINK
|
database
links
|
|
DEFAULT_ROLE
|
default
roles
|
|
DIMENSION
|
dimensions
|
|
DIRECTORY
|
directories
|
|
FUNCTION
|
stored
functions
|
|
INDEX
|
indexes
|
|
INDEXTYPE
|
indextypes
|
|
JAVA_SOURCE
|
Java
sources
|
|
LIBRARY
|
external
procedure libraries
|
|
MATERIALIZED_VIEW
|
materialized
views
|
|
MATERIALIZED_VIEW_LOG
|
materialized
view logs
|
|
OBJECT_GRANT
|
object
grants
|
|
OPERATOR
|
operators
|
|
OUTLINE
|
stored
outlines
|
|
PACKAGE
|
stored
packages
|
|
PACKAGE_SPEC
|
package
specifications
|
|
PACKAGE_BODY
|
package
bodies
|
|
PROCEDURE
|
stored
procedures
|
|
PROFILE
|
profiles
|
|
PROXY
|
proxy
authentications
|
|
REF_CONSTRAINT
|
referential
constraint
|
|
ROLE
|
roles
|
|
ROLE_GRANT
|
role
grants
|
|
ROLLBACK_SEGMENT
|
rollback
segments
|
|
SEQUENCE
|
sequences
|
|
SYNONYM
|
synonyms
|
|
SYSTEM_GRANT
|
system
privilege grants
|
|
TABLE
|
tables
|
|
TABLESPACE
|
tablespaces
|
|
TABLESPACE_QUOTA
|
tablespace
quotas
|
|
TRIGGER
|
triggers
|
|
TRUSTED_DB_LINK
|
trusted
links
|
|
TYPE
|
user-defined
types
|
|
TYPE_SPEC
|
type
specifications
|
|
TYPE_BODY
|
type
bodies
|
|
USER
|
users
|
|
VIEW
|
views
|
|
XMLSCHEMA
|
XML
schema
|
Where To Go From Here
The direction that Oracle has gone is a good one. I really
love these function calls. You should research and see where it fits into your
organization. The one item I do think is missing is the ability to generate a
full DDL map for an object. I personally would like to execute just one
function and be able to get not only the table DDL, but also all the
constraints, indexes, grants, and so on associated with the table without
having to execute for each and every object type that might make up the table
in question. When Oracle does this, we will truly have a powerful solution to
DDL extraction and be able to, with precision and confidence, do maintenance on
any part of an object within Oracle.
Previous
Prev [1] [2] [3]
