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
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: Columns used for partition
Next Topic: Oracle 9i CPU Affinity
Goto Forum:
  


Current Time: Fri Sep 20 03:28:19 CDT 2024