DDL generate script

[vinodkmg]

Hi All,

Can anyone provide a script which could generate "create" DDL script for tables & indexes in a schema.I have one which can handle with non partition tables and indexes.I need now for both partition tables & indexes(LOCAL) with storage clause as well.

Thanks in advance.
Regards,
Vinod

[SANJAY_G]

www.databee.com


Sanjay

[pgoenka]

which version of oracle r u using
if its 9i try this ... u might neet to set long to a big value
like
set long 100000

Select dbms_metadata.get_ddl('TABLE',TABLE_NAME)
from
user_tables
where
nested = 'NO'

[vinodkmg]

Guys thanks for your replies.
I am using 8.1.7 version.Databee doesnt work...its crashes with illigal operation when i start after download.

any other ?
regards,
Vinod

[sree_sri]

Try DBArtisan, You will get 15days or 1 months free.

http://www.embarcadero.com/products/dbartisan/index.asp

By using this you can generate all objects info in html format also.

Good Luck.

Sree.

[pgoenka]

try these scripts
i guess this should help