Amazon-rds – Oracle data pump export / import errors

amazon-rdsoracleoracle-11g

I'm attempting to export from a physical Oracle 11.2.0.3.0 database to a amazon rds Oracle database.
I used the expdp and exported a full database and incurred no errors upon export.

I've moved the copy over to my server running SQL Developer in my AWS environment, and using the impdp command I incur a slew of errors.

I've seen snippets in my searches for a few things, but having tried suggestions, it seems that isn't the error. 

c:\Windows\system32\> impdp c2sadmin@x.x.x.x:1521/DATABASE file=e:\export\full_export.sql log=e:\export\import.log

Running the above command I get the below. 

Import: Release 11.2.0.1.0 - Production 
Connected to Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
ORA-31626: job does not exist
ORA-04063: package body "SYS.DBMS_INTERNAL_LOGSTDBY" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_INTERNAL_LOGSTDBY"
ORA-06512: at "SYS.KUPV$FT", line 1009
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_LOGREP_UTIL
ORA-20900: RDS restricted DDL Found: ALTER VIEW SYS.ALL_CAPTURE
ORA-06512: at "RDSADMIN.RDSADMIN", line 367
ORA-06512: at line 2
ORA-04063: view "SYS.DBA_CAPTURE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGPREP_UTIL"

I've tried different schemas and all end with the same error.
Looking AWS disabled the … AS SYSDBA option with logging in, so I can't do that either.

I've seen some random web posts regarding datapump and RDS not playing nicely, but I can't get anything concrete.

Our DBA's have assured me that the data pump export worked flawlessly, as they could import it to another physical oracle database. So could this just be an RDS issue and not Oracle?

Best Answer

After hours of trying numerous things I've found this as to answer my question. On a tip of an Oracle Community discussion, I was told to run this below. 

select comp_id, version, status, comp_name
from dba_registry
where comp_id='SDO';

This would tell me if I am or not running Oracle Spatial on my existing database that I ran the export from. Now, why I bring this up is I've asked numerous people in my organization if we're using spatial and numerous people have swore up and down we don't. Come to find out, the database is installed with spatial and that above sql script showed me that yes, it is running spatial.

RDS won't accept spatial data, even if there is no spatial data in it. So I'm in the process of installing an EC2 instance with 11gR2 and actually importing the data that way. This is why the stored procedures failed as above. I just don't know why our AWS team didn't catch this when I submitted my trouble ticket. Oh well.

Thanks for all of the help.

Related Question