I've got a couple of PL/SQL scripts that grab the
table and index DDL and dump out to a file. They'll
do it for a particular schema. I'm also in middle of
converting them over to perl so I'll send that to you
as well. Let me know if you have questions.
hth
mkb
--- Sam Bootsma <[EMAIL PROTECT
Take a look at my site, www.vampired.net, you will find a script to do both,
it can be modified pretty easily to remove the storage clauses.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher