Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted May 1, 2003

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

By James Koopmann

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



Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date