DDL Generation--Oracle's Answer to Save You Time and Money - Page 3

May 1, 2003

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.

» See All Articles by Columnist James Koopmann








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers