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, I will share with you the solution to the error I got after restoring the backup database from the RMAN backup. Error: …
Read More »It may be necessary to temporarily stop a running export/import process for some reason. In this case, we may need to attach it first. 1. …
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 »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 »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 »Instead of constantly writing our command and parameters for export/import operations, we can create a file containing our parameters and use this file in export/import …
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-63d834ff93e9e019858655/] …
Read More »With the SQLFILE parameter, it provides us with the sql statements that import operations run. [crayon-63d834ff94ec2817551798/] Afterwards, you can see which commands are available by …
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 »In today’s article we will learn how to use the Estimate_only parameter for Dump File Size Estimation. [crayon-63d834ff953e5533698673/]
Read More »