I've got an Oracle 12c EE database set up on an RDS box with no SSH access. I do, however, have SQL Developer and SQL PLUS tools.
Is there any way I can restore a full backup into this database using these tools (or any other remote management utility)?
Best Answer
After exchanging several comments I came to know that you have Data Pump file of full database. Anyway you can use the SQL Developer to import export database objects. Just follow the steps:
1) Launch the SQL Developer and go to
View
menu and click onDBA
.2) Then add database connection to perform Data Pump operations.
3) Click on Data Pump and select the appropriate job wizard.
4) Right click on Data Pump and Data Pump import wizard.
Useful link: