Import DMP file in to Oracle RDS from EC2 instance

0

So, have some DMP files that was exported from a oracle on premise, using expdp. And now from the linux EC2 instance i need import those dumps that is already there if is possible using the impdp but since there is no access to directory in the RDS instance how to do that?

On linux i hace oracle installed and i can connect by sqlplus in the target db.

已提問 1 年前檢視次數 419 次
3 個答案
1

Hello,

Dump file has to be on the directory which is accessible to RDS instance, in this case its ebs volume attached to RDS.

You would need to enable S3 integration with RDS for Oracle.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/oracle-s3-integration.html

First copy data file to S3, which is accessible by RDS instance.

Copy file using rdsadmin.rdsadmin_s3_tasks.download_from_s3.

Once dump file is copied to RDS volume than you may use EC2 to connect to RDS instance to import using command line utility. or else through pl/sql (sqlplus).

Hope this will help

Thanks

AWS
已回答 1 年前
0

Hi Dear The problem that impdb require directory config that in normal oracle db must be in the same oracle installation server but since i need to import in oracle rds is not possible that is my current issue

已回答 1 年前
  • The file does not have to be physically on the RDS instance

    impdp username@${ORACLE_SID} dumpfile=file.dmp
    
0

The impdp command just take a username@SID in the same way as any database client such as plsql. If you can reach your instance with plsql you should be able to reach it with impdp. There is no requirement that the DMP files reside on the RDS instance.

AWS
管理員
philaws
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南