[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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » [Q] how to list all user's table content use dbms_metadata.get_ddl???
