How to unregister materialized view from source DB
If a remote MV is no longer available or if you move to a new server because of data migration, version upgrade etc. and somehow don’t need the […]
More DetailsCategory: DBA
How to use Flashback
Flashback feature is available only for enterprise edition. In this article, Oracle 19c has been used for all examples. With flashback feature you can recover your table or […]
More DetailsHow to create a temporary job
Basically, you can create a single scheduler job by the following syntax. This job executes and drops itself automatically. If your procedure that used in the scheduler job […]
More DetailsHow to use Data Pump between different Oracle versions
According to the documentations, if the target database is higher than the source database, the VERSION parameter does not have to be specified. There is an exception, if […]
More DetailsHow to export / import schema with Data Pump
There are several export/import modes. These are listed in the following section. In this article, I am going to explain how to export and import schemas using data […]
More DetailsAdaptive Cursor Sharing & Histograms
Adaptive cursor sharing has been used in Oracle 11g first. This feature enables a single statement that contains bind variables to use multiple execution plans. According to the […]
More DetailsIn-Doubt Transactions and ORA-02049 timeout distributed transaction waiting for lock
Distributed transactions perform DML on multiple databases. If any issue occurs during this transaction such as network or system problems etc. The transaction becomes in-doubt. Normally, Oracle’s RECO […]
More DetailsProxy user authentication
Proxy user authentication allows you to access another schema via a different user. In other words, dba can connect on behalf of a specific user without knowing the […]
More DetailsHow to change database log mode to archiving mode
After connect to the database via SQLPLUS. Shutdown the database using the NORMAL, IMMEDIATE, or TRANSACTIONAL option. We can start the database with mount mode. Now, we can alter the […]
More DetailsCreate an Access Control List (ACL)
Access control list can be created, amended and deleted by DBMS_NETWORK_ACL_ADMIN package. It is used for network access. For instance, XML transfer etc. The following code can create […]
More Details