A script-enabled browser is required for this page to function properly.

Index: Index Table Name

Skip Navigation Links| Field Descriptions | Related Help Topics | Additional Information | Locating this Page |

Use this page to choose the table on which your index will be based.

Go to topField Descriptions

 

Field Description
Table

Choose the table on which the index will be based. Prefix the table with the schema that owns it, for example, myschema.mytable.

You can choose:

  • Tables owned by the schema you specified in the Schema field in the previous step of this wizard.

  • Tables on which this schema has been granted the INDEX object-level privilege.
Uniqueness

Choose whether the index will be unique or nonunique:

  • UNIQUE - ensures that values in the table columns specified in the next step of this wizard are unique.

  • NONUNIQUE - values in the table columns specified in the next step of this wizard are not unique.
Enable Select to enable the index. Only function-based indexes can be enabled and disabled. A function-based index is based on which table column rows are stored in the database in descending order.

Go to topRelated Help Topics

Concepts:

Related Page Help:

Go to topAdditional Information

Portal Center:

For more information, go to the Oracle Portal documentation page on the Oracle Technology Network.

Go to topLocating this Page

To locate this page in Oracle Portal:

  1. On the Portal Builder page, click the Navigator link.
  2. Click the Database Objects tab.
  3. In the Name column, scroll down to the schema in which you want to build the object.
  4. Click the schema's name.
  5. Click Create New...Index.
  6. Complete each wizard page until you reach this page.
.

Copyright © 1994, 2009, Oracle. All rights reserved.