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.