how to list all table info use dbms_metadata.get_ddl????

From: aaa <mccdba_at_yahoo.com>
Date: 1 Apr 2005 04:44:53 -0800
Message-ID: <d2jfo502o49@drn.newsguy.com>

I tried to list all tables under user's 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. Received on Fri Apr 01 2005 - 06:44:53 CST