Oracle Bitmap Index Unleashed: Optimization Made Easy
Oracle provides this nice data retrieving mechanism for low occurrence of DML operation tables. oracle bitmap index is proposed for low cardinality columns. Those kinds of columns in a query ...
Asiri Gunasena
Read More..
19 New Ways to Create an Index in Oracle
This article explains how to create an index in Oracle and the Types of indexes making considerable performance improvements. Here are 19 ways to create an index and below explain ...
Asiri Gunasena
Read More..
Oracle Exception No Data Found: How to handle ora 01403
The Oracle Exception No Data Found in PL/SQL is helping to handle no data return from one of the below-described scenarios. For example, if you SELECT INTO statement does not ...
Asiri Gunasena
Read More..
11 Ways of Oracle “SQL Command Not Properly Ended”
The Oracle return error call “ORA-00933: SQL command not properly ended” once execute a DML operation. That indicates that there’s a problem with your SQL statement syntax. This error triggers ...
Asiri Gunasena
Read More..
Now Oracle can we Delete Temp Tablespace
Oracle can we delete temp tablespace? Yes, it is. Deleting a temporary tablespace in Oracle is a significant database operation that requires extra caring and understanding of its consequences. This ...
Asiri Gunasena
Read More..
How to Add raise_application_error in Oracle
Exception handling is most important in any programming and the same rule applies with Oracle. When a user need to raise a user-defined error from the application raise_application_error allows you ...
Asiri Gunasena
Read More..
How to Solve Oracle expdp ora-01555 snapshot too old
Once you export expdb job to backup the database table this error ORA-01555: snapshot too old: rollback segment number 12 with name might raise. Why is this error raised? One ...
Asiri Gunasena
Read More..
