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 DetailsBasically, 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 DetailsAccording 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 DetailsThere 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 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 DetailsDistributed 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 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 DetailsAfter 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 DetailsAccess 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 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 DetailsHi 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