We can monitor the status of an export/import operation running in the background by attaching it with the ATTACH parameter. For this, we first need …
Read More »ORACLE
Oracle Invalid Objects
In today’s article, How Can I See Invalid Object in Oracle Database? I will be answering the question. We can see with the help of …
Read More »ORA-01000: Maximum Open Cursors Exceeded
This error can occur if the Oracle open_cursors parameter is too low or there is a coding issue where sql statements are not closed. [crayon-66350907ed628715285590/] …
Read More »Oracle List Contents Of Dump File
With the SQLFILE parameter, it provides us with the sql statements that import operations run. [crayon-66350907ed843895511921/] Afterwards, you can see which commands are available by …
Read More »ORA-00020: Maximum Number Of Processes Exceeded
When i tried to connect to database, I got the ORA-00020: maximum number of processes (%s) exceeded error. Even from sysdba I was not able …
Read More »Dump File Size Estimation
In today’s article we will learn how to use the Estimate_only parameter for Dump File Size Estimation. [crayon-66350907edbad876235047/]
Read More »Interactive Command Line
While the Export or Import process is in progress, we can switch to the interactive command line mode with Ctrl+C from the keyboard. We can …
Read More »ORA-39358
I got this error while importing dump file: ORA-39358: Export dump file version 12.2.0.1.0 not compatible with target version 11.2.0.4.0 . SOLUTION: First we check …
Read More »Data Pump Jobs Kill
In today’s article, I will tell you how to Kill Data Pump Jobs in 3 steps. 1. First, Data Pump Jobs are listed. [crayon-66350907ee237174068714/] 2. …
Read More »ORA-39095: Dump File Space Has Been Exhausted: Unable To Allocate
The following error is received when running the datapump with the file size parameter. ERROR : [crayon-66350907ee47b152751160/] SOLUTION : FILE SIZE parameter limits the size …
Read More »