===================DATA PUMP ========================
select * from nls_database_parameters where parameter like '%SET%';
set echo off;
Set pages 999;
set long 90000;
select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb;
select VALUE from v$parameter where name = 'db_block_size';
nohup expdp \"/ as sysdba\" DIRECTORY=DATAPUMP dumpfile=SCNL1_MV_DEMAND_DETAIL_01132018.dmp log=SCNL1_MV_DEMAND_DETAIL_01132018.log tables=SCNL.MV_DEMAND_DETAIL &
nohup impdp \"/ as sysdba\" full=Y directory=exp dumpfile=ESCDB_A%U.dmp logfile=ESCDB_A.log JOB_NAME=FULL_import1 &
http://www.idevelopment.info/data/Oracle/DBA_tips/Enterprise_Manager/OEM_4.shtml
Comments
Post a Comment