Release 8.0.4
A58312-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Error Messages Release 8.0.4 A58312-01 |
|
This section lists messages that occur when commands are used that affect hash clusters.
Cause: The IS keyword is missing from the CREATE CLUSTER command.
Action: Check the syntax of the command and retry the statement.
Cause: The HASHKEYS option of the CREATE CLUSTER command is specified more than once.
Action: Check the syntax of the command, make certain to specify the HASHKEYS option only once, then retry the command.
Cause: The value specified for HASHKEYS must be an integer.
Action: Check the syntax of the command, make certain to specify an integer for the HASHKEYS option, then retry the command.
Cause: The HASH IS option is specified more than once.
Action: Check the syntax of the command, make certain to specify the HASH IS option only once, then retry the command.
Cause: The SIZE option specified for this hashed cluster is to small.
Action: Retry the statement using a larger value for the SIZE option.
Cause: An attempt was made to create a cluster using the HASH IS option with a number of key columns other than 1. Specify only one key column when using the HASH IS option.
Action: Check the syntax of the command. Either specify only one key column or do not specify the HASH IS option, then retry the command.
Cause: The column specification in the command must specify an integer.
Action: Check the syntax of the command, make certain to specify an integer for the column specification, then retry the command.
Cause: An attempt was made to create a cluster with the HASH IS option without specifying a valid column name.
Action: Check the syntax of the command. Specify a valid column name in the statement, then retry the statement.
Cause: An attempt was made to create a hash cluster without specifying the HASHKEYS option in the statement.
Action: Check the syntax of the command, specify the HASHKEYS option, and retry the command.
Cause: The value specified for HASHKEYS was not a positive integer.
Action: Check the syntax of the command, specify only positive integers for the HASHKEYS option, then retry the command.
Cause: An attempt was made to create a cluster index on a hash cluster.
Action: Creation of cluster indexes on hash clusters is not allowed. Do not attempt to create this index.
Cause: The INDEX option cannot be specified for hash clusters.
Action: Check the syntax of the command. Do not specify the INDEX option with hash clusters.
Cause: The INDEX option is specified more than once.
Action: Check the syntax of the command, correct the problem, then retry the statement.
Cause: The HASH IS option is specified more than once.
Action: Check the syntax of the command, correct the problem, then retry the statement.
Cause: Both the HASH IS and INDEX option were specified. Clusters can be hash or indexed, but not both.
Action: Decide on which type of cluster is to be created, check the syntax of the command, then retry the statement.
Cause: The HASH IS option is valid only for clusters.
Action: Check the syntax of the command, use the HASH IS option only for clusters, then retry the command.
Cause: An attempt was made to change the SIZE option of a hash cluster after the cluster was created.
Action: The SIZE option can be specified only when creating the hash cluster. Do not attempt to alter the SIZE of the cluster.
Cause: A column referenced in a hash expression is not present in the cluster definition.
Action: Recreate the cluster and correct the error in the hash expression.
Cause: A constant or system variable is specified in the hash expression.
Action: Recreate the cluster and correct the error in the hash expression.
Cause: The result of evaluating a hash expression is not an Oracle Number.
Action: Recreate the cluster and correct the error in the hash expression.
Cause: TO_DATE, USERENV, and SYSDATE are not allowed in hash expressions.
Action: Recreate the cluster and correct the error in the hash expression.
Cause: SYSDATE, UID, USER, ROWNUM, OR LEVEL are not allowed in hash expression(s).
Action: Recreate the cluster and correct the error in the hash expression.
Cause: A PL/SQL function is used in a hash expression.
Action: Recreate the cluster and remove the PL/SQL function.
Cause: An error occurred while evaluating the cluster's hash expression.
Action: Correct the query and retry.
Cause: The number of extents required for creating the fixed hash area exceeded the maximum number allowed.
Action: Reduce the number of extents required by increasing the extent allocation sizes within the STORAGE clause. For more information about hashing and the STORAGE clause, see the index entries on "hash cluster" and on "hashing" in Oracle8 Server Concepts and on "STORAGE clause, of ALTER CLUSTER" in Oracle8 Server SQL Reference.
Cause: The number of blocks in a cluster chain exceeds the maximum number allowed.
Action: Increase SIZE parameter in CREATE CLUSTER statement or reconsider suitability of cluster key.
