Check Pre-structure Data Pumps




   select * from nls_database_parameters;

   select name,(bytes/1024/1024/1024) from v$datafile;

   select file_id,file_name,(bytes/1024/1024/1024) from dba_data_files;

   

   set pagesize 0

   set long 100000

   --

   SELECT dbms_metadata.get_ddl('USER','MEAI') FROM dual;

   SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','MEAI') from dual;


Post a Comment

0 Comments