Home » RDBMS Server » Enterprise Manager » How to get the table creation script (DDL ) in enterprise manager?
How to get the table creation script (DDL ) in enterprise manager? [message #247] Thu, 31 January 2002 19:55 Go to next message
Siddh
Messages: 2
Registered: January 2002
Junior Member
Hi,
I have to study a huge set of database tables (more than say 500). I have installed Oracle Enterprise Manager on my machine and able to see the schema of the tables.
Can anybody tell me how to get the table creation (DDL)scripts, from the schema - in PLAIN TEXT FORMAT.
So that I will use those scripts with some tool like ERWIN and study the entity relationships.

Report message to a moderator

Re: How to get the table creation script (DDL ) in enterprise manager? [message #277 is a reply to message #247] Sat, 02 February 2002 12:32 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
right click on table and select "show object DDL" from drop-down menu.

Report message to a moderator

Previous Topic: Enterprise Manager
Next Topic: how do i know whether i already installed OEM or not?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 04 08:47:11 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.