April 1999
Intermediate to advanced
584 pages
23h 17m
English
The index must be in your schema, or you must have the CREATE ANY INDEX privilege and the INDEX privilege on the table to be indexed to issue this command. If storage options are omitted, Oracle will allocate storage for the index as follows:
If the indexed table has no rows, the default storage values for the tablespace will be used.
If the indexed table has rows and the resulting index can be contained in no more than 25 data blocks, a single extent will be allocated for this index.
If the indexed table has rows and the resulting index is more than 25 data blocks, 5 equal-size extents will be allocated for this index.
Read now
Unlock full access