01490-01499: Miscellaneous, ANALYZE, SQL Parsing, Execution

This section lists miscellaneous messages generated by secondary processes called by the current process, such as the ANALYZE command, the SQL parser, and during the execution of Oracle commands.

Cause:	The syntax of the ANALYZE command was incorrect.

Action:	Check the syntax and enter the command using the correct syntax.

ORA-01491 CASCADE option not valid

Cause:	The CASCADE option should be used only for tables or clusters.

Action:	Do not use the CASCADE option in this manner. Check the syntax of the statement and then retry.

ORA-01492 LIST option not valid

Cause:	The LIST option can be used only for tables or clusters.

Action:	Do not use the LIST option in this manner. Check the syntax of the statement and then retry.

ORA-01493 invalid SAMPLE size specified

Cause:	The specified SAMPLE size is out of range

Action:	Specify a value within the proper range.

ORA-01494 invalid SIZE specified

Cause:	The specified histogram SIZE value was out of range.

Action:	Specify a value within the proper range.

For more information about histograms, see Oracle7 Server Tuning.

Cause:	The specified table does not exist, or the user does not have the proper privileges to access it.

Action:	Specify an existing table or obtain the privileges to access the desired table.

ORA-01496 specified chain row table form incorrect

Cause:	The specified table does not have the proper field definitions.

Action:	Check the spelling of the table name and specify the correct table to use.

ORA-01497 illegal option for ANALYZE CLUSTER

Cause:	The FOR COLUMNS <column list> clause cannot be used with ANALYZE CLUSTER.

Action:	Retry with a legal syntax.

For more information about ANALYZE CLUSTER, see the index entry on "ANALYZE CLUSTER" in Oracle7 Server SQL Reference.

Cause:	An error occurred while checking a block with the ANALYZE command.

Action:

Check the trace file for more descriptive messages about the problem. Correct these errors. The name of the trace file is operating system-specific, for example, ORAxxxx.TRC. It is found in the directory specified by the initialization parameter USER_DUMP_DEST. If USER_DUMP_DEST is not set, trace files are not created. It may be necessary to recreate the object. See also your operating system-specific Oracle documentation.

ORA-01499 table/Index Cross Reference Failure - see trace file

Cause:	An error occurred when validating an index or a table using the ANALYZE command. One or more entries does not point to the appropriate cross-reference.

Action:

Check the trace file for more descriptive messages about the problem. Correct these errors. The name of the trace file is operating system-specific, for example, ORAxxxx.TRC. It is found in the directory specified by the initialization parameter USER_DUMP_DEST. If USER_DUMP_DEST is not set, trace files are not created. It may be necessary to recreate the object. See also your operating system-specific Oracle documentation.