set echo off;
Set pages 999;
set long 90000;
select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb;
Create datapump directory
CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';
GRANT READ, WRITE ON DIRECTORY test_dir TO scott;
nohup expdp \"/ as sysdba\" schemas=SCN,FUND EXCLUDE=STATISTICS ACCESS_METHOD=EXTERNAL_TABLE directory=DATAPUMP dumpfile=DATE_DBNAME_BACKUP.dmp logfile=SATINUAT_BACKUP.log JOB_NAME=FULL_export_A3 &
Import command
impdp \"/ as sysdba\" dumpfile=DATE_DBNAME_BACKUP.dmp DIRECTORY=DATAPUMP logfile=SCNL1_schemas_backup_201805260200.log remap_tablespace=SCN_IMAGE:Scn_TA CLUSTER=N
Set pages 999;
set long 90000;
select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb;
Create datapump directory
CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';
GRANT READ, WRITE ON DIRECTORY test_dir TO scott;
nohup expdp \"/ as sysdba\" schemas=SCN,FUND EXCLUDE=STATISTICS ACCESS_METHOD=EXTERNAL_TABLE directory=DATAPUMP dumpfile=DATE_DBNAME_BACKUP.dmp logfile=SATINUAT_BACKUP.log JOB_NAME=FULL_export_A3 &
Import command
impdp \"/ as sysdba\" dumpfile=DATE_DBNAME_BACKUP.dmp DIRECTORY=DATAPUMP logfile=SCNL1_schemas_backup_201805260200.log remap_tablespace=SCN_IMAGE:Scn_TA CLUSTER=N
we can use for windows machine
ReplyDeleteexpdp dumpfile scehmas=sss.sse dumpfile=xxx.dmp logfile=xx.log
SYS@SMSPSETUP AS SYSDBA