Name of the base table on which the hash index is defined.
You cannot define a hash index on any of the following database objects:
- Column-partitioned tables
- Global temporary tables
- Global temporary trace tables
- Hash indexes
- Join indexes
- Journal tables
- NoPI tables
- Queue tables
- Views (neither recursive nor nonrecursive)
- Volatile tables
Note that you cannot create a hash index on a PPI table if the partitions for the table are defined on PERIOD bound functions.
- database_name
- user_name
-
Name of the containing database or user for table_name if other than the containing database or user specified for hash_index_name.