Sunday 4 March 2012

ORA-13027: unable to read dimension definition from string

ORA-13027: unable to read dimension definition from string

Cause: There was a problem reading the dimension definition from the lamp;lt;lamp;nbsp;layerlamp;gt;_ SDODIM table.

Action: Verify that the lamp;lt;lamp;nbsp;layerlamp;gt;_SDODIM table exists and that the appropriate privileges exist on the table. Address any other errors that might appear with the message.

ORA-13026: unknown element type for element string.string.string

ORA-13026: unknown element type for element string.string.string

Cause: The SDO_ETYPE column in the lamp;lt;lamp;nbsp;layerlamp;gt;_SDOGEOM table contains an invalid geometric element type value.

Action: Redefine the geometric element type in the lamp;lt;lamp;nbsp;layerlamp;gt;_SDOGEOM table for the specified geometric element using one of the supported SDO_ETYPE values. See the Oracle Spatial documentation for an explanation of SDO_ETYPE and its possible values.

ORA-13025: polygon does not close

ORA-13025: polygon does not close

Cause: The coordinates defining a polygonal geometric element represent an open polygon.

Action: Redefine the coordinates of the polygon.

ORA-13024: polygon has less than three segments

ORA-13024: polygon has less than three segments

Cause: The coordinates defining a polygonal geometric element represent less than three segments.

Action: Redefine the coordinates for the polygon.

ORA-13023: interior element interacts with exterior element

ORA-13023: interior element interacts with exterior element

Cause: An interior element of a geometric object interacts with the exterior element of that object.

Action: Redefine coordinates for the geometric elements.

ORA-13022: polygon crosses itself

ORA-13022: polygon crosses itself

Cause: The coordinates defining a polygonal geometric element represent crossing segments.

Action: Redefine coordinates for the polygon.

ORA-13021: element not continuous

ORA-13021: element not continuous

Cause: The coordinates defining a geometric element are not connected.

Action: Redefine coordinates for the geometric element.

ORA-13020: coordinate is NULL

ORA-13020: coordinate is NULL

Cause: A vertex coordinate has a NULL value.

Action: Redefine vertex coordinate to have non-NULL value.

ORA-13019: coordinates out of bounds

ORA-13019: coordinates out of bounds

Cause: Vertex coordinates lie outside the valid range for specified dimension.

Action: Redefine vertex coordinates within specified boundaries.

ORA-13018: bad distance type

ORA-13018: bad distance type

Cause: The specified distance type is invalid.

Action: The only supported distance functions are EUCLID and MANHATTAN.

ORA-13017: unrecognized line partition shape

ORA-13017: unrecognized line partition shape

Cause: The shape of a 2-D line partition could not be determined.

Action: This is an internal error. Contact Oracle Support Services.

ORA-13016: specified topology (string( is invalid

ORA-13016: specified topology (string( is invalid

Cause: The specified topology did not exist in the database, or some components of the topology were missing from the database.

Action: Check the specified topology by executing the SDO_TOPO.validate_ topology function.

ORA-13015: the window definition is not valid

ORA-13015: the window definition is not valid

Cause: The number of values used to define the window does not correspond to the window type.

Action: Verify that the number of values used to defined the window is correct for the window type and number of dimensions.

ORA-13014: a topology identifier outside the range of 1 to 8 was specified

ORA-13014: a topology identifier outside the range of 1 to 8 was specified

Cause: A topology identifier outside the range of 1 to 8 was specified.

Action: Specify a topology in the range of 1 to 8.

ORA-13013: the specified topology was not INTERIOR or BOUNDARY

ORA-13013: the specified topology was not INTERIOR or BOUNDARY

Cause: A topology was specified that was not INTERIOR or BOUNDARY.

Action: Make sure that INTERIOR or BOUNDARY is used to describe an HHCODE s topology.

ORA-13012: an invalid window type was specified

ORA-13012: an invalid window type was specified

Cause: An invalid window type was specified.

Action: Valid window types are RANGE, PROXIMITY, POLYGON.

ORA-13011: value is out of range

ORA-13011: value is out of range

Cause: A specified dimension value is outside the range defined for that dimension.

Action: Make sure that all values to be encoded are within the defined dimension range.

ORA-13010: an invalid number of arguments has been specified

ORA-13010: an invalid number of arguments has been specified

Cause: An invalid number of arguments was specified for an SDO function.

Action: Verify the syntax of the function call.

ORA-13009: the specified date string is invalid

ORA-13009: the specified date string is invalid

Cause: The specified date string has a bad component or does not match the specified format string.

Action: Make sure that the components of the date string are valid and that the date and format strings match.

ORA-13008: the specified date format has an invalid component

ORA-13008: the specified date format has an invalid component

Cause: Part of specified date format is invalid.

Action: Verify that the date format is valid.

ORA-13007: an invalid HEX character was detected

ORA-13007: an invalid HEX character was detected

Cause: A character that is not in the range (0-9( or (A-F a-f( was detected.

Action: Verify that all characters in a string are in (0-9( or (A-F a-f(.

ORA-13006: the specified cell number is invalid

ORA-13006: the specified cell number is invalid

Cause: The cell identifier is either less than 0 or greater than (2^ndim - 1).

Action: Make sure that the cell identifier is between 0 and (2^ndim - 1).

ORA-13005: recursive HHCODE function error

ORA-13005: recursive HHCODE function error

Cause: An error occurred in a recursively called HHCODE function.

Action: This is an internal error. Contact Oracle Support Services.

ORA-13004: the specified buffer size is invalid

ORA-13004: the specified buffer size is invalid

Cause: The buffer size for a function is not valid.

Action: This is an internal error. Contact Oracle Support Services.

ORA-13003: the specified range for a dimension is invalid

ORA-13003: the specified range for a dimension is invalid

Cause: The specified range for a dimension is invalid.

Action: Make sure that the lower bound (lb) is less than the upper bound (ub).

ORA-13002: specified level is out of range

ORA-13002: specified level is out of range

Cause: The specified level is either smaller than 1 or greater than the maximum level encoded in an HHCODE.

Action: Verify that all levels are between 1 and the maximum number of levels encoded in the HHCODE.

ORA-13001: dimensions mismatch error

ORA-13001: dimensions mismatch error

Cause: The number of dimensions in two HHCODEs involved in a binary HHCODE operation do not match.

Action: Make sure that the number of dimensions in the HHCODEs match.

ORA-13000: dimension number is out of range

ORA-13000: dimension number is out of range

Cause: The specified dimension is either smaller than 1 or greater than the number of dimensions encoded in the HHCODE.

Action: Make sure that the dimension number is between 1 and the maximum number of dimensions encoded in the HHCODE.

ORA-12997: cannot drop primary key column from an index-organized table

ORA-12997: cannot drop primary key column from an index-organized table

Cause: An attempt was made to drop a primary key column from an index- organized table.

Action: This action is not allowed.

ORA-12996: cannot drop system-generated virtual column

ORA-12996: cannot drop system-generated virtual column

Cause: An attempt was made to drop a virtual column generated by the system.

Action: none

ORA-12995: no columns in partially dropped state

ORA-12995: no columns in partially dropped state

Cause: An attempt was made to submit DROP COLUMNS CONTINUE statement while there are no partially dropped columns.

Action: Cannot submit this statement.

ORA-12994: drop column option only allowed once in statement

ORA-12994: drop column option only allowed once in statement

Cause: An attempt was made to repeat the drop column option in a single statement.

Action: Separate drop column options into different statements and resubmit statements.

ORA-12993: tablespace string is offline, cannot drop column

ORA-12993: tablespace string is offline, cannot drop column

Cause: An attempt was made to drop a column from a partition or subpartition on an offline tablespace.

Action: Bring the tablespace online and resubmit statement.

ORA-12992: cannot drop parent key column

ORA-12992: cannot drop parent key column

Cause: An attempt was made to drop a parent key column.

Action: Drop all constraints referencing the parent key column, or specify CASCADE CONSTRAINTS in statement.

ORA-12991: column is referenced in a multi-column constraint

ORA-12991: column is referenced in a multi-column constraint

Cause: An attempt was made to drop a column referenced by some constraints.

Action: Drop all constraints referencing the dropped column or specify CASCADE CONSTRAINTS in statement.

ORA-12990: duplicate option specified

ORA-12990: duplicate option specified

Cause: Duplicate option specified in statement.

Action: Remove the duplicate option and resubmit statement.

ORA-12989: invalid value for checkpoint interval

ORA-12989: invalid value for checkpoint interval

Cause: An invalid checkpoint interval specified in statement. Checkpoint interval must be between 0 and (2^31-1).

Action: Correct checkpoint interval and resubmit statement

ORA-12988: cannot drop column from table owned by SYS

ORA-12988: cannot drop column from table owned by SYS

Cause: An attempt was made to drop a column from a system table.

Action: This action is not allowed

ORA-12987: cannot combine drop column with other operations

ORA-12987: cannot combine drop column with other operations

Cause: An attempt was made to combine drop column with other ALTER TABLE operations.

Action: Ensure that drop column is the sole operation specified in ALTER TABLE.

ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

Cause: An attempt was made to access a table with columns in partially dropped state (i.e., drop column operation was interrupted).

Action: Submit ALTER TABLE DROP COLUMNS CONTINUE to complete the drop column operation before accessing the table.

ORA-12985: tablespace string is read only, cannot drop column

ORA-12985: tablespace string is read only, cannot drop column

Cause: An attempt was made to drop column from a partition or subpartition on a read only tablespace.

Action: Set the tablespace to read write and resubmit statement.

ORA-12984: cannot drop partitioning column

ORA-12984: cannot drop partitioning column

Cause: An attempt was made to drop a column used as the partitioning key.

Action: This action is not allowed.

ORA-12983: cannot drop all columns in a table

ORA-12983: cannot drop all columns in a table

Cause: An attempt was made to drop all columns in a table.

Action: Make sure at least one column remains in the table after the drop column operation.

ORA-12982: cannot drop column from a nested table

ORA-12982: cannot drop column from a nested table

Cause: An attempt was made to drop a column from a nested table.

Action: This action is not allowed.

ORA-12981: cannot drop column from an object type table

ORA-12981: cannot drop column from an object type table

Cause: An attempt was made to drop a column from an object type table.

Action: This action is not allowed.

ORA-12980: checkpoint option not allowed with SET UNUSED

ORA-12980: checkpoint option not allowed with SET UNUSED

Cause: An attempt was made to specify checkpoint option with SET UNUSED.

Action: Remove checkpoint option.

ORA-12951: Attempt to change default permanent tablespace to temporary

ORA-12951: Attempt to change default permanent tablespace to temporary

Cause: It is incorrect to alter the default permanent tablespace of a database to temporary type

Action: none

ORA-12950: SYSTEM tablespace specified as default permanent tablespace

ORA-12950: SYSTEM tablespace specified as default permanent tablespace

Cause: SYSTEM tablespace was specified as the default permanent during database creation.

Action: If default permanent tablespace is not specified,then SYSTEM will implicitly become the default permanent tablespace. Specify an alternate tablespace or omit the default tablespace clause and reissue the CREATE DATABASE statement

ORA-12927: RETENTION option already specified

ORA-12927: RETENTION option already specified

Cause: In CREATE TABLESPACE, the RETENTION option was specified more than once.

Action: Remove all but one of the RETENTION options.

ORA-12926: FORCE LOGGING option already specified

ORA-12926: FORCE LOGGING option already specified

Cause: In CREATE TABLESPACE, the FORCE LOGGING option was specified more than once.

Action: Remove all but one of the FORCE LOGGING options.

ORA-12925: tablespace string is not in force logging mode

ORA-12925: tablespace string is not in force logging mode

Cause: An attempt to alter the specified tablespace out of force logging mode failed because it is not in force logging mode.

Action: none

ORA-12924: tablespace string is already in force logging mode

ORA-12924: tablespace string is already in force logging mode

Cause: An attempt to alter the specified tablespace into force logging mode failed because it is already in force logging mode.

Action: none

ORA-12923: tablespace string is in force logging mode

ORA-12923: tablespace string is in force logging mode

Cause: An attempt to alter the specified tablespace temporary failed because the tablespace is in force logging mode.

Action: Put the tablespace out of force logging mode by ALTER TABLESPACE NO FORCE LOGGING command.

ORA-12922: concurrent ALTER DATABASE (NO( FORCE LOGGING command is running

ORA-12922: concurrent ALTER DATABASE (NO( FORCE LOGGING command is running

Cause: There is a concurrent ALTER DATABASE FORCE LOGGING or ALTER DATABASE NO FORCE LOGGING command running in the system.

Action: Contact the database administrator who is responsible for the concurrent command.

ORA-12921: database is not in force logging mode

ORA-12921: database is not in force logging mode

Cause: ALTER DATABASE NO FORCE LOGGING command failed because the database is not in force logging mode.

Action: none

ORA-12920: database is already in force logging mode

ORA-12920: database is already in force logging mode

Cause: ALTER DATABASE FORCE LOGGING command failed because the database is already in force logging mode.

Action: none

ORA-12919: Can not drop the default permanent tablespace

ORA-12919: Can not drop the default permanent tablespace

Cause: An attemp was made to drop the default permanent tablespace

Action: Make a different tablespace as the default permanent tablespace and reissue the drop

ORA-12918: Invalid tablespace type for default permanent tablespace

ORA-12918: Invalid tablespace type for default permanent tablespace

Cause: The tablespace is either dropped, temporary or undo

Action: Check the tablespace type and reissue the statement

ORA-12916: Cannot use default permanent tablespace with this release

ORA-12916: Cannot use default permanent tablespace with this release

Cause: To use default permanent tablespace the release should be 10.0 or higher

Action: Check the compatibility setting and reissue the statement

ORA-12915: Cannot alter dictionary managed tablespace to read write

ORA-12915: Cannot alter dictionary managed tablespace to read write

Cause: Attemp to alter dictionary managed tablespace to read write in database which has system tablespace as locally managed. This tablespace can only be dropped.

Action: Command cannot be issued.