Transfer the dump-file from On premise to RDS instance of AWS using DBMS_FILE_TRANSFER

Transfer the dump-file from On premise to RDS instance of AWS:
===============================================================


prerequisite :
============

• create public db link in source database pointing to AWS RDS instance
• DB link should be working fine

Command:

============

BEGIN

DBMS_FILE_TRANSFER.PUT_FILE(

source_directory_object =>'DATA_PUMP_DIR',

source_file_name =>'test1_full_db.dmp',

destination_directory_object =>'DATA_PUMP_DIR',

destination_file_name => 'test1_full_db.dmp',

destination_database =>'AWS_RDS'

);

END;

/

SQL>

SQL>

SQL>

SQL> BEGIN

DBMS_FILE_TRANSFER.PUT_FILE(

source_directory_object =>'DATA_PUMP_DIR',

source_file_name =>'test1_full_db.dmp',

destination_directory_object =>'DATA_PUMP_DIR',

destination_file_name => 'test1_full_db.dmp',

destination_database =>'AWS_RDS'

);

END;

/  2    3    4    5    6    7    8    9   10