Latest Answer : In order to understand wht is a clustered index in oracle it is imp. to know what is a cluster. A cluster is a method to store data for more than 1 table in the same block.This can be compared to a condition where we have a join condtion of 2 tables(primary ...
Hi All, Getting the following error in Oracle9i on AIX, unique index ORA-01652: unable to extend temp segment by 128 in tablespace USERS; though the USER tablespace is of 10gb.Could anyone provide a solution.Regards,Ashish Thomas
Usually if a large amount of data entry/updation/deletion is to be done, the index is dropped and re-created after the data entry/updation/deletion is finished, Why?
How to solve the database block corruption error? even index also validated and recreated and don't have any backup.
Explain how to retrive index values in Oracle SQL?
In Oracle 10g How will you define global index?
Why do we have to rebuild an index?
What is rebuild index, why do we need to rebuild the index?