spooling out table definitions (structure) from sqlplus

[slimdave]

Here's a DBMS_METADATA sample ...

Set Long 100000 Pagesize 0
Execute DBMS_Metadata.Set_Transform_Param(Dbms_Metadata.Session_Transform,'STORAGE',False);
Select  DBMS_Metadata.Get_DDL('TABLE',table_name) From user_tables;
Select  DBMS_Metadata.Get_DDL('INDEX',index_name) From User_Indexes;