Category: Errors and Solutions

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-15600 to ORA-16000 ORA-15601: Invalid value specified for parameter “string” Cause: An invalid value was specified for the given parameter. Action: Correct the value being specified for the parameter. ORA-15602: Parameter “string” cannot be NULL. Cause: An attempt was made to call a procedure without a required parameter. Action: Specify…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-15400 to ORA-15600 ORA-15400: not running on supported ASM appliance Cause: An attempt was made to initialize the server code as an appliance when it was not running a supported appliance configuration. Action: Check the appliance configuration and retry the operation. ORA-15401: command not supported on ASM appliance…

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-15300 to ORA-15400 ORA-15300: File string is incompatible with this operation Cause: The file type was incompatible with the operation. Action: Use another file of the correct type. ORA-15301: cannot change string of the open file ‘string‘ Cause: A SET OWNERSHIP or SET PERMISSION command was attempted on an open file. Action: Close the…

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…