DDL generate script
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
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'
"Be not afraid of growing slowly. Be afraid only of standing still."
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
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.
sree
try these scripts
i guess this should help
Attached Files
"Be not afraid of growing slowly. Be afraid only of standing still."
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width