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

From: dba1 mcc <mccdba1@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 31 Mar 2005 06:10:53 -0800 (PST)

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

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

Other related posts: