Category: Databases

Oracle 11g Error Codes and Solution Suggestions from ORA-14500 to ORA-14700 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 one…

Oracle 11g Error Codes and Solution Suggestions from ORA-14300 to ORA-14500 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 must…

Oracle 11g Error Codes and Solution Suggestions from ORA-14200 to ORA-14300 ORA-14201: specified subpartition bound is too long Cause: Length of a linear key representation of a high bound of a table subpartition being added or along which an existing table or index subpartition is being split exceeded the legal limit (4K). Action: Change the representation of…

Oracle 11g Error Codes and Solution Suggestions from ORA-14000 to ORA-14080 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 LOCAL…

Oracle 11g Error Codes and Solution Suggestions from ORA-13900 to ORA-14000 RA-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 to…

Oracle 11g Error Codes and Solution Suggestions from ORA-13700 to ORA-13900 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 equal. Cause: The start snapshot id and…

Oracle 11g 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 attempt…

Oracle 11g Error Codes and Solution Suggestions from ORA-13400 to ORA-13500 ORA-13400: duplicate entry for string in USER_SDO_GEOR_SYSDATA view Cause: The current operation caused a duplicate RASTER_DATA_TABLE and RASTER_ID combination to be inserted into the USER_SDO_GEOR_SYSDATA view. Action: Ensure that the RASTER_DATA_TABLE and RASTER_ID combination to be inserted into the USER_SDO_GEOR_SYSDATA view is unique. ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA…