I have local .dbm file and I want to populate it to Oracle Database on Amazon RDS. I am using Ubuntu on my local machine. I don't seem to have a data pump utility. I cannot find option/settings in SQLDeveloper to pump my local .dbm file to the remote RDS Oracle database. Any suggestions?
Asked
Active
Viewed 334 times
1 Answers
0
I did import DMP files from AWS EC2 to Oracle RDS instance. It is necessary to take several steps:
1) Create a free instance of EC2(1 CPU core, 1G RAM, 30GD HDD ) or a paid instance with a large disk and CPU.
2) Install a free database version of the Oracle XE version on EC2 instance.
3) Copy files to the DUMP directory to Oracle XE on EC2 instance
via the sftp protocol.
4) Transfer files to the RDS instance.
Manual from Amazon Importing Data into Oracle on Amazon RDS
5) Delete files in the DUMP directory EC2
Dmitry Demin
- 2,006
- 2
- 15
- 18