Contact

Tag: impdp

  1. You are here »
  2. Home »
  3. Tag »
  4. impdp »

AWS RDS Oracle import fails with ORA-06512

Recently I encountered an issue while importing schema to AWS RDS Oracle.  Where the size of the export dump file is approx 1.8 GB.  Import failed with the following error: SQL> Connected. SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 […]

oracle impdp as sysdba and attach job

impdp allows Oracle DBA to exit out of the current process while the job continues to run in the background.  In the event you have to connect to the job and take some action, below is how that can be accomplished: In the following example job name is – “my_job” impdp \”/as sysdba\” attach=my_job Once […]

Categories