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

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.

ORA-01490: invalid ANALYZE command

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 Oracle8 Server Tuning.

ORA-01495: specified chain row table not found

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 Oracle8 Server SQL Reference.

ORA-01498: block Check Failure - see trace file

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 them 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.

---