InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Happens If A Primary Key Constraint Is Disabled And Then Enabled Without Fully Specifying The Index Clause? |
|
Answer» The index is created in the users DEFAULT TABLESPACE and all SIZING information is LOST. Oracle doesn't store this information as a part of the constraint definition, but only as part of the index definition, when the constraint was disabled the index was dropped and the information is gone. The index is created in the users default tablespace and all sizing information is lost. Oracle doesn't store this information as a part of the constraint definition, but only as part of the index definition, when the constraint was disabled the index was dropped and the information is gone. |
|