Home » RDBMS Server » Server Administration » get DDL in 8i
get DDL in 8i [message #225576] Tue, 20 March 2007 07:02 Go to next message
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Has any one used any methord to get DDL of a table, in 8i version.i heard 9i has got something called get.ddl function.
Re: get DDL in 8i [message #225578 is a reply to message #225576] Tue, 20 March 2007 07:06 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
in 8i,use the gui tools like toad.
export with rows=n and do a dummy import with show=y logfile=somelog.sql. All your ddl will be available in somelog.sql.
Meanwhile, Please search before posting.
This question is been asked too many times.
Previous Topic: Columns used for partition
Next Topic: How: Script archive log transfer to standby db
Goto Forum:

Current Time: Sun Aug 20 19:51:46 CDT 2017

Total time taken to generate the page: 0.05862 seconds