14500-14999: Partitioned Objects - ANALYZE Messages

ORA-14500: LOCAL option not valid without partition name

Cause: Incorrect syntax was specified for the LOCAL option.

Action: Enter a partition name for the LOCAL option and retry the command.

ORA-14501: object is not partitioned

Cause: The table or index was not partitioned. Invalid syntax.

Action: Retry the command with correct syntax.

ORA-14502: partition does not exist

Cause: An attempt was made to specify a partition which does not exist for the object.

Action: Specify a valid partition name and retry the operation.

ORA-14503: only one partition name can be specified

Cause: More than one partition name has been specified for the ANALYZE option.

Action: Specify one partition name and retry the operation.

ORA-14504: syntax not supported for ANALYZE

Cause: A partition number or bind variable has been used for the ANALYZE option.

Action: Specify a valid partition name.

ORA-14505: LOCAL option valid only for partitioned indexes

Cause: Incorrect syntax was specified for the LOCAL option.

Action: Correct the syntax by specifying a partitioned index and retry the command.

ORA-14506: LOCAL option required for partitioned indexes

Cause: Incorrect syntax was specified for the partitioned index.

Action: Correct the syntax by specifying the LOCAL option and retry the command.

ORA-14507: partition corrupt. all rows do not fall within partition bounds

Cause: The partition contained rows which should be in some other partition. This was possibly due to an exchange partition without validation.

Action: Delete rows in partition which fall outside the partition bounds.

ORA-14508: specified VALIDATE INTO table not found

Cause: The specified table either does not exist or the user does not have the proper privileges.

Action: Specify the correct table to use or obtain the proper privileges.

ORA-14509: specified VALIDATE INTO table form incorrect

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

Action: Specify the correct table to use and retry the operation.

ORA-14510: can specify VALIDATE INTO clause only for partitioned tables

Cause: The VALIDATE INTO has been specified for a non-partitioned table, cluster or index.

Action: Use the VALIDATE INTO clause only for a partitioned table and retry the operation.

---