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

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 31 Mar 2005 06:10:53 -0800 (PST)
Message-ID: <20050331141053.45858.qmail@web60809.mail.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

Received on Thu Mar 31 2005 - 09:14:36 CST