Category: Oracle

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-15200 to ORA-15300 ORA-15200: initialization parameter string (string) is not a power of two Cause: The value specified for this initialization parameter was not a power of two. Action: Correct the initialization parameter value and restart the instance. ORA-15201: disk string contains a valid RDBMS file or foreign volume Cause: A disk specified…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14800 to ORA-15000 ORA-14801: Hash composite partitioning is not supported Cause: An attempt was made to partition a table using a Hash composite method. Action: Do not partition the table by a Hash composite method. ORA-14802: Specified operation is not permitted on Hash composite partitioned objects Cause: An unsupported…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14600 to ORA-14800 ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template Cause: Cannot specify these clauses while specifying a template Action: Correct the subpartition template clause. ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table Cause: SUBPARTITION TEMPLATE can be specified only for…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14500 to ORA-14600 ORA-14500: LOCAL option not valid without partition name Cause: Incorrect syntax specified Action: Retry the command ORA-14501: object is not partitioned Cause: Table or index is not partitioned. Invalid syntax. Action: Retry the command with correct syntax. ORA-14503: only one partition name can be specified Cause: More than…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14300 to ORA-14324 ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions Cause: The row inserted had a partitioning key that maps to a partition number greater than 1048575 Action: Ensure that the partitioning key falls within 1048575 partitions or subpartitions. ORA-14301: table-level attributes…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14070 to ORA-14300 ORA-14170: cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX Cause: A request was made to generate default partition description(s) (possibly via PARTITIONS number-of-partitions) while at the same time specified <(sub)partition-description> clause which is illegal. Action: Remove one of offending clauses. ORA-14171: cannot specify subpartition-description clause in…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-14000 to ORA-14100 ORA-14000: only one LOCAL clause may be specified Cause: CREATE INDEX statement contained more than one LOCAL clause Action: Specify LOCAL option at most once ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause Cause: CREATE INDEX statement contained a GLOBAL clause and a LOCAL clause Action: Specify…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13700 to ORA-13900 ORA-13900: missing or invalid parameter string Cause: A call to SET_THRESHOLD procedure was either missing a parameter, or the parameter was invalid. Action: Specify a valid value for this parameter. ORA-13901: Object string was not found. Cause: An object name was passed to SET_THRESHOLD procedure that did not map…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13700 to ORA-13900 ORA-13700: Reserved for ADDM tracing. ORA-13701: Snapshot pair [string, string] seems to be specified in reverse order. Cause: The start snapshot id was greater than the end snapshot id. Action: Swap the start and end snapshot ids. ORA-13702: Snapshot IDs specified by the range [string, string] are…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-13500 to ORA-13700 ORA-13500: SYSAUX DATAFILE clause specified more than once Cause: The CREATE DATABASE command contains more than one SYSAUX DATAFILE clause. Action: Specify at most one SYSAUX DATAFILE clause. ORA-13501: Cannot drop SYSAUX tablespace Cause: Tried to drop SYSAUX tablespace Action: None ORA-13502: Cannot rename SYSAUX tablespace Cause: An…