oracle DDL 系列， 重建数据库

SELECT grantee, granted_role FROM dba_role_privs WHERE grantee = :user


SELECT grantee, privilege FROM dba_sys_privs WHERE grantee = :user

SELECT grantee, privilege FROM dba_sys_privs WHERE grantee = :user

得到非queue的tables

SELECT OBJECT_NAME
  FROM dba_objects
 where owner = :owner1
   AND OBJECT_TYPE = 'TABLE'
   AND object_name not in (SELECT t.queue_table
                             FROM dba_queue_tables t
                        	 WHERE t.owner = :owner2)
   AND object_name not like 'SYS%'
   AND object_name not like 'AQ$%'
311