Home » RDBMS Server » Server Administration » using dbms_metadata (Oracle 10G)
using dbms_metadata [message #318407] Tue, 06 May 2008 15:31 Go to next message
ngonsuoi
Messages: 2
Registered: December 2007
Location: usa
Junior Member
I have a need to full all related DDLs (table name, indexes, triggers, grants, etc...) assosciated with a table. Can you assist with this... Thanks.

Report message to a moderator

Re: using dbms_metadata [message #318408 is a reply to message #318407] Tue, 06 May 2008 15:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
dbms_metadata.get_ddl

Report message to a moderator

Re: using dbms_metadata [message #318687 is a reply to message #318407] Wed, 07 May 2008 10:08 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_metada.htm#sthref3536

Report message to a moderator

Previous Topic: its the error
Next Topic: table partition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 06 16:21:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.