Skip Headers
Oracle® Database Error Messages
11g Release 1 (11.1)

B28278-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

23 ORA-41001 to ORA-42399

ORA-41001: session id list not specified
Cause: An attempt to migrate was made, which failed because the session id list specified was null.
Action: Check the session id list, and try again with a valid value.
ORA-41002: destination instance not specified
Cause: An attempt to migrate was made, which failed because the destination instance specified was null.
Action: Check the destination instance , and try again with a valid value.
ORA-41003: client id not specified
Cause: An attempt to migrate was made, which failed because the client id specified was null.
Action: Check the client id, and try again with a valid value.
ORA-41004: percentage not specified
Cause: An attempt to migrate was made, which failed because the percentage specified was null.
Action: Check the percentage, and try again with a valid value.
ORA-41005: session id list not specified
Cause: An attempt to cancel migration was made, which failed because the session id list specified was null.
Action: Check the session id list, and try again with a valid value.
ORA-41006: session id not specified
Cause: An attempt to get migration status was made, which failed because the session id specified was null.
Action: Check the session id, and try again with a valid value.
ORA-41007: sid field is null
Cause: A session id instance passed into a dbms_tsm procedure or function had a null sid field.
Action: Check the session id, and try again with a valid value.
ORA-41008: serial# field is null
Cause: A session id instance passed into a dbms_tsm procedure or function had a null serial# field.
Action: Check the session id, and try again with a valid value.
ORA-41009: Session with session number string, serial number string does not exist
Cause: An attempt to migrate was made, which failed because of invalid session number and/or serial number.
Action: Check the session number and serial number and try again.
ORA-41010: No more memory to hold connection state information
Cause: An attempt to reference more connections than configured
Action: Check the connection information and try again.
ORA-41011: Operation failed for session id string, serial number string
Cause: An migration related operation failed because of contention between sessions.
Action: Check the additional error codes for more information, and retry operation later.
ORA-41012: Migration not allowed for session number string, serial number string
Cause: An attempt to migrate was made, which failed because the session specified cannot be migrated.
Action: Check the session number and serial number and try again.
ORA-41013: instance name not specified
Cause: An attempt to migrate was made, which failed because the instance name specified was null.
Action: Check the instance name, and try again with a valid value.
ORA-41014: Session number string, serial number string currently being migrated
Cause: An attempt to migrate was made, which failed because the session specified is currently being migrated.
Action: Check the session number and serial number and try again.
ORA-41015: destination connect string not specified
Cause: A migration attempt was made, which failed because the connect string specified was null.
Action: Check the connect string and try again.
ORA-41016: Session recreation failed
Cause: Session recreation failed at the destination instance.
Action: Check session state and try migration again
ORA-41017: Session prepare failed for session number string, serial number string
Cause: A migration attempt was made, which failed because session prepare failed.
Action: Retry migration again after checking all arguments.
ORA-41019: Session begin at the destination instance failed
Cause: Session begin failed at the destination instance because the shadow connection could not be established.
Action: Check the connect string and try beginning the session again.
ORA-41020: invalid value "string" specified for parameter "string"
Cause: An invalid value was specified for the the given parameter.
Action: Correct the value being specified for the parameter.
ORA-41021: OCI error during transparent session migration
Cause: An OCI operation failed during transparent session migration.
Action: Check the OCI error signalled, and take corrective action.
ORA-41022: instance name not specified
Cause: An attempt to recover after instance death was made, which failed because the instance name specified was null.
Action: Check the instance name, and try again with a valid value.
ORA-41023: death time not specified
Cause: An attempt to recover after instance death was made, which failed because the death time specified was null.
Action: Check the death time, and try again with a valid value.
ORA-41024: Cursor needs to be parsed again
Cause: An SQL operation failed because the cursor state was lost.
Action: Reissue all operations starting from parse.
ORA-41025: sid field string is invalid
Cause: A session id instance passed into a dbms_tsm procedure or function had an invalid sid field.
Action: Check the session id, and try again with a valid value.
ORA-41026: serial# field string is invalid
Cause: A session id instance passed into a dbms_tsm procedure or function had an invalid serial# field.
Action: Check the serial#, and try again with a valid value.
ORA-41027: Error status string during OCI operation at string
Cause: An OCI operation failed during transparent session migration.
Action: Check the OCI error signalled, and take corrective action.
ORA-41028: Session id not specified
Cause: An attempt to migrate was made, which failed during migration because the session id specified by the client was null.
Action: Check the session id, and try again with a valid value.
ORA-41029: Destination session id not specified for sid string serial# string
Cause: An attempt to migrate was made, which failed during migration because the destination session id specified by the client was null.
Action: Check the session id, and try again with a valid value.
ORA-41030: Session id not specified
Cause: An attempt to migrate was made, which failed during migration because the session id specified by the client was null.
Action: Check the session id, and try again with a valid value.
ORA-41031: Destination session key not specified for sid string serial# string
Cause: An attempt to migrate was made, which failed during migration because the destination session key specified by the client was null.
Action: Check the session id, and try again with a valid value.
ORA-41100: Oracle Cluster Registry operation failed with event string.
Cause: The Portable Clusterware/Oracle Cluster Registry stack returned an error.
Action: Check if the Portable Clusterware stack is properly brought up.
ORA-41101: The database: string has already been designated as Cluster Director.
Cause: An attempt was made to designate multiple databases as the Cluster Director.
Action: Undesignate the existing Cluster Director before Designating a new one.
ORA-41102: No database has currently been designated as Cluster Director.
Cause: An attempt was made to query/undesignate a Cluster Director when no database has been designated as Cluster Director.
Action: None
ORA-41103: Only the designated Cluster Director: string can undesignate itself.
Cause: An attempt was made to undesignate the current Cluster Director by a database that is not the Cluster Director.
Action: Login to the currently designated Cluster Director to perform the undesignation.
ORA-41104: The database: string is the Cluster Director.
Cause: An attempt was made to control the Cluster Director on a database that is not the Cluster Director.
Action: Log in to the currently designated Cluster Director to perform the control operation.
ORA-41105: The Cluster Director is not stopped.
Cause: An attempt was made to control the Cluster Director before the Cluster Director was stopped.
Action: Use dbms_cluster_director.stop to stop the Cluster Director and retry the control operation.
ORA-41106: invalid argument string: value is null
Cause: An attempt to read the scan hostname or port failed
Action: Verify pcw is running and scan is configured. Run grdcscan read_config to verify or grdcscan set_config host:port to set scan name and port.
ORA-41107: invalid argument: service string cannot be found
Cause: The program attempted to access a nonexistent or deleted service.
Action: Check to make sure the service has been properly created.
ORA-41108: Posting system alert with reason_id string failed with code [string] [string]
Cause: Internal Error: An attempt to post a system alert failed.
Action: If this condition repeats, please contact Oracle Support.
ORA-41109: Updating system alert with reason_id string failed; previous alert not found
Cause: System Error: An attempt to update a system alert failed. The alert was improperly cleared from WRI$_ALERT_OUTSTANDING.
Action: Do not delete from WRI$_ALERT_OUTSTANDING. If this condition repeats, please contact Oracle Support.
ORA-41110: The Director has blocked this instance. Cannot start [string]
Cause: An attempt to start services on an instance that will be shutdown
Action: Start the services on another available instance
ORA-41201: Session state not capturable due to reason (string, string)
Cause: Session state capture was initiated when session state could not be captured.
Action: Check session state status and make sure session state can be captured.
ORA-41202: Session state capture or restore failed
Cause: Capture or restore operation failed.
Action: Check session state status and failure reason for details.
ORA-41203: Invalid session state operation
Cause: Invalid session state operation was issued.
Action: Check if session status was valid for the current operation.
ORA-41204: Session capture in progress
Cause: Session state capture was initiated and could not perform the requested operation.
Action: Wait for the current capture to complete or abort it.
ORA-41205: Invalid parameter for session state capture or restore
Cause: Invalid parameter was passed to session state capture or restore interface.
Action: Correct the invalid parameter(s).
ORA-41206: Session capture or restore internal error KPCSFR-string
Cause: Internal operation error was encountered.
Action: Turn on related trace for details and report it as a bug.
ORA-41207: Cannot restore session state due to reason (string, string)
Cause: Session state restore was initiated when session was not ready for state restore.
Action: Restore session state immediately after logging into a session or perform necessary operations to make the session ready for restore; for example, commit current transaction, or close BFiles.
ORA-41208: OCI error during session state capture and restore
Cause: An OCI operation failed during an internal operation of session state capture and restore.
Action: Check the OCI error signaled and take corrective action.
ORA-41209: OCI operation failed at string due to ORA-string
Cause: An OCI operation failed during an internal operation of session state capture and restore.
Action: Check the OCI error signaled and take corrective action.
ORA-41210: Failed to resolve session state directory object
Cause: Session state directory object passed to capture or restore was incorrect.
Action: Verify session state directory object and retry.
ORA-41211: Failed to insert capture or restore record
Cause: An error occurred while capture or restore record was being stored into the database.
Action: Check the error signaled and take corrective action.
ORA-41251: Failed to restore session state from a file (error code number)
Cause: Session state file may be corrupted.
Action: Ensure that the file is a session state file.
ORA-41252: Failed to switch to new session in SSCR
Cause: This is the generic internal error number for the SSCR exceptions. This indicates that the SSCR has encountered an exceptional condition.
Action: Report as a bug.
ORA-41253: Failed to access session state file
Cause: An error was encountered while reading from or writing to session state capture file.
Action: Check the error stack for the actual error number and turn on tracing if necessary.
ORA-41254: Invalid session state file: string
Cause: An invalid session state file was used in session state restore operation.
Action: Check if the session state file is a valid file created by session capture.
ORA-41300: File driver is not initialized
Cause: An attempt was made to operate on the uninitialized file driver.
Action: Initialize the file driver using the OCIServerAttach function.
ORA-41301: failed to write data to file
Cause: You may not have sufficient privileges or quotas for this action.
Action: Ensure that you have sufficient privileges and quotas for this action.
ORA-41302: failed to read data from file
Cause: The file may not exist or you do not have privileges for this action.
Action: Ensure that the file exists and that you have sufficient privileges for this action.
ORA-41303: Received partial data from file
Cause: This is the generic internal error number for file driver exceptions. This indicated that file driver encountered an exception condition.
Action: Report as a bug.
ORA-41304: Failed to connect to file driver
Cause: The connect string may be incorrect.
Action: Ensure that the connect string is correct.
ORA-41305: Failed to open file
Cause: You may not have sufficient privileges for this action.
Action: Ensure that the file exists and that you have sufficient privileges for this action.
ORA-41400: Bind character set (string) does not match database character set (string)
Cause: In this recursive OCI call, the bind character set was different from the current database character set. This is usually caused by database character set change.
Action: Be sure to obtain bind data in database character set and do rebind in the current environment.
ORA-41401: Define character set (string) does not match database character set (string)
Cause: In this recursive OCI call, the define character set was different from the current database character set. This is usually caused by database character set change.
Action: Be sure to do redefine in the current environment.
ORA-41601: invalid property for the rule class
Cause: An invalid property was specified for the rule class.
Action: Correct the rule class properties and try again.
ORA-41602: insufficient privileges
Cause: The user does not have required privileges on the object.
Action: Obtain the required privileges and try again.
ORA-41603: invalid privilege type
Cause: An attempt was made to grant an invalid privilege on a rule class.
Action: Correct the privilege name and try again.
ORA-41604: cannot revoke a privilege that was not granted
Cause: An attempt was made to revoke a privilege that was never granted.
Action: None
ORA-41605: schema extended name not allowed: string
Cause: An attempt was made to specify a schema extended name for an event structure, a rule class, or an action call-back procedure.
Action: Specify the object name with out a schema extension.
ORA-41606: rule class name already used by an existing object
Cause: An attempt was made to create a rule class with a name that is already used by an existing object.
Action: Specify a different name for the rule class and try again.
ORA-41607: rule class creation failed with string
Cause: rule class creation failed with a recursive error.
Action: Correct the rule class specification and try again.
ORA-41608: rule class does not exist
Cause: An attempt was made to access a rule class that does not exist or is not accessible.
Action: Correct the rule class name and try again.
ORA-41609: invalid name for the rule class
Cause: An invalid name was specified for the rule class.
Action: Correct the rule class name and try again.
ORA-41610: callback procedure name already used for an existing object
Cause: An attempt was made to create a callback procedure with a name that is already used for an existing object.
Action: Choose another name for the callback procedure.
ORA-41611: rule identifier "string" not unique in the rule class
Cause: An attempt was made to use a duplicate rule identifier.
Action: Choose a unique identifier for the rule and try again.
ORA-41612: scalar values expected for action preferences
Cause: Incorrect values were specified for the action preferences.
Action: Correct the action preferences values and try again.
ORA-41613: invalid action preference for rule class: string
Cause: An attempt was made to use an invalid action preference.
Action: Correct the input and try again.
ORA-41614: missing action preference value
Cause: Values for one or more action preferences were not specified.
Action: Specify values for all relevant action preferences.
ORA-41615: too many values in action preference list
Cause: Too many entries were specified in the action preference values list. The action preference values list should not have more entries than the action preference names list.
Action: Correct the input and try again.
ORA-41616: rule class's action callback procedure may have errors
Cause: The operation failed because the action callback procedure associated with the rule class has compilation errors.
Action: Recompile the action callback procedure and try the operation again.
ORA-41617: action preference name "string" collides with an event attribute name
Cause: An attempt was made to create an action preference with the same name as an attribute in the event structure.
Action: Choose a different name for action preference and try again.
ORA-41618: specified rule does not exist
Cause: Invalid rule identifier was used to operate on a rule definition.
Action: Use a valid rule identifier.
ORA-41619: rule manager feature currently not supported
Cause: An attempt was made to use a rule manager feature that is currently not supported.
Action: No action necessary. This is an informational message only.
ORA-41620: invalid ordering property for the rule class
Cause: An attempt was made to specify an invalid ordering property for the rule class.
Action: Make sure that the attributes listed in the ordering property are all part of the rule class/event structure definition with appropriate extended names.
ORA-41621: error in ordering property :string
Cause: An attempt was made to specify an invalid ordering property for the rule class.
Action: Make sure that the attributes listed in the ordering property are all part of the rule class/event structure definition with appropriate extended names.
ORA-41622: invalid primitive event object in rule class properties : string
Cause: In the rule class properties, the name used for one or the primitive event objects was not found in the corresponding composite event structure.
Action: Correct the name of the primitive event object in the rule class properties and try again.
ORA-41623: conflicting values for autocommit and duration properties
Cause: An attempt was made to create a rule class with autocommit enabled when the duration of events is set to TRANSACTION.
Action: Turn autocommit off or choose a different duration policy.
ORA-41624: invalid duration policy for primitive object in a composite event
Cause: An attempt was made to specify a SESSION or TRANSACTION duration policy for the primitive objects.
Action: Correct the rule class properties and try again.
ORA-41625: event structure string does not exist
Cause: The object type that represents the event structure was not created in the user's schema.
Action: Create the object type with the event structure's name and try again.
ORA-41626: invalid XML element "string" in rule class properties
Cause: An invalid XML element was used in the properties specification for the rule class.
Action: Use the correct (case-sensitive) tags in the properties.
ORA-41627: event structure object type in inconsistent state
Cause: The object type specified for the event structure was in an inconsistent state.
Action: Fix the object type and try again.
ORA-41628: invalid usage of "string" attribute in "string" element
Cause: An invalid or unsupported XML attribute was used in the rule class properties.
Action: Use the correct (case-sensitive) tags in the properties.
ORA-41629: event structure for simple events cannot be reused for composite events
Cause: An attempt was made to reuse an object type (event structure) for composite events when it is already configured for simple events.
Action: Drop the attribute set associated with the object and try again.
ORA-41630: invalid value for "string" attribute in the rule class properties
Cause: An invalid value was specified for an attribute in the rule class properties.
Action: Correct the value and try again.
ORA-41631: invalid text node or child element for "string" element in properties
Cause: An attempt was made to specify a child element or a text node in invalid position in the rule class properties specification.
Action: Correct the rule class properties and try again.
ORA-41632: invalid value for the "string" attribute
Cause: An attempt was made to assign an invalid value for an attribute in the rule class properties.
Action: See the documentation.
ORA-41633: specified rule class configuration not supported: "string"
Cause: An attempt was made to use an unsupported configuration for the rule class.
Action: Remove the specified tag in the properties and try again.
ORA-41634: invalid duration specification in rule properties: "string"
Cause: Invalid value was specified for the duration attribute in the rule class properties.
Action: Correct the value and try again.
ORA-41635: invalid unit of time used in duration specification
Cause: An attempt was made to use an invalid unit of time for the rule class's duration specification. Valid units are : minutes, hours, and days.
Action: Correct the duration specification and try again.
ORA-41636: invalid duration specification at the primitive event level
Cause: An attempt was made to specify a duration policy for the primitive events when the composite event was configured with TRANSACTION or SESSION duration policy.
Action: Correct the rule class properties and try again.
ORA-41637: missing primitive event name
Cause: The name attribute of the object element in the rule class properties was not specified. This is a required value.
Action: Specify the name of the primitive event and try again.
ORA-41638: invalid attribute for "string" element in rule condition
Cause: An attempt was made to specify an invalid attribute for an XML element in the rule condition.
Action: Correct the rule condition and try again.
ORA-41639: invalid child node in "string" element
Cause: An attempt was made to specify an invalid child element or text node for an XML element in the rule condition.
Action: Correct the rule condition and try again.
ORA-41640: invalid element "string" in the rule condition
Cause: An attempt was made to use an invalid element or a valid element in invalid position in the rule condition.
Action: Correct the rule condition and try again.
ORA-41641: invalid or empty rule condition
Cause: An attempt was made to specify an invalid or empty rule condition.
Action: Correct the input and try again.
ORA-41642: Missing "string" element in the rule condition
Cause: The rule condition was specified without a required element.
Action: Correct the rule condition and try again.
ORA-41643: invalid attribute for the "string" element in the rule condition
Cause: An attempt was made to specify an invalid attribute for an element in the rule condition.
Action: Correct the rule condition and try again.
ORA-41644: invalid use of "string" attribute in rule condition
Cause: An attempt was made to specify an invalid attribute for an element in the rule condition.
Action: Correct the rule condition and try again.
ORA-41645: duplicate tag "string" in rule condition
Cause: An attempt was made to specify the same XML tag in more than one positions within a single rule condition.
Action: Remove the duplicate reference to the tag and try again.
ORA-41646: missing "string" attribute for "string" element in the rule condition
Cause: One of the required attributes was not specified in the rule condition.
Action: Correct the rule condition and try again.
ORA-41647: negation not allowed in rule conditions with "any" semantics
Cause: An attempt was made to specify a "not" element within an "any" element in the rule condition.
Action: Correct the rule condition and try again.
ORA-41648: invalid sequence of child elements in "string" element
Cause: An attempt was made to specify an invalid sequence of elements within a parent element.
Action: Correct the rule condition and try again.
ORA-41649: invalid rule condition for a rule class involving composite events
Cause: An attempt was made to add an invalid rule condition to a rule set defined for composite events.
Action: Correct the input and try again.
ORA-41650: invalid composite event structure
Cause: A composite event structure may only have attributes that are either table aliases or of an object type that is defined in the owner's schema.
Action: Ensure that the event structure has no scalar attributes and all the embedded types in it are defined in the owner's schema.
ORA-41651: Event structure object type has one or more dependent objects
Cause: An attempt was made to configure an object type that has one or more dependents as a event structure. The object type cannot be modified due to the dependent objects.
Action: Create a new object type for the event structure and try again.
ORA-41652: invalid value for the equal attribute in the rule condition
Cause: An invalid value is assigned to the equal attribute in the rule condition.
Action: Correct the input and try again.
ORA-41653: inconsistent value for the "count" attribute of the "any" element
Cause: The value specified for the "count" attribute of the "any" element is greater than or equal to the the number of primitive events appearing in the rule condition.
Action: Specify a smaller value for the "any" element's "count" attribute.
ORA-41654: insufficient number of primitive events for the use of "sequence"
Cause: An attempt was made to use "sequence" attribute when there is an insufficient number of primitive events in the rule conditions.
Action: Remove the sequence specification.
ORA-41655: rule condition construct not supported: string
Cause: An attempt was made to use a rule condition construct that is not supported in the current release.
Action: Modify the rule condition.
ORA-41656: insufficient number of child elements in "string" element.
Cause: An attempt was made to use fewer than two elements within an "and" or "notany" element.
Action: Specify at least two elements within the parent element.
ORA-41657: rule class internal objects cannot be dropped
Cause: An attempt was made to drop an internal object that is required for a rule class.
Action: Drop the rule class associated with this object.
ORA-41658: invalid value for the "count" attribute in the "any" element
Cause: An invalid value is assigned to the count attribute in the rule condition. The values should be a positive integer that is smaller than the number of object elements within the "any" element.
Action: Correct the input and try again.
ORA-41659: invalid primitive event "string" for the rule class
Cause: An attempt was made to use an invalid primitive event in a rule condition.
Action: Correct the input and try again.
ORA-41660: ordering property for the rule class is too long
Cause: An attempt was made to configure the rule class with an ordering property that is longer than 240 characters.
Action: Correct the input and try again.
ORA-41661: the system generated rule class package has errors
Cause: An attempt was made to use a rule class configuration that was not supported.
Action: File a bug.
ORA-41662: number of primitive events in the composite event exceeds maximum limit
Cause: An attempt was made to create a composite event structure with more than 32 primitive events.
Action: Use a composite event that consists of fewer primitive events.
ORA-41663: invalid use of "equal" or "sequence" attribute with a single event
Cause: An attempt was made to use "equal" or "sequence" attribute when the "count". attribute in a rule condition with "any" semantics is set to 1.
Action: Remove the "equal" and "sequence" specifications.
ORA-41664: invalid consumption policy for the primitive event
Cause: An attempt was made to use EXCLUSIVE consumption policy for a primitive event when the composite event is configured for RULE consumption policy.
Action: Correct the rule class properties and try again.
ORA-41665: conflicting values for duration, consumption, and autocommit policies
Cause: An attempt was made to use an EXCLUSIVE consumption policy with no autocommit and a duration other than TRANSACTION or SESSION.
Action: Modify the rule class properties and try again. Autocommit should be set to YES when the consumption policy is EXCLUSIVE.
ORA-41666: XML schema validation failed when validating against string
Cause: The user input has undefined element or attribute according to the provided XML schema definition.
Action: Correct the user inputs and try again.
ORA-41667: rule class results view name already used for an existing object
Cause: An attempt was made to use a duplicate name for the rule class results view.
Action: Use a different name for the rule class results view.
ORA-41668: invalid operation for the rule class
Cause: An attempt was made to use an invalid operation for the rule class.
Action: No action necessary. This is an informational message only.
ORA-41669: invalid list of primitive event identifiers
Cause: An attempt was made to pass an empty list of primitive event identifiers to the CONSUME_PRIM_EVENTS API.
Action: Correct the input and try again.
ORA-41670: duplicate or invalid event name in equal specification
Cause: An attempt was made to specify a duplicate or invalid primitive event for the rule class's equal property.
Action: Correct the input and try again.
ORA-41671: duplicate table names in the event structure with table aliases
Cause: The table used for an event structure has the same name as another table or a primitive event type in the event structure.
Action: Use an event structure with distinct table names for table aliases.
ORA-41672: invalid rowid passed in for "string" table
Cause: An attempt was made to pass a NULL or invalid rowid for a table in the event structure.
Action: Correct the input and try again.
ORA-41673: sequence attribute not allowed in rule conditions using table aliases
Cause: An attempt was made to use sequence attribute in a rule condition that is defined using table aliases. Sequence usage is not permitted for the lack of timestamp attribute.
Action: Correct the input and try again.
ORA-41674: dmlevents policy allowed only for event structures with table aliases
Cause: An attempt was made to use the dmlevents policy for an event structure with no table alias constructs.
Action: Correct the rule class properties and try again.
ORA-41675: schema for data tables does not match that of the rule class
Cause: An attempt was made to use the dmlevents policy for a rule class that refers to table residing in different schema. To use the dmlevents policy, the table associated with table aliases in the event structure and the rule class should exist in the same schema.
Action: Remove dmlevents specification from rule class properties.
ORA-41676: invalid use of dmlevents policy for primitive event
Cause: An attempt was made to use the dmlevents policy for a primitive event defined with more than one table alias attribute.
Action: Remove the dmlevents specification from the rule class properties.
ORA-41677: DML event trigger creation failed with string
Cause: Triggers could not be created on the data table to track DML events.
Action: Remove the dmlevents specification from the rule class properties.
ORA-41678: conflicting values for the autocommit and dmlevents policies
Cause: An attempt was made to use dmlevents policy in combination with autocommit set to YES. This combination is not allowed.
Action: Set autocommit to NO and try again.
ORA-41679: dmlevents specification only allowed with table alias attributes
Cause: An attempt was made to use the dmlevents policy for an event structure not containing any table alias attributes.
Action: Remove the dmlevents specification from the rule class properties.
ORA-41680: Rules Manager background process string does not exist
Cause: An attempt was made to use a Scheduler process that does not exist.
Action: Execute EXFSYS.RLM$CREATE_SCHEDULER_JOBS procedure as a privileged user.
ORA-41681: clean up of expired events failed
Cause: The background process that cleans up the expired events failed for a rule class.
Action: Invoke EXFSYS.DBMS_RLMGR_UTL.CLEANUP_EVENTS API for the exact nature of the problem.
ORA-41682: invalid rule class package
Cause: An attempt was made to use a rule class package with invalid signature or permissions.
Action: Drop the rule class and recreate it.
ORA-41683: unable to lock a rule in the rule class
Cause: A rule matching the current event is locked by another session.
Action: Reissue the command after committing the other sessions.
ORA-41684: invalid value for the RLM$ENABLED column
Cause: An attempt was made to insert or update a value other than 'Y' or 'N' into the RLM$ENABLED column of a rule class table.
Action: Retry the DML statement with a value of 'Y' or 'N' for the RLM$ENABLED column.
ORA-41685: invalid window specification for the collection element
Cause: An invalid attribute value was specified for the "windowlen" or the "windowsize" attribute. The value specified for the "windowlen" attribute should be a number indicating the number of days or a fraction of a day. The value specified for the "windowsize" attribute should be an integer which indicates number of items in the collection. The maximum value allowed for the window specification is 64000.
Action: Correct the input and try again.
ORA-41686: use of "collection" invalid for the primitive event
Cause: An attempt was made to define a rule condition with "collection" element when the corresponding event was not configured for collections of events.
Action: Correct the rule condition and try again.
ORA-41687: attribute "string" not allowed in the "groupby" specification
Cause: The attributes listed in the "groupby" specification in a rule condition were not a subset of the attributes specified in the rule class properties.
Action: Correct the "groupby" specification for the rule condition and try again.
ORA-41688: invalid value for the "groupby" attribute
Cause: An invalid value was specified for the "groupby" attribute.
Action: Correct the input and try again.
ORA-41689: invalid collection specification in the rule condition
Cause: An attempt was made to insert a rule condition with invalid collection element specification.
Action: Correct the input and try again.
ORA-41690: maximum number of grouping expressions for a rule class exceeded
Cause: An attempt was made to specify more than 32 expressions for the "groupby" clause in rule class properties.
Action: Use fewer than 32 expressions for the "groupby" clause.
ORA-41691: invalid aggregate specification: string
Cause: The aggregate operation specified in the rule condition was invalid.
Action: Correct the input and try again.
ORA-41692: unsupported aggregate operator in the having/compute clause: string
Cause: An attempt was made to use an unsupported aggregate operator in the having or the compute clause in the rule condition.
Action: Correct the input and try again.
ORA-41693: invalid attribute or data type for an aggregate operator: string
Cause: An attempt was made to apply an aggregate operator on an invalid attribute or an attribute with invalid or unsupported data type in the aggregate operator. Only NUMBER and DATE attributes are allowed in the aggregate operators.
Action: Correct the input and try again.
ORA-41694: invalid equal specification around: string
Cause: An attempt was made to specify an invalid equal clause for a rule condition or the rule class properties.
Action: Correct the input and try again.
ORA-41695: equal specification should have a minimum of two elements
Cause: An attempt was made to specify fewer than two elements in the equal clause for a rule condition or the rule class properties.
Action: Correct the input and try again.
ORA-41696: invalid operator in the having clause: string
Cause: An attempt was made to use an invalid relational operator in the having clause of the rule condition.
Action: Correct the input and try again.
ORA-41697: attribute prefix missing in aggregate specification: string
Cause: An attempt was made to specify an aggregate predicate across multiple primitive event types with no attribute prefix.
Action: Correct the input and try again.
ORA-41698: invalid use of "string" attribute in aggregate predicate
Cause: An attempt was made to use an attribute where a literal is expected in the aggregate predicate in the rule condition.
Action: Correct the input and try again.
ORA-41699: maximum number of aggregate operations per rule condition exceeded
Cause: An attempt was made to specify more than 5 aggregate operations in a rule condition.
Action: Correct the input an try again.
ORA-41700: a conditions table already exists for the event structure
Cause: A table storing the primitive rule conditions was already assigned to the event structure.
Action: No action necessary. This is an informational message only.
ORA-41701: conditions table with a rule class association cannot be truncated or dropped
Cause: An attempt was made to truncate or drop a conditions table when one or more rule classes are associated to it through the event structure.
Action: Drop the rule class before truncating or dropping the conditions table.
ORA-41702: invalid conditions table
Cause: An attempt was made to use an invalid conditions table.
Action: Correct the input and try again.
ORA-41703: invalid child node in "object" element with "ref" attribute
Cause: An attempt was made to use both a condition and a "ref" attribute in the "object" element.
Action: Remove the "ref" attribute.
ORA-41704: invalid condition reference: "string"
Cause: An attempt was made to use a reference to a nonexistent conditions table or a condition.
Action: Ensure that the conditions table exists for the primitive event and the value specified for the "ref" attribute of the "object" element is valid.
ORA-41705: conditions table cannot be dropped with DROP TABLE command
Cause: An attempt was made to drop a conditions table with a DROP TABLE command.
Action: Use DBMS_RLMGR.DROP_CONDITIONS_TABLE instead.
ORA-41706: a condition referenced in rule conditions may not be deleted
Cause: An attempt was made to delete a condition when one or more rule conditions refer to it.
Action: Delete the rules before deleting the conditions.
ORA-41707: unsupported construct with collection events: "string"
Cause: An attempt was made to define a collection rule condition with unsupported constructs.
Action: Correct the input and try again.
ORA-41708: the identifier for the shared condition may not be modified
Cause: An attempt was made to update the identifier of a row stored in the conditions table.
Action: Insert a row with the new identifier instead.
ORA-41710: invalid use of aggregate operator for a noncollection event
Cause: An attempt was made to specify an aggregate operator on an event that is not identified as collection.
Action: Correct the input and try again.
ORA-41711: invalid attribute in the rule condition's having clause
Cause: An invalid attribute is used in the specification for the having clause of the rule condition.
Action: Correct the input and try again.
ORA-41712: missing groupby specification for the collection "string"
Cause: An attempt was made to use a collection element with no groupby specification in the rule condition.
Action: Correct the input and try again.
ORA-41713: invalid use of "windowlen" and "windowsize" attributes
Cause: An attempt was made to use the windowlen and windowsize attributes within the same collection element.
Action: Correct the input and try again.
ORA-41714: invalid use of window specification with SESSION/TRANSACTION duration
Cause: An attempt was made to use the windowlen or windowsize attributes when the events are configured for SESSION or TRANSACTION duration.
Action: Remove the window specification and try again.
ORA-41721: invalid use of DMLEVENTS and CNFEVENTS in rule class properties
Cause: An attempt was made to specify both the DMLEVENTS and CNFEVENTS for the same rule class.
Action: Remove either the DMLEVENTS or the CNFEVENTS specification.
ORA-41722: insufficient privileges for database change notification
Cause: An attempt was made to use CNFEVENTS property with insufficient privileges.
Action: Grant CHANGE NOTIFICATION privilege and EXECUTE privilege on DBMS_CHANGE_NOTIFICATION to the user and try again.
ORA-42000: invalid online redefinition column mapping for table "string"."string"
Cause: An attempt was made to change the logical structure of a materialized view log, queue table, or a partition by specifying a non-NULL column mapping during online redefinition.
Action: Pass a NULL column mapping parameter.
ORA-42001: online redefinition options require COMPATIBLE parameter to be string or greater
Cause: The following types of redefinition require a 10.2 or higher compatibility setting:

o redefining a materialized view log

o redefining a table with objects

o redefining a clustered table

o redefining an AQ queue table

o redefining a table partition The following types of redefinition require an 11.0 or higher compatibility setting:

o redefining a table with a materialized view log

o redefining a table with dependent materialized views

Action: Shut down and restart with an appropriate compatibility setting.
ORA-42002: partition "string" of table "string"."string" not being redefined
Cause: An attempt was made to redefine a partition which is not involved in this redefinition.
Action: Pass a valid partition name.
ORA-42003: partition must be specified for this redefinition
Cause: A partition was involved in this redefinition but was not specified.
Action: Specify the partition involved in this redefinition.
ORA-42004: redefinition not instantiated
Cause: An attempt was made to complete an instantiation-deferred redefinition without invoking dbms_redefinition.sync_interim_table.
Action: Invoke dbms_redefinition.sync_interm_table to instantiate this redefinition.
ORA-42005: invalid type of redefinition method
Cause: An unknown redefinition method was used.
Action: Use one of the supported redefinition methods: o dbms_redefinition.cons_use_pk o dbms_redefinition.cons_use_rowid
ORA-42006: dependent object registration not supported during a partition redefinition
Cause: An attempt was made to register dependent objects when redefining a partition.
Action: Do not invoke dbms_redefinition.register_dependent_object during a partition redefinition.
ORA-42007: dependent object unregistration not supported during a partition redefinition
Cause: An attempt was made to unregister dependent objects when redefining a partition.
Action: Do not invoke dbms_redefinition.unregister_dependent_object during a partition redefinition.
ORA-42008: error occurred while instantiating the redefinition
Cause: An error occurred while instantiating the online redefinition which requires aborting the redefinition.
Action: Correct the error, abort, and restart the online redefinition.
ORA-42009: error occurred while synchronizing the redefinition
Cause: An error occurred while synchronizing the online redefinition.
Action: Correct the error and continue the online redefinition.
ORA-42010: error occurred while synchronizing the redefinition
Cause: An error occurred while synchronizing the online redefinition which requires aborting the redefinition.
Action: Correct the error, abort, and restart the online redefinition.
ORA-42011: error occurred while completing the redefinition
Cause: An error occurred while completing the online redefinition.
Action: Correct the error and continue the online redefinition.
ORA-42012: error occurred while completing the redefinition
Cause: An error occurred while completing the online redefinition which requires aborting the redefinition.
Action: Correct the error, abort, and restart the online redefinition.
ORA-42013: interim table of an AQ IOT table should be an IOT table
Cause: An attempt was made to create a table that is not an index-organized table (IOT) as the interim table of an AQ IOT table (history, time management, or dequeue).
Action: Ensure that the interim table is created as an IOT table.
ORA-42014: online redefinition unable to lock AQ objects
Cause: An online redefinition of an AQ table was unable to lock all related AQ objects.
Action: Abort and retry the redefinition.
ORA-42015: online redefinition unable to log changes made to AQ tables
Cause: An online redefinition of an AQ table was unable to log changes made to AQ tables during the redefinition.
Action: Abort and retry the redefinition.
ORA-42016: shape of interim table does not match specified column mapping
Cause: The number of columns, or the type or the length semantics of a column, in the interim table did not match the specified column mapping.
Action: Ensure that the interim table matches the column mapping by either modifying the column mapping string or altering the interim table's column definition(s).
ORA-42017: interim table of an AQ table should not be an AQ table
Cause: An attempt was made to create an AQ table as an interim table of an online redefined AQ table.
Action: Ensure that the interim table is not created as an AQ table.
ORA-42018: partition cannot be redefined online because of index organization incompatibility
Cause: interim table is incompatible with partition being redefined because one or more of the following apply:

- one is index-organized and the other is not

- one has IOT overflow segment and the other does not

- one has IOT mapping table and the other does not

Action: Ensure that the interim table is compatible with the partition being redefined.
ORA-42019: partition cannot be redefined online because of incompatible partitioning of interim table
Cause: both original and interim tables are partitioned, or original table is composite-partitioned but interim table is non-partitioned.
Action: Ensure that the interim table has compatible partitioning with the original table. For example, if the original table is partitioned, the interim table should be non-partitioned. If the original table is composite-partitioned, the interim table should be partitioned.
ORA-42020: partition cannot be redefined online because of unsupported type of interim table
Cause: An unsupported type of interim table was provided during the partition redefinition. Currently the following types of interim tables are not supported:

- a nested table or has nested-table columns

- an external table

- part of cluster

- contains LOB shared segments

Action: Do not use unsupported types of interim tables.
ORA-42021: partition cannot be redefined online because of incompatible row dependencies
Cause: original/interim table was created with row dependency and interim/original table was not.
Action: Ensure that both tables are created with same row dependency properties.
ORA-42022: partition cannot be redefined online because of presence of nested columns
Cause: An attempt was made to online redefine a partition with nested table columns.
Action: Do not attempt to online redefine a partition with nested table columns.
ORA-42023: compatibility of AQ table must be release 8.1.x or later
Cause: An attempt was made to perform online redefinition on an AQ table that was created with compatibility prior to release 8.1.x.
Action: Ensure that the AQ table is created with the COMPATIBLE parameter set to release 8.1.x or later before attempting online redefinition.
ORA-42024: interim table of an AQ table can not be a partitioned table
Cause: An attempt was made to use a partitioned table as an interim table.
Action: Ensure that the interim table is not a partitioned table.
ORA-42025: redefinition of CONS_USE_ROWID method cannot be used to redefine an AQ IOT table
Cause: An attempt was made to use method of DBMS_REDEFINITION.CONS_USE_ROWID to redefine an AQ IOT table.
Action: Ensure that method of DBMS_REDEFINITION.CONS_USE_PK is used to redefine an AQ IOT table.
ORA-42026: duplicated rows detected while instantiating the redefinition
Cause: Duplicated rows are detected during instantiation of the redefinition.
Action: Abort the redefinition, turn off the optimistic ascending SCN optimization, and restart the redefinition.
ORA-42027: cannot redefine an object online that is not a table
Cause: An attempt was made to redefine an object online that is not a table.
Action: Ensure that the object being redefined online is a table.
ORA-42028: materialized view log "string"."string" does not exist
Cause: An attempt was made to register a nonexistent materialized view log as a dependent object.
Action: Invoke DBMS_REDEFINITION.REGISTER_DEPENDENT_OBJECT on a valid materialized view log.
ORA-42029: cannot online redefine table "string"."string" at this time
Cause: An attempt was made to redefine a table which is incompatible with another ongoing redefinition.
Action: Do not perform the redefinition operation on this table or wait until the incompatible ongoing redefinition has completed. /////////////////////////////////////////////////////////////////////////// Reserving 42300 - 42398 for Editioning Views. ///////////////////////////////////////////////////////////////////////////
ORA-42300: an Editioning view is already defined on this table
Cause: An attempt was made to create an Editioning view on a table on which another Editioning view is already defined in the same Edition. This violates a restriction that at most one Editioning view may be associated with any base table in a given Edition.
Action: Create the new view as a regular view or, if the view being created is really intended to be an Editioning view associated with this table, drop the existing Editioning view before creating the new one.
ORA-42301: only COMPILE, READ ONLY, READ WRITE clause may be specified for an Editioning view
Cause: ALTER VIEW statement with a clause other then COMPILE, READ ONLY, READ WRITE was issued against an Editioning view, which is the only clause supported for such views.
Action: Avoid specifying clauses other than COMPILE, READ ONLY, READ WRITE when issuing ALTER VIEW statement against Editioning views.
ORA-42302: definition of an Editioning view may not refer to remote tables
Cause: An attempt was made to create an Editioning view referring to remote tables, which is not supported.
Action: Do not create an Editioning view if you want the view to refer to a remote table.
ORA-42303: duplicate column reference in a definition of an Editioning view
Cause: An attempt was made create an Editioning view referencing the same column of a base table more than once, which is not supported.
Action: Do not create an Editioning view if you have multiple columns referring to the same column of the base table.
ORA-42304: base table and the Editioning view must belong to the same schema
Cause: An attempt was made to create an Editioning view in a schema different from that of the base table.
Action: Create an Editioning view in the same schema as the base table.
ORA-42305: only an Editioning view may replace an Editioning view
Cause: An attempt was made to replace an Editioning view with a view which is not an Editioning view or vice versa.
Action: Ensure that either both or neither of the views involved are Editioning views.
ORA-42306: a CrossEdition trigger may not be created on an Editioning view
Cause: An attempt was made to create a CrossEdition trigger on an Editioning view, which is not supported.
Action: Instead of creating a CrossEdition trigger on an Editioning view, create it on the Editioning view's underlying table.
ORA-42307: columns of an Editioning view may only refer to base table columns
Cause: An attempt was made to define an Editioning view containing a column referring to an entity other than a base table column (for example, a PL/SQL function without a parameter), which is not supported.
Action: Ensure that every column of an Editioning view refers to a column of a base table.
ORA-42308: view string.string is already in read-only mode
Cause: An attempt was made to set a read-only table in read-only mode.
Action: This DDL can only be executed on a read/write view.
ORA-42309: view string.string is already in read/write mode
Cause: An attempt was made to set a read/write view in read/write mode.
Action: This DDL can only be executed on a read-only view.
ORA-42310: Implementation restriction: this operation is only permitted on Editioning views
Cause: The view being altered was not an Editioning view. In this release, an ALTER VIEW READ ONLY, or ALTER VIEW READ WRITE operation is only permitted on Editioning views.
Action: Ensure that the view is an Editioning view.
ORA-42311: This operation is only permitted on views with compilation erros
Cause: ALTER VIEW READ ONLY and ALTER VIEW READ WRITE is not permitted on views which has compilation errors.
Action: Resolve the compilation errors.
ORA-42399: cannot perform a DML operation on a read-only view
Cause: An attempt was made to insert, delete, or update row(s) of a view created with read-only option. DML operations on such views are explicitly prohibited.
Action: Perform the desired DML operation on the view's underlying base table or issue ALTER VIEW ... READ WRITE command to make the view updatable.