Oracle8 Error Messages
Release 8.0.4

A58312-01

Library

Product

Contents

Index

Prev Prev Next

14400-14499: Partitioned Objects - Execution Messages

ORA-14400: inserted partition key is beyond highest legal partition key

Cause: The concatenated partition key of an inserted record was found to be beyond the concatenated partition bound list of the last partition.

Action: Either do not insert the key or add a partition capable of accepting the key.

ORA-14401: inserted partition key is outside specified partition

Cause: The concatenated partition key of an inserted record was found to be outside the ranges of the two concatenated partition bound lists that delimit the partition named in the INSERT statement.

Action: Either do not insert the key or else insert it in another partition.

ORA-14402: attempt to change the value of a partition key column

Cause: An UPDATE statement attempted to change the value of a partition key column.

Action: Either do not attempt to update a partition key column or else make sure that the new column value is equal to the old column value.

ORA-14403: cursor invalidation detected after getting DML partition lock

Cause: Cursor invalidation was detected after acquiring a partition lock during an INSERT, UPDATE, DELETE statement. This error is never returned to user, because is caught in opiexe() and the DML statement is retried.

Action: Nothing need be done, error should never be returned to user.

ORA-14404: partitioned table contains partitions in a different tablespace

Cause: An attempt was made to drop a tablespace which contains tables whose partitions are not completely contained in this tablespace.

Action: Find tables with partitions which span the tablespace being dropped and some other tablespace(s). Drop these tables or move partitions to a different tablespace.

ORA-14405: partitioned index contains partitions in a different tablespace

Cause: An attempt was made to drop a tablespace which contains indexes whose partitions are not completely contained in this tablespace, and which are defined on the tables which are completely contained in this tablespace.

Action: Find indexes with partitions which span the tablespace being dropped and some other tablespace(s). Drop these indexes, or move the index partitions to a different tablespace, or find the tables on which the indexes are defined, and drop (or move) them.




Prev

Top

Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index