Export and Import in AWS Cloud
Below is the steps to do export and import in AWS Cloud Environment 1.CONNECT TO PROD AWS CLOUD FROM LOCAL PROD DB sqlplus root/<root_password>@awscld 2.EXPORT DECLARE hdnl NUMBER; BEGIN hdnl := DBMS_DATAPUMP.OPEN( operation => ‘EXPORT’, job_mode => ‘SCHEMA’, job_name=>null); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<DUMP_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_dump_file); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<EXPDUMP_LOG_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_log_file); DBMS_DATAPUMP.METADATA_FILTER(hdnl,’SCHEMA_EXPR’,’IN (”<SCHEMA_NAME>”)’); DBMS_DATAPUMP.START_JOB(hdnl); END; / 3.CHECK THE STATUS OF THE EXPORT BY USING BELOW QUERY SELECT text FROM table(rdsadmin.rds_file_util.read_text_file(‘DATA_PUMP_DIR’,'<DUMP_LOG_NAME>’)); 4.MOVE THE DUMP FILE TO AWS DEV CLOUD Move the DUMP to AWS DEV CLOUD…
Read More