get DDL in 8i [message #225576] |
Tue, 20 March 2007 07:02 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Hi,
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 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
in 8i,use the gui tools like toad.
or
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.
|
|
|