Re: [Q] how to list all user's table content use dbms_metadata.get_ddl???

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_at_yahoo.com>:

> 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