Oracle Database Discussions

Hi,

Can any1 tell me how to get the DDL metadata information abt a particular Schema creation in Oracle DB . Below is what i have found to get the DDL metadata abt the roles granted to a particular user

SQL> select DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','P688645') from dual;

DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','P688645')
--------------------------------------------------------------------------------

   GRANT "CONNECT" TO "P688645"

   GRANT "UNISON_ROLE" TO "P688645"

Edited by: 832812 on Mar 16, 2011 9:26 PM