How 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 DetailsCategory: DBA
How 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. Full Mode Schema Mode Table Mode Tablespace Mode Transportable Tablespace Mode In this article I will discuss about schema mode export […]
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 DetailsData encryption and decryption using PL/SQL
Data encryption is the one of the key feature for security. It can be used for several purposes. I used DBMS_CRYPTO package for this. DBMS_CRYPTO.ENCRYPT function requires the […]
More DetailsORA-12034 materialized view log on younger than last refresh
Hi all, if you encounter ORA-12034 error. It means, a complete refresh is required before the next fast refresh. So, I run the code below in order to […]
More Details