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 […]
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 […]