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 is a database schema in oracle?
What are the logical operations?
Explain an index?
Is rowid unique in oracle?
How would you begin to troubleshoot an ORA-3113 error?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain what are the uses of rollback segment?
How to retrieve the count of updated rows?
Is there an oracle sql query that aggregates multiple rows into one row?
How to use windows user to connect to the server?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is a sub query? Describe its types?
how to make an oracle object
How to execute the package in oracle?