Answer Posted / nishi
Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the default admin accounts in Oracle 10g ?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to rename an index in oracle?
Explain about your project and its relation to the current job position you are applying to?
What are the limitations oracle database 10g xe?
Whether any commands are used for months calculation? If so, what are they?
What are transaction isolation levels supported by oracle?
What are joins, explain all types of joins?
Explain a private synonyms?
What is Reduced List of Values?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How do I know if oracle is installed on windows?
How to use subqueries with the exists operator in oracle?
Explain oracle insert into command?