Oracle 11g Error Codes and Solution Suggestions from ORA-14700 to ORA-15000 ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user Cause: Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges Action: Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on…
Tag: Oracle Administration
Oracle 11g Error Codes and Solution Suggestions from ORA-14500 to ORA-14700
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
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
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
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
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
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
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
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…
Oracle 11g Error Codes and Solution Suggestions from ORA-13200 to ORA-13400
Oracle 11g Error Codes and Solution Suggestions from ORA-13200 to ORA-13400 ORA-13200: internal error [string] in spatial indexing. Cause: This is an internal error. Action: Contact Oracle Support Services with the exact error text. ORA-13201: invalid parameters supplied in CREATE INDEX statement Cause: An error was encountered while trying to parse the parameters clause for the spatial CREATE…