Schema Refresh

 Export schema DATCREDITOCO

select owner,segment_name,sum(bytes/1024/1024) from dba_segments where segment_name='DATCREDITOCO';

select owner,segment_name,sum(bytes/1024/1024) from dba_segments where owner='DATCREDITOCO';

expdp directory=EXPIMP dumpfile=SR3367495_DATCREDITOCO.dmp logfile=SR3367495_DATCREDITOCO.log schemas=DATCREDITOCO


expdp  schemas=CONVERSION  directory=EXP_HDD dumpfile=CONVERSION_data.dmp logfile=CONVERSION.log content=METADATA_ONLY

impdp  remap_schema=CONVERSION:QA_CONVERSION  directory=EXP_HDD dumpfile=CONVERSION_data.dmp logfile=QA_CONVERSION.log content=METADATA_ONLY

select owner,count(*) from dba_objects where owner in ('CONVERSION','QA_CONVERSION');

expdp  schemas=CONVERSION  directory=EXP_HDD  logfile=CONVERSION.log  ESTIMATE_ONLY=y

content=METADATA_ONLY

create user QA_CONVERSION  identified by welcome default tablespace DATA TEMPORARY TABLESPACE "TEMP2";
grant create session,connect to QA_CONVERSION;


DEFAULT TABLESPACE "DATA"
      TEMPORARY TABLESPACE "TEMP2"

select dbms_metadata.get_ddl( 'USER', 'CONVERSION' ) from dual;
UNION ALL
select dbms_metadata.get_granted_ddl( 'SYSTEM_GRANT', 'CONVERSION' ) from dual;
UNION ALL
select dbms_metadata.get_granted_ddl( 'OBJECT_GRANT', 'CONVERSION' ) from dual;
UNION ALL
select dbms_metadata.get_granted_ddl( 'ROLE_GRANT', 'CONVERSION' ) from dual;
union all
select dbms_metadata.get_granted_ddl( 'TABLESPACE_QUOTA', 'CONVERSION' ) from dual;

Exportar schema DATCREDITOCO

select owner,segment_name,sum(bytes/1024/1024) from dba_segments where segment_name='DATCREDITOCO';

select owner,segment_name,sum(bytes/1024/1024) from dba_segments where owner='DATCREDITOCO';


expdp directory=EXPIMP dumpfile=SR3367495_DATCREDITOCO.dmp logfile=SR3367495_DATCREDITOCO.log schemas=DATCREDITOCO


================================================================
expdp  DIRECTORY=data_pump_dir DUMPFILE=demo02.dmp SCHEMAS=uwclass,scott

select owner,segment_name,sum(bytes/1024/1024) from dba_segments where segment_name='uwclass';


select owner,segment_name,sum(bytes/1024/1024) from dba_segments where segment_name in ('uwclass','scott) groupby owner;

select owner,segment_name,sum(bytes/1024/1024) from dba_segments where owner='DATCREDITOCO';
select owner,segment_name,sum(bytes/1024/1024/1024) from dba_segments where segment_name='SONIC' group by owner,segment_name;

select owner,segment_name,sum(bytes/1024/1024) from dba_segments where owner='CONVERSION';

expdp directory=EXPIMP dumpfile=SR3367495_DATCREDITOCO.dmp logfile=SR3367495_DATCREDITOCO.log schemas=DATCREDITOCO


SELECT sum(bytes)/1024/1024/ as "Size in MB" from dba_segments WHERE owner = UPPER('&schema_name');

CONVERSION

expdp scott/tiger@db10g schemas=SONIC directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log

impdp scott/tiger@db10g schemas=SONIC directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log


     USER# NAME 			  PASSWORD
---------- ------------------------------ ------------------------------
	 5 SYSTEM			  26FAF27DF4707BC7


production:
DBMS_METADATA.GET_DDL('USER','SYSTEM')
--------------------------------------------------------------------------------

   ALTER USER "SYSTEM" IDENTIFIED BY VALUES '26FAF27DF4707BC7'
      TEMPORARY TABLESPACE "TEMP"


======================

impdp new_scott/tiger directory=MY_DUMP_DIR LOGFILE=dblink_transfer.log 
network_link=SOURCE_DB remap_schema=scott:new_scott

impdp system/manager directory=Mig1 LOGFILE=dblink_transfer.log network_link=system/manger@actional schemas=sonic


impdp system/manager directory=Mig1 LOGFILE=dblink_transfer.log network_link=ddump schemas=sonic
==============================