Default tablespace Default tablespace are the oracle tablespace where the objects like Oracle table, oracle index are created by the user when no tablespace name is specified in the object creation clause. We can define both the Permanent and temporary tablespace for the users With 9i , you can specify default permanent and default temp […]
Oracle partition index
In previous article ,we learned about Oracle Partitioned table. In continuation of that series,i will here presenting the Oracle partition index Here are the some of facts about Understanding Partitioned Indexes Local Indexes A local index on a partitioned table is created where the index is partitioned in exactly the same manner as the underlying partitioned […]
how to check all constraints on a table in oracle
Constraints on a table in oracle can be found using the below viewsuser_constraintsall_constraintsdba_constraintsUser_cons_columnsall_cons_columnsdba_cons_columns We can use the view according to the access we have in Oracle database. Now I am going to explain how to check all constraints on a table in oracle using the examples How to find all constraints on a table in […]
Oracle apps queries for APPS DBA
Oracle Apps DBA has to often trouble shoot various issues. I am giving here Top 30 Useful oracle apps queries for DBA To find forms session in Oracle database set linesize 1000 column username format a8 heading “User|Name” column sid format 9999 column serial# format 99999 column user_form_name format a25 column spid format a5 column […]
How to drop constraint in Oracle
Constraints are the ways to enforce data integrity rules in the Oracle database. If we dont require constraint at any point of time, we can drop constraint in Oracle using the alter table command. Lets check with the addition of constraint and then dropping them Constraint creation SQL> CREATE TABLE “DEPT” (“DEPTNO” NUMBER(2,0), “DNAME” VARCHAR2(14), […]
not null constraint in oracle
What is Not Null constraint in oracle Not Null constraints are used to enforce not null values in the column in the table. So if you try to insert null into those column, it will throw error. How to create not null constraint Not null constraints are defined at the table creation or you can […]
