I am just starting out as Oracle DBA, been on other RDBMS. I finished exp/imp a schema from from another oracle instance. Everything looked good except: select dbms_metadata.get_granted_ddl ('SYSTEM_GRANT','XXXX') from dual; DBMS_METADATA.GET_GRANTED_DDL( 'SYSTEM_GRANT','XXXX') ------------------------------ ------------------------------ --------------------
