Need help importing Oracle .dmp file using remote computer connected to Amazon RDS Oracle Instance

I have an Oracle .dmp file (65 GB) that I have transferred to a remote Amazon Web Services RDS Oracle instance.  The file is an original export (pre version 10) and cannot be imported using the data pump (impdp) commands - unfortunately I also don't have the option to get the file exported using the data pump or I wouldn't be asking this question.  I am currently connected to the Oracle instance using SQLPlus on a windows machine at my home office.  I was able to create a linked server and transfer the file to the remote server into the data pump directory.  However where I am getting stuck is the imp (not impdp command) gives me a cannot open file for read error when I specify the following import command:

imp username/password@remoteserverinstancepath file='/rdsdbdata/datapump/dumpfile.dmp' touser='import_user' fromuser='export_user' log='C:\Temp\importlog.log'

I was able to start up the import from my machine using a the same file but in a local directory on my pc but this is has been running for almost a day and is going very slowly and I may need to abort this import as it looks like it will take days if not a week to complete.  My hunch is my file path is not lining up in the imp command and needs to identify the linked server somewhere in the path.  Unfortunately I cannot find any information on performing a remote import using the original imp commands.  Any help would be appreciated.
Doug HardieAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Using classic imp the file needs to be visible to the machine running the program.  I've also read a lot where Oracle tools have problems using UNC naming conventions.

So, the machine that runs imp needs connectivity to the database and direct access to the file.

Can you SSH into the database server and does that server have direct access to the file?  If so, you can run imp from the database server.

Remember that the classic imp running remotely will run at network speed.  If you have a slow network connection, the data transmission will be slow.
0
Doug HardieAuthor Commented:
Thank you for the suggestion.  I will give it a try tonight and let you know my findings.
0
Doug HardieAuthor Commented:
SSH is unfortunately not an option.  I have changed the way I am doing my import to separate the data to do schema only for now.  I will suggest that if you are going to use Amazon RDS for Oracle.  Make sure you can use the data pump or migration tools, if you want to use the original export for a large database, forget it.

Thanks again for your suggestion.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Check Out How Miercom Evaluates Wi-Fi Security!

It's not just about Wi-Fi connectivity anymore. A wireless security breach can cost your business large amounts of time, trouble, and expense. Plus, hear first-hand from Miercom on how WatchGuard's Wi-Fi security stacks up against the competition plus a LIVE demo!

Geert GOracle dbaCommented:
import without the indexes  
this is usually the slowest part

with imp you can also dump the statements for the indexes into a file > see indexfile parameter
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/oracle-original-import-utility.html#GUID-DC9BBA88-3201-45BF-9F49-83BE6E3530F4
run the index statements  after the import manually

splitting those statements into multiple pieces and running them simultaneously can speed up the process

if you have enterprise, you can build the indexes with parallel n at the end (where n is number of cores on your server)
0
Doug HardieAuthor Commented:
Thanks for the great suggestion.  I will try it if I need to proceed any further with the job.  For now I will consider this matter closed.

-Doug
0
Doug HardieAuthor Commented:
I gave up on trying to run a full import.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
importing

From novice to tech pro — start learning today.