OraFAQ Forum: Server Administration » where is my DDL by which i created table?

Home » RDBMS Server » Server Administration » where is my DDL by which i created table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

where is my DDL by which i created table? [message #123115]

Thu, 09 June 2005 21:09

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

Can any one tell me from where i can find the ddl by which i had created table.

Note:- I need that query to execute on another server so i need its DDL

I hope you understand above question....

Thank you
Yours faithfully
Sunilkumar

Report message to a moderator

Re: where is my DDL by which i created table? [message #123122 is a reply to message #123115]

Thu, 09 June 2005 23:02

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please search before posting.
These are answered many times.
http://www.orafaq.com/forum/t/26854/0/
The same methods discuccessed would apply here
1. with export/import use indexfile option to get ddl for tables.
or
2. use DBMS_METADATA

[Updated on: Thu, 09 June 2005 23:05]

Report message to a moderator

Re: where is my DDL by which i created table? [message #123307 is a reply to message #123115]

Sat, 11 June 2005 11:52

OLarry
Messages: 6
Registered: June 2005

Junior Member

you can either use DBMS_METADATA if your Oracle server is 9i or above.

Or the easiest way is to use some tools like TOAD, DBArtisan (but they are expensive though).. I recently downloaded the trial version of DataStudio from http://www.agileinfollc.com, seemed easy to use too... anyone has used this company's products?

[Updated on: Sat, 11 June 2005 11:54]

Report message to a moderator

Previous Topic:	State of sequence in full db exp/imp
Next Topic:	ODBC drivers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 13 04:20:22 CDT 2026