Notes
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.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
