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 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 DetailsYou can use the following character classes for your regex pattern. Character Class Description [:alnum:] Alphanumeric characters [:alpha:] Alphabetic characters [:blank:] Blank Space Characters [:cntrl:] Control characters (nonprinting) […]
More DetailsIf you don’t know the user’s password that had been saved in TOAD or SQL DEVELOPER and will expire soon. You can update as it is. In Oracle […]
More Details