Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
where are oracle ddl(create table, create index etc) stored?
- Thread starter kanghao
- Start date
- Thread starter
- #2
Depends on the object:
{ALL|DBA|USER}_SOURCE
{ALL|DBA|USER}_VIEWS
{ALL|DBA|USER}_REPDDL
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
PS: Create table and Create index DDL may have to be generated with the DBMS_METADATA package.
![[3eyes]](/data/assets/smilies/3eyes.gif "[3eyes] [3eyes]")
-- OR -- Search this forum for other options.
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
- Status
Similar threads
- Question
