Oracle8 Error Messages
Release 8.0
A54625_01

Library

Product

Contents


Prev Next

25200-25699: Advanced Query Messages

For more messages on advanced query, see "24000-24099: Administrative Interface for Advanced Query Messages" on page 2¬608.

ORA-25200: invalid value name.name QUEUE_NAME should be [SCHEMA.]NAME

Cause: A NULL parameter was specified for the queue name.

Action: Specify a NON-NULL queue name.

ORA-25201: invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE

Cause: An invalid value specified for parameter VISIBILITY.

Action: Specify either ON_COMMIT or IMMEDIATE.

ORA-25202: invalid value NULL, name should be non-NULL

Cause: A NULL value was specified for the parameter.

Action: Specify a non-NULL value.

ORA-25203: invalid value num, DELAY should be non-negative

Cause: A negative value or NULL was specified for DELAY.

Action: Specify a non negative integer for DELAY.

ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP

Cause: An invalid SEQUENCE_DEVIATION was specified.

Action: Specify either the option BEFORE or TOP.

ORA-25205: the QUEUE name.name does not exist

Cause: The specified queue does not exist.

Action: Create the queue first before specifying it for enqueue or dequeue.

ORA-25206: enqueue failed, enqueue to exception queue name.name not permitted

Cause: An attempt was made to enqueue to an exception queue.

Action: Try enqueueing to another queue.

ORA-25207: enqueue failed, queue name.name is disabled from enqueueing

Cause: The queue has been stopped to prevent any further enqueueing.

Action: Enable the queue first by using an administrative operation.

ORA-25208: RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE

Cause: A relative message identifier should be specified if sequence deviation is specified as BEFORE.

Action: Specify a non-null parameter for sequence deviation. valid values are either A, B, or T.

ORA-25209: invalid value num, EXPIRATION should non-negative or NEVER

Cause: The expiration is less than zero or NULL.

Action: Specify a valid value for expire_after which should be greater than or equal to zero or NEVER.

ORA-25210: invalid value for RELATIVE_MSGID, no message in queue with that msgid

Cause: No message inm the queue with the msgid equal to the specified RELATIVE_MSGID.

Action: Try again with a valid RELATIVE_MSGID.

ORA-25211: invalid DELAY specified when using sequence deviation

Cause: The DELAY specified in the enqueue is greater than the delay of the message with the given relative message id.

Action: Set the DELAY to be less than or equal to the delay of the message with the given relative message id. If the TOP option is used the delay must be less than or equal to the delay of all the messages in the queue.

ORA-25212: invalid PRIORITY specified when using sequence deviation

Cause: The PRIORITY specified in the enqueue is less than the priority of the message with the given relative message id.

Action: Set the PRIORITY to be less than the delay of the message with the given relative message id. If the TOP option is used the prioirty must be greater than or equal to the priority of all the messages in the queue.

ORA-25213: message with specified RELATIVE_MSGID has been dequeued

Cause: The message specified by the RELATIVE_MSGID field in the sequence deviation BEFORE option has been dequeued.

Action: No action required. This is an informational message only.

ORA-25215: user_data type and queue type do not match

Cause: An attempt was made to enqueue an object to a queue that was created for objects of different type.

Action: Try enqueue again with an object of the right type.

ORA-25225: invalid value name, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED

Cause: An invalid parameter has been specified for DEQUEUE_MODE.

Action: Specify either REMOVE, BROWSE or LOCKED.

ORA-25226: dequeue failed, queue name.name is not enabled for dequeue

Cause: The queue has not been enabled for dequeue.

Action: Enable the queue using START_QUEUE.

ORA-25228: timeout in dequeue from name.name while waiting for a message

Cause: User-specified dequeue wait time has passed but no message has been retrieved.

Action: Try dequeue again with the appropriate WAIT_TIME.

ORA-25230: invalid value name, WAIT should be non-negative

Cause: A negative value was specified for WAIT.

Action: Specify a non negative value or FOREVER.

ORA-25231: SUBSCRIBER not specified

Cause: An attempt was made to dequeue from a queue that has been created for subscription but a subsciber has not been specified.

Action: Try dequeue again after specifying the name of the subscriber.

ORA-25232: duplicate recipients specified for message

Cause: An enqueue was performed with duplicate queue agents in the recipient's parameter.

Action: Remove the duplicate queue agent and retry the call.

ORA-25233: invalid parameter specified for NAVIGATION

Cause: An invalid parameter has been specified for NAVIGATION.

Action: Choose one of FIRST_MESSAGE, NEXT_MESSAGE, or NEXT_TRANSACTION. Use FIRST_MESSAGE for dequeuing first message that satisifies the criterion, NEXT_MESSAGE for dequeuing next message that satisifies the criterion and NEXT_TRANSACTION for moving to a set of messages enqueued by another transaction.

ORA-25234: NEXT_TRANSACTION navigation option invalid for queue table basename.extension

Cause: The NEXT_TRANSACTION navigation flag was used in a dequeue from a queue in a queue table that was not created for transactional grouping.

Action: Specify either FIRST_MESSAGE or NEXT_MESSAGE as the navigation option. If you want to dequeue messages using transactional grouping create the queue in a queue table that has transactional grouping enabled.

ORA-25235: fetched all messages in current transaction

Cause: The NEXT_TRANSACTION navigation option was used in a dequeue where there were no messages that belong to the same transaction.

Action: Use the NEXT_TRANSACTION navigation option to move to the next group of messages that belong to the same transaction. You can also use the FIRST_MESSAGE option to start from the head of the queue again.

ORA-25236: buffer too small for user data

Cause: The variable or buffer used for the out parameter payload is too small for the user data dequeued.

Action: Increased the size of the buffer or the size of the variable. Maximum size allowed is 32K.

ORA-25237: navigation option used out of sequence

Cause: The NEXT_MESSAGE or NEXT_TRANSACTION option was specified after dequeuing all the messages.

Action: Reset the dequeuing position using the FIRST_MESSAGE naviagtion option and then specify the NEXT_MESSAGE or NEXT_TRANSACTION option.

ORA-25238: too many recipients specified for message

Cause: An enqueue was performed with more than 32 recipients.

Action: Redcue the number of recipients to 32 and retry the call.

25350-25375: Transaction OCI Messages

For more OCI messages, see "24800-24999: OCI LOB/FILE-Related Messages" on page 2¬628 and "24300-24999: UPI/OCI Messages" on page 2¬615.

ORA-25350: maximum number of concurrent transaction branches exceeded

Cause: The limit on the number of concurrent transaction branches has been hit.

Action: Shutdown the system, increase the value of the INIT.ORA parameter TRANSACTIONS, and then restart the system.

ORA-25351: transaction attached to some other session

Cause: The user transaction is currently used by others.

Action: Do not switch to a transaction attached to some other session.

ORA-25352: no current transaction

Cause: The user session is not attached to any transaction.

Action: Do not attempt to detach when there is no current transaction.

ORA-25353: branch marked for deletion

Cause: The branch specified cannot be killed immediately because another session is using the branch, but it has been marked for kill. This means it will be killed as soon as possible after the current operation, which cannot be interrupted, is done.

Action: No action is required for the branch to be deleted.

25400-25425: Application Failover Messages

These error messages can be returned by the application failover feature.

ORA-25400: must replay FETCH

Cause: A failure occurred since the last fetch on this cursor. Failover was able to bring the cursor to its original state to allow continued fetches.

Action: This is an internally used error message and should not be seen by the user.

ORA-25401: cannot fetch on cursor

Cause: A failure occurred since the last fetch on this cursor. Failover was unable to bring the cursor to its original state to allow continued fetches.

Action: Re-execute the statement and start fetching from the beginning.

ORA-25402: transaction must roll back

Cause: A failure occurred while a transaction was active on this connection.

Action: The client must roll back.

ORA-25403: could not reconnect

Cause: The connection to the database has been lost, and attempts to reconnect have failed.

Action: Manually reconnect.

ORA-25404: lost instance

Cause: The primary instance has died.

Action: This is an internally used error message and should not be seen by the user.

ORA-25405: transaction status unknown

Cause: A failure occurred while a transaction was attempting to commit. Failover could not automatically determine instance status.

Action: Determine the transaction's status manually.

ORA-25406: could not generate a backup connect string

Cause: Failover was unable to generate a connect string for a backup instance.

Action: Report this error to Oracle support.

ORA-25407: died in fetch

Cause: The connection was lost while doing a fetch.

Action: This is an internally used error message and should not be seen by the user.

ORA-25408: can not safely replay call

Cause: The connection was lost while doing this call. It may not be safe to replay it after failover.

Action: Check to see if the results of the call have taken place, and then replay it if desired.

ORA-25425: connection lost during rollback

Cause: The connection was lost while issuing a rollback.

Action: If the transaction is not externally coordinated, then Oracle implicitly rolled back, so no action is required. Otherwise examine PENDING_TRANS$ to determine if ROLLBACK FORCE is required.

25426-25435: DBLINK Concentration Messages

ORA-25426: remote instance does not support shared dblinks

Cause: A shared DBLINK is being used to connect to a remote instance that does not support this feature because it is an older version.

Action: Use a normal DBLINK if you need to connect to this instance.

26000-26099: Direct Path Load Messages

ORA-26000: partition load specified but table name is not partitioned

Cause: The Loader control file contains a PARTITION clause but the table being loaded is not partitioned.

Action: Remove the partition specification from the SQL*Loader control file and retry the load.

ORA-26001: index name specified in SORTED INDEXES does not exist on table %s

Cause: A nonexistent index was specified in the SORTED INDEXES clause.

Action: Specify an existing index as a SORTED INDEX and retry the operation.

ORA-26002: table name has index defined upon it.

Cause: Parallel load was specified into a table which has an index defined on it.

Action: Do one of the following:

ORA-26003: error fetching results of SELECT statement (rpi): [name]

Cause: See Action statement.

Action: Check the accompanying ORACLE error message for more information.

ORA-26004: tables loaded through the direct path may not be clustered

Cause: An attempt was made to load a clustered table using the direct path.

Action: Retry the operation using the conventional path.

ORA-26005: table name does not exist

Cause: The specified table does not exist.

Action: Make sure the table exists and that you have privileges on it.

ORA-26006: error parsing SQL statement for rpi: [name]

Cause: See Action statement.-

Action: Check the accompanying ORACLE error message for more information.

ORA-26007: for INSERT option, table must be empty. Error on table name

Cause: An attempt was made to use the INSERT option on a non-empty table.

Action: Empty the table from SQL*Plus, or use the REPLACE option.

ORA-26008: NOT NULL column name has a NULLIF clause

Cause: A column which is NOT NULL in the database has a SQL*Loader NULLIF clause on it.

Action: Remove the NULLIF clause in the SQL*Loader control file.

ORA-26009: NOT NULL column name has a DEFAULTIF clause which may evaluate to NULL

Cause: A column which is NOT NULL in the database has a SQL*Loader DEFAULTIF clause which may evaluate to NULL.

Action: Remove the DEFAULTIF clause in the SQL*Loader control file.

ORA-26010: column name in table name is NOT NULL and is not being loaded

Cause: A column which is NOT NULL in the database is not being loaded and will cause every row to be rejected.

Action: Load the column by specifying the NOT NULL column in the INTO TABLE clause in the SQL*Loader control file.

ORA-26011: tables loaded through the direct path may not be object tables

Cause: An attempt was made to load an object table using the direct path.

Action: Retry the operation using the conventional path.

ORA-26012: tables loaded through the direct path may not have object columns

Cause: User attempted to load a table with an object column using the direct path.

Action: Retry the operation using the conventional path.

ORA-26013: tables loaded through the direct path may not be nested

Cause: An attempt was made to load a nested table using the direct path.

Action: Retry the operation using the conventional path.

ORA-26014: tables loaded through the direct path may not have REF columns

Cause: An attempt was made to load a table with a REF column using the direct path.

Action: Retry the operation using the conventional path.

ORA-26015: tables loaded through the direct path may not have array columns

Cause: An attempt was made to load a table with an array column using the direct path.

Action: Retry the operation using the conventional path.

ORA-26016: record name: rejected - error on table name, partition name

Cause: The record indicated caused an ORACLE error on insert.

Action: Determine the ORACLE error and correct the record. The offending column(s) are not known.

ORA-26017: global indexes not allowed on direct path partition load, table name

Cause: Global indexes are defined on a table when direct path loading a single partition of the table.

Action: Remove the global index from the named table and retry the operation.

ORA-26018: column name in table name does not exist

Cause: The column specified in the loader control file does not exist.

Action: Ensure that the column exists and that you have privileges on it. Correct the loader control file if it is incorrect.

ORA-26019: column name in table name of type name not supported by direct path

Cause: The specified column of SQL column type name is not supported by the direct path loader.

Action: If the column is NULLable, remove it from the control file description. Then it will be loaded as a NULL.

ORA-26020: index name.name loaded successfully with name keys

Cause: Non-partitioned index information was successfully added to the log file.

Action: No action required. This is an informational message only.

ORA-26021: index name.name partition name loaded successfully with name keys

Cause: Partitioned index information was successfully added to the loader log file.

Action: No action required. This is an informational message only.

ORA-26022: index name.name was made unusable due to:

Cause: A non-partitioned index was made index unusable due to the error displayed in the accompanying error message.

Action: Depending on the error, either rebuild the index, or drop and re-create it.

ORA-26023: index name.name partition name was made unusable due to:

Cause: A partition of a partitioned index was made index unusable due to error displayed in the accompanying error message.

Action: Depending on the error, either rebuild the index partition, or drop and re-create the entire index.

ORA-26024: SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable

Cause: The SKIP_UNUSABLE_INDEXES option was specified and the index segment was in an unusable state prior to the beginning of the load.

Action: This is an informational message only. You will need to do one of the following: rebuild the index or index partition re-create the index

ORA-26025: SKIP_INDEX_MAINTENANCE option requested

Cause: A request was made that index maintenance be skipped on a direct path load.

Action: The listed index was put into Index Unusable state due to a request that index maintenance be skipped. You will need to do one of the following:

ORA-26026: unique index name.name initially in unusable state

Cause: A unique index is in IU state (a unique index cannot have index maintenance skipped by using the SKIP_UNUSABLE_INDEXES option).

Action: Either rebuild the index or index partition, or use SKIP_INDEX_MAINTENANCE if the client is SQL*Loader.

ORA-26027: unique index name.name partition name initially in unusable state

Cause: A partition of a unique index is in IU state (a unique index cannot have index maintenance skipped by using the SKIP_UNUSABLE_INDEXES option).

Action: Either rebuild the index or index partition, or use SKIP_INDEX_MAINTENANCE if the client is SQL*Loader.

ORA-26028: index name.name initially in unusable state

Cause: An index is in IU state prior to the beginning of a direct path load, it cannot be maintained by the loader.

Action: Either rebuild the index, re-create the index, or use either SKIP_UNUSABLE_INDEXES or SKIP_INDEX_MAINTENANCE (Sql*Loader only).

ORA-26029: index .name partition name initially in unusable state

Cause: A partition of an index is in IU state prior to the beginning of a direct path load; it cannot be maintained by the loader.

Action: Either rebuild the index partition, re-create the index, or use either SKIP_UNUSABLE_INDEXES or SKIP_INDEX_MAINTENANCE (Sql*Loader only).

ORA-26030: index name.name had name partitions made unusable due to:

Cause: A logical index error occurred on a partitioned index which affected one or more index partitions, which are listed in an accompanying error message.

Action: The affected index partitions will have to be re-built, or, the entire index dropped and re-created.

ORA-26031: index maintenance error, the load cannot continue

Cause: A index error occurred during the index maintenance phase of a direct path load. The load cannot continue. See the accompanying error message.

Action: See the accompanying error message for more information.

ORA-26032: index name.name loading aborted after name keys

Cause: An index error occurred during direct-load of an index-organized table. Loading had to be aborted. No rows were loaded.

Action: Check the key just following the number of keys mentioned above. This key caused the index problem mentioned in an earlier message.

26100-26110: Tablespace-relative DBA Errors

ORA-26100: unused error

Cause: This error is not used.

Action: No action required.

ORA-26101: tablespace # in file header is %s rather than %s for file %s

Cause: The tablespace number in the file header is inconsistent with the tablespace number in the control file.

Action: Check if the control file has been migrated correctly. Retry with the correct control file and data file.

ORA-26102: relative file # in file header is %s rather than %s for file %s

Cause: The relative file number in the file header is inconsistent with the relative file number in the control file.

Action: Check if the control file has been migrated correctly. Retry with the correct control file and data file.

ORA-26103: V6 or V7 data file used to create control file

Cause: The file header of the referenced file is in V6 or V7 format.

Action: Either remove the file from the CREATE CONTROL FILE command, or somehow migrate the file header to V8 format.




Prev

Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library

Product

Contents