You can check the my script posted at http://www.quest-pipelines.com/pipelines/dba/tips.htm HTHU Ankur Shah Oracle DBA DHG-GA Quoting dba1 mcc <mccdba1@xxxxxxxxx>: > I tried to list all tables under user schema use > "dbms_metadata.get_ddl" but fail. Does anyone know > how to do it? > > SQL> select dbms_metadata.get_ddl( 'TABLE',,'USER1') > from dual; > select dbms_metadata.get_ddl( 'TABLE',,'USER1') from > dual > * > ERROR at line 1: > ORA-00936: missing expression > > > Thanks. > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l