Site icon EasyOraDBA

Migrate from On-Premise 11g (11.2.0.4) to Oracle 18c Autonomous Transaction Processing (ATP) Database using Export/Import EXPDP IMPDP

PATH=$PATH:$HOME/.local/bin:$HOME/bin:/u01/app/oracle/18.3.0/bin
ORACLE_HOME=/u01/app/oracle/18.3.0
ORACLE_BASE=/u01/app/oracle
TNS_ADMIN=/home/opc/orawallet
export ORACLE_HOME ORACLE_BASE TNS_ADMIN

cd /home/opc/orawallet
unzip Wallet_easyoradba.zip

sqlplus admin/**********@easyoradba_high

expdp system@swx directory=export_dir logfile=export.log dumpfile=expswx.dmp schemas=swx parallel=16
create user swx IDENTIFIED by Abcde1234$## ;
grant create session to swx;
grant dwrole to swx;
GRANT UNLIMITED TABLESPACE TO swx;
BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL(
credential_name => 'SWX',
username => 'SWX',
password => '*********'
);
END;
/
-- If you need to re-create, drop the old one and add it again --
BEGIN
DBMS_CLOUD.drop_credential(credential_name => 'ABC');
END;
/
impdp admin@easyoradba_high directory=data_pump_dir credential=swx dumpfile= https://objectstorage.ap-sydney-1.oraclecloud.com/p/YcRteyozj7l7EpFfu6Zr1TWjw7mYeM97JBL96VASXsM/n/sdpxrcjhpsnk/b/easyoradba-migrate/o/exp_swx.dmp parallel=16 remap_tablespace=swx:data encryption_pwd_prompt=yes partition_options=merge transform=segment_attributes:n transform=dwcs_cvt_iots:y exclude=cluster,indextype,materialized_view,materialized_view_log,materialized_zonemap,db_link schemas=swx 

It will ask for the encryption password which we created earlier

The import is now completed and all the objects of on-premise Source schema SWX are now under SWX schema in Target Oracle ATP

Exit mobile version