sqlplus S_GATEONE/12345678
CREATE DIRECTORY DPDUMP_DIR AS '/opt/backup/dpdump';
GRANT READ, WRITE ON DIRECTORY DPDUMP_DIR TO S_GATEONE;
export ORACLE_SID=GATEONE
CREATE USER GATEONE IDENTIFIED BY "121234434";
GRANT CONNECT,RESOURCE,DBA TO GATEONE;
impdp S_GATEONE/12345678 \
dumpfile=gateone.dmp directory=DPDUMP_DIR \
logfile=impd_gateone.log \
TABLE_EXISTS_ACTION=APPEND REMAP_SCHEMA=GATEONE:S_GATEONE \
REMAP_TABLESPACE=GATEONE:TS_GATEONE
DROP USER GATEONE CASCADE;
---------------------------------------------------------------------
export ORACLE_SID=HA
CREATE USER GATEONE IDENTIFIED BY "121234434";
GRANT CONNECT,RESOURCE,DBA TO GATEONE;
impdp S_GATEONE/12345678 \
dumpfile=ha.dmp directory=DPDUMP_DIR \
logfile=impd_ha.log \
TABLE_EXISTS_ACTION=APPEND REMAP_SCHEMA=GATEONE:S_GATEONE \
REMAP_TABLESPACE=HA:TS_HA
DROP USER GATEONE CASCADE;