In today’s article we will learn How to See Invalid Object in Oracle Database. We can See Invalid Object using the following code block. [crayon-6866fae5959bd635991912/]
Read More »
In today’s article we will learn How to See Invalid Object in Oracle Database. We can See Invalid Object using the following code block. [crayon-6866fae5959bd635991912/]
Read More »We can see Running Job in Oracle Database using below code block. [crayon-6866fae59713c646778707/]
Read More »In today’s article, I will answer the question of How to Empty the Trash in Oracle Database. To remove the entire contents of your recycle …
Read More »In today’s article, I will share with you the solution to the error I got after restoring the backup database from the RMAN backup. Error: …
Read More »In today’s article we will learn How to See Active Session in Oracle Database. With the help of the code block below, we can see …
Read More »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-6866fae5986bd355463569/] …
Read More »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 »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 »The following error is received when running the datapump with the file size parameter. ERROR : [crayon-6866fae599fc8530057950/] SOLUTION : FILE SIZE parameter limits the size …
Read More »While creating a table got ORA-01950: no privileges on tablespace ‘USERS’. [crayon-6866fae59a215508476389/] SOLUTION : This error comes, when the user the user doesn’t have tablespace quota. 1.Check …
Read More »