INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21560',' argument string is null, invalid, or out of range',' The argument is expecting a non-null, valid value but the argument value passed in is null, invalid, or out of range. Examples include when the LOB/FILE positional or size argument has a value outside the range 1 through (4GB - 1), or when an invalid open mode is used to open a file, and so on.',' Check your program and correct the caller of the routine to not pass a null, invalid or out-of-range argument value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21561',' OID generation failed',' The handles passed in may not be valid.',' Check the validity of the env, svc handles.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21600',' path expression too long',' The path expression that is supplied by the user is too long. The path expression is used to specify the position of an attribute in an object. This error occurs when one of the intermediate elements in the path expression refers to an attribute of a built-in type. Thus, the OCI function cannot proceed on to process the rest of the elements in the path expression.',' Pass in the correct path expression to locate the attribute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21601',' attribute is not an object',' The user attempts to perform an operation (that is valid only for an object) to an attribute of a built-in type. An example of such an illegal operation is to dynamically set a null structure to an attribute of a built-in type.',' Avoid performing such operation to an attribute of built-in type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21602',' operation does not support the specified typecode',' The user attempts to perform an operation that does not support the specified type code.',' Use the range of valid type codes that are supported by this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21603',' property id [string] is invalid',' The specified property ID is invalid.',' Specify a valid property ID. Valid property IDs are enumerated by OCIObjectPropId.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21604',' property [string] is not a property of transient or value instances',' An attempt was made to get a property which applies only to persistent objects.',' Check the lifetime and only get this property for persistent objects.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21605',' property [string] is not a property of value instances',' An attempt was made to get a property which applies only to persistent and transient objects.',' Check the lifetime and only get this property for persistent and transient objects.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21606',' can not free this object',' An attempt was made to free an object that is persistent and dirty and the OCI_OBJECTFREE_FORCE flag is not specified.',' Either flush the persistent object or set the flag to OCI_OBJECTFREE_FORCE');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21607',' memory cartridge service handle not initialized',' Attempt to use the handle without initializing it.',' Initialize the memory cartridge service handle.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21608',' duration is invalid for this function',' Attempt to use a duration not valid for this function.',' Use a valid duration: a previously created user duration or OCI_DURATION_STATEMENT or OCI_DURATION_SESSION. For callout duration or external procedure duration, use OCIExtProcAllocCallMemory.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21609',' memory being resized without being allocated first',' Attempt to resize memory without allocating it first.',' Allocate the memory first before resizing it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21610',' size [string] is invalid',' Attempt to resize memory with invalid size.',' Pass in a valid size (must be a positive integer).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21611',' key length [string] is invalid',' Attempt to use an invalid key length.',' Key length is invalid and valid range is 0 to 64.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21612',' key is already being used',' Attempt to use a key that is already used.',' Use a new key that is not yet being used.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21613',' key does not exist',' Attempt to use a non-existent key.',' Use a key that already exists.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21614',' constraint violation for attribute number string',' Constraints on the attribute were violated.',' Correct the value (of the attribute) so that it satisfies constraints.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21615',' copy of an OTS (named or simple) instance failed',' See following message.',' Check that no attribute value violates constraints.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21700',' object does not exist or is marked for delete',' User attempted to perform an inappropriate operation to an object that is non-existent or marked for delete. Operations such as pinning, deleting and updating cannot be applied to an object that is non-existent or marked for delete.',' Re-initialize the reference to reference an existent object or unmark the object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21701',' attempt to flush objects to different servers',' User attempted to flush objects to different servers in one function call. These objects are obtained by calling a callback functions provided by the program.',' Avoid performing this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21702',' object is not instantiated or has been de-instantiated in cache',' User attempted to perform an inappropriate operation to a transient object that is not instantiated in the object cache. Operations that cannot be applied to a not-instantiated transient object include deleting or pinning such an object.',' Check their code to see if they are performing such an operation without instantiating the object first, or performing such an operation after the allocation duration of the object has expired.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21703',' cannot flush an object that is not modified',' See the error message.',' The object should not be flushed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21704',' cannot terminate cache or connection without flushing first',' See the error message.',' The transaction should be aborted or committed before terminating the cache or connection.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21705',' service context is invalid',' The service context that is supplied by the user is not valid.',' Establish the service context.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21706',' duration does not exist or is invalid',' The duration number that is supplied by the user is not valid.',' Establish the duration or use a correct predefined duration.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21707',' pin duration is longer than allocation duration',' The pin duration supplied by the user is longer than the allocation duration. This affects operations such as pinning and setting default parameters.',' Use a shorter pin duration or use the null duration.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21708',' inappropriate operation on a transient object',' An attempt was made to perform an inappropriate operation on a transient object. Operations that cannot be applied to a transient object include flushing and locking.',' Avoid performing such operations on a transient object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21709',' cannot refresh an object that has been modified',' An attempt was made to refresh an object that has been marked for delete, update or insert (new).',' Unmark the object before refreshing it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21710',' argument is expecting a valid memory address of an object',' The object memory address that is supplied by the user is invalid. The user may have passed in a bad memory address to a function that is expecting a valid memory address of an object.',' Pass in a valid memory address of an object to the function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-21779',' duration not active',' An attempt was made to use a duration that has been terminated.',' Avoid performing such operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22053',' overflow error',' This operation''s result is above the range of Oracle number.',' Decrease the input value(s) so that the result is in the range of Oracle number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22054',' underflow error',' This operation''s result is below the range of Oracle number.',' Increase the input value(s) so that the result is in the range of Oracle number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22055',' unknown sign flag value [string]',' Signed flag used is not OCI_NUMBER_SIGNED or OCI_NUMBER_UNSIGNED.',' Use either OCI_NUMBER_SIGNED or OCI_NUMBER_UNSIGNED as sign flag.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22056',' value [string] is divided by zero',' Given value is divided by zero.',' Modify divisor value to be non-zero.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22057',' bad integer length [string]',' The length of the integer (that is, number of bytes) to be converted to or from an Oracle number is invalid.',' Use integer length 1, 2, 4 or 8 bytes only.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22059',' buffer size [string] is too small - [string] is needed',' The buffer to hold the resulting text string is too small.',' Provide a buffer of the required size.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22060',' argument [string] is an invalid or uninitialized number',' An invalid or uninitialized number was passed in.',' Use a valid number. To initialize a number, call OCINumberSetZero().');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22061',' invalid format text [string]',' The numeric format string for converting characters to or from an Oracle number is invalid.',' Use valid format string as documented in the Oracle Call Interface Programmer''s Guide.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22062',' invalid input string [string]',' The text string for converting to numbers is invalid.',' Use a valid input string as documented in the Oracle Call Interface Programmer''s Guide.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22063',' reading negative value [string] as unsigned',' An attempt was made to convert a negative number to an unsigned integer.',' Use the sign flag ORLTSB to convert a signed number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22064',' invalid NLS parameter string [string]',' The NLS parameter string for converting characters to or from an Oracle number is invalid.',' Use valid format string as documented in the Oracle Call Interface Programmer''s Guide.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22065',' number to text translation for the given format causes overflow',' Rounding done due to the given string format causes overflow.',' Change the string format such that overflow does not occur.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22130',' buffer size [string] is less than the required size [string]',' The size of the buffer into which the hexadecimal REF string is to be written is too small.',' Provide a buffer of the required size.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22131',' hexadecimal string length is zero',' The given hexadecimal string length must be greater than zero.',' Specify a length greater than zero.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22132',' hexadecimal string does not correspond to a valid REF',' The given hexadecimal string is invalid.',' Provide a valid hexadecimal string which was previously returned by a call to OCIRefToHex().');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22140',' given size [string] must be in the range of 0 to [string]',' The given resize size is invalid.',' Ensure that the given size is in the required range.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22150',' variable-length array has not been initialized',' An un-initialized variable-length array is being operated upon.',' Initialize the variable-length array prior to calling this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22151',' cannot resize non-zero variable-length array to zero elements',' An attempt was made to resize a non-zero variable-length array to 0 elements.',' Specify a non-zero size.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22152',' destination variable-length array is not initialized',' The variable-length array on the right-hand-side of an assignment or the destination array of an append is not initialized.',' Initialize the destination variable-length array prior to calling this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22153',' source variable-length array is not initialized',' The variable-length array on the left-hand-side of an assignment or the source array of an append is not initialized.',' Initialize the destination variable-length array prior to calling this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22160',' element at index [string] does not exist',' Collection element at the given index does not exist.',' Specify the index of an element which exists.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22161',' type code [string] is not valid',' Given type code is not valid.',' Use one of the type codes enumerated in OCITypeCode.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22162',' element at index [string] has been previously deleted',' An attempt was made to delete a non-existent collection element.',' Check for the existence of the element prior to calling this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22163',' left hand and right hand side collections are not of same type',' Left hand and right side collections are not of same type.',' Ensure that the same collection type is passed for both left hand and right hand side of this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22164',' delete element operation is not allowed for variable-length array',' An attempt was made to delete an element of a variable-length array.',' Ensure that the collection is not a variable-length array prior to calling this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22165',' given index [string] must be in the range of 0 to [string]',' Given index is not in the required range.',' Ensure that the given index is in the required range.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22166',' collection is empty',' Given collection is empty.',' Test if collection is empty prior to invoking this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22167',' given trim size [string] must be less than or equal to [string]',' Given trim size is greater than the current collection size.',' Ensure that the given size is less than or equal to the collection size prior to calling this function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22275',' invalid LOB locator specified',' There are several causes:',' For (1), initialize the LOB locator by selecting into the locator variable or by setting the LOB locator to empty. For (2),(3), (5), and (6),pass the correct type of locator into the routine. For (4), remove the trigger body code that updates the LOB value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22276',' invalid locator for LOB buffering',' One of the following:',' For (1) enable the locator for buffering; (2) ensure that only an updated locator is used for a LOB update operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22277',' cannot use two different locators to modify the same LOB',' LOB buffering is enabled and an attempt was made to modify the LOB using two different LOB locators.',' When using LOB buffering, modify the LOB through one LOB locator only.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22278',' must update the LOB only through the LOB buffers',' LOB buffering is enabled for this LOB and there are buffers for this LOB in the buffer pool. Thus, updating the LOB through means other than the LOB buffers is not allowed.',' Update the LOB through the LOB buffers using the locator that has LOB buffering enabled. If this operation is required, buffers associated with this LOB should either be flushed as necessary or buffering should be disabled. Once this is done, reissue the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22279',' cannot perform operation with LOB buffering enabled',' The operation attempted is not allowed when LOB buffering is enabled.',' If the operation is required, LOB buffering should not be used. In this case, flush buffers associated with the input LOB locator as necessary, disable buffering on the input LOB locator and reissue the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22280',' no more buffers available for operation',' One of the following:',' For (1), flush the LOB(s) through the locator that is being used to update the LOB. For (2), write to the LOB through a locator enabled for buffering before attempting to flush buffers.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22281',' cannot perform operation with an updated locator',' The input locator has buffering enabled and was used to update the LOB value through the LOB buffering subsystem. The modified buffer has not been flushed since the write that was performed by the input locator; thus, the input locator is considered an updated locator. Updated locators cannot be the source of a copy operation. Only one locator per LOB may be used to modify the LOB value through the LOB buffering subsystem.',' Depending on whether the modifications made through the input locator to the LOB buffering subsystem should be written to the server, either flush the buffer to write the modifications, or, disable buffering on the locator to discard the modifications. Then, reissue the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22282',' non-contiguous append to a buffering enabled LOB not allowed',' The buffered write operation has an input offset value more than one byte or character past the end of the LOB.',' Specify an input offset value which is exactly one character or byte greater than the length of the LOB that you are attempting to update through a buffered write operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22283',' filename contains characters that refer to parent directory',' Filename contains a path "../" which references a parent directory.',' Ensure that the filename does not contain characters which reference a parent directory.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22285',' non-existent directory or file for string operation',' An attempt was made to access a directory that does not exist, or attempted to access a file in a directory that does not exist.',' Ensure that a system object corresponding to the specified directory exists in the database dictionary, or make sure the name is correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22286',' insufficient privileges on file or directory to perform string operation',' The user does not have the necessary access privileges on the directory alias and/or the file for the operation.',' Ask the database/system administrator to grant the required privileges on the directory alias and/or the file.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22287',' invalid or modified directory occurred during string operation',' The directory alias used for the current operation is not valid if being accessed for the first time, or has been modified by the database administrator since the last access.',' If you are accessing this directory for the first time, provide a valid directory name. If you have been already successful in opening a file under this directory before this error occurred, then close the file and retry the operation with a valid directory alias as modified by your database administrator. Oracle recommends that directories should be modified only during quiescent periods.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22288',' file or LOB operation string failed string',' The operation attempted on the file or LOB failed.',' See the next error message in the error stack for more detailed information. Also, verify that the file or LOB exists and that the necessary privileges are set for the specified operation. If the error still persists, report the error to the database administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22289',' cannot perform string operation on an unopened file or LOB',' The file or LOB is not open for the required operation to be performed.',' Precede the current operation with a successful open operation on the file or LOB.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22290',' operation would exceed the maximum number of opened files or LOBs',' The number of open files or LOBs has reached the maximum limit.',' Close some of the opened files or LOBs and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22291',' Open LOBs exist at transaction commit time',' An attempt was made to commit a transaction with open LOBs at transaction commit time.',' Close the LOBs before committing the transaction.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22292',' Cannot open a LOB in read-write mode without a transaction',' An attempt was made to open a LOB in read-write mode before a transaction was started.',' Start a transaction before opening the LOB in read-write mode. Ways to start a transaction include issuing a SQL DML or SELECT FOR UPDATE command. Opening the LOB in read-only mode does not require a transaction.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22293',' LOB already opened in the same transaction',' An attempt was made to open a LOB that already is open in this transaction.',' Close the LOB before attempting to reopen it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22294',' cannot update a LOB opened in read-only mode',' An attempt was made to write to or update a LOB opened in read-only mode.',' Close the LOB and reopen it in read-write mode before attempting to write to or update the LOB.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22295',' cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement',' An attempt was made to bind more than 4000 bytes of data to both LOB and LONG columns in the same insert or update statement. You can bind more than 4000 bytes of data to either a LONG column or one or more LOB columns, but not both.',' Bind more than 4000 bytes of data to either the LONG column or one or more LOB columns, but not both.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22296',' invalid ALTER TABLE option for conversion of LONG datatype to LOB',' An attempt was made to specify ALTER TABLE options which are disallowed during conversion of LONG datatype to LOB. The only ALTER TABLE options allowed during conversion of LONG datatype to LOB are the default clause and LOB storage clause for the column being converted to LOB.',' Remove the disallowed options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22297',' warning: Open LOBs exist at transaction commit time',' An attempt was made to commit a transaction with open LOBs at transaction commit time.',' This is just a warning. The transaction was commited successfully, but any domain or functional indexes on the open LOBs were not updated. You may want to rebuild those indexes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22303',' type "string"."string" not found',' An attempt was made to obtain information for a type that cannot be found.',' Check that the schema is correct and that the type has been created correctly.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22304',' input type is not an object type',' An attempt was made to obtain the supertype information for a non-object type.',' Pass in only an object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22305',' attribute/method/parameter "string" not found',' Type element with the given name is not found in the type.',' Check to make sure that the type element exists.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22306',' type "string"."string" already exists',' An attempt was made to create a type that already exists.',' Check to make sure that the type has not been created prior to this.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22307',' operation must be on a user-defined type',' An attempt was made to perform an operation that is allowed only on a user-defined type, and the type is not a user-defined type.',' Check to make sure that only user-defined types are being operated on.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22308',' operation not allowed on evolved type',' An attempt was made to replace a type whose attribute definition has been altered.',' Submit ALTER TYPE ADD/DROP statement instead of ALTER TYPE REPLACE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22309',' attribute with name "string" already exists',' An attempt was made to create an object type where more than one attributes have the same name.',' Check to make sure that all attribute names are unique.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22310',' ALTER TYPE error. Refer to table "string"."string" for errors',' An invalid alter type statement was submitted.',' Correct the errors listed in the specified table and resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22311',' type for attribute "string" does not exist',' The type of the attribute does not exist.',' No types were created/modified for this DDL transaction. Redo the DDL transaction and add the creation of the attribute''s type in the DDL transaction.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22312',' must specify either CASCADE or INVALIDATE option',' An attempt was made to alter a type which has a dependent type or table without specifying the CASCADE or INVALIDATE option.',' Resubmit the statement with either the CASCADE or INVALIDATE option. Specify CASCADE if you want to cascade the type change to dependent types and tables; otherwise, specify INVALIDATE to invalidate all dependents.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22313',' cannot use two versions of the same type "string"',' The version of this type conflicts with the version of this type used by another library that was linked in with the application. An application may only use one version of a type.',' Check that the libraries being linked with this application and use the same versions of the type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22314',' method information mismatch in ALTER TYPE',' The number of methods or the method signature do not match that of the original type declaration. This is not supported.',' Make sure the method signature stay identical for the previously declared method. Do not drop existing methods.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22315',' type "string" does not contain a map or order function',' The input type does not contain a map or order function so one cannot be returned.',' Add a map or order function to the type or catch this error.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22316',' input type is not a collection type',' An attempt was made to obtain information for collection types on a non-named collection type.',' Use a named collection type for the function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22317',' typecode number is not legal as a number type',' An attempt was made to use a number type code that is not valid.',' Use only OCI_TYPECODE_SMALLINT, OCI_TYPECODE_INTEGER, OCI_TYPECODE_REAL, OCI_TYPECODE_DOUBLE, OCI_TYPECODE_FLOAT, OCI_TYPECODE_NUMBER, or OCI_TYPECODE_DECIMAL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22318',' input type is not an array type',' An attempt was made to obtain the number of elements for a non-array type.',' Pass in only a named collection type which is an array.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22319',' type attribute information altered in ALTER TYPE',' The type attribute information does not match that of the original type declaration when altering type. Attributes cannot be altered during ALTER TYPE. Only new methods can be added.',' Check that all type alterations are legal.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22320',' missing user version string',' The VERSION option is specified without a user version string.',' Resubmit the statement with the version string following the VERSION keyword.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22321',' method does not return any result',' OCITypeResult() was called on a method that does not return any results.',' Check that you are passing in the correct method descriptor, or that your method creation was done correctly.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22322',' error table "string"."string" has incorrect structure',' The specified error table does not have the expected table structure.',' Execute the DBMS_UTILITY.CREATE_ALTER_TYPE_ERROR_TABLE procedure to create an error table, then resubmit the statement using the new error table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22323',' error table "string"."string" does not exist',' The error table does not exist.',' Resubmit the statement with a correct error table name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22324',' altered type has compilation errors',' The use of the ALTER TYPE statement caused a compilation error.',' Correct the error reported and resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22326',' cannot change a type to FINAL if it has subtypes',' An attempt was made to change a type with subtypes to FINAL.',' Drop all subtypes of the target type before changing it to FINAL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22327',' cannot change a type to NOT INSTANTIABLE if it has dependent tables',' An attempt was made to change a type with dependent tables to NOT INSTANTIABLE.',' Drop all dependent tables of the target type and resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22328',' object "string"."string" has errors. string',' Altering the target type causes errors in its dependent object.',' Correct the problem in the dependent object and resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22329',' cannot alter a non-object type',' An attempt was made to execute ALTER TYPE on a non-object type.',' Drop the non-object type first, then re-create it as an object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22330',' cannot alter a type that is not valid',' An attempt was made to perform ALTER TYPE on an invalid type.',' Use the CREATE OR REPLACE TYPE command to modify the type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22331',' cannot alter an incomplete type',' An attempt was made to perform ALTER TYPE on an incomplete type.',' Use CREATE TYPE to completely define the original type before executing the ALTER TYPE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22332',' a dependent object in schema "string" has errors. string',' Altering the target type causes errors in its dependent object.',' Correct the problem in the dependent object and resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22333',' cannot reset type "string"."string" due to invalid dependent types and tables',' An attempt was made to reset the type version with invalid dependent types and tables.',' Use the ALTER TYPE COMPILE statement to compile all invalid dependent types and use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade all the dependent tables, then resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22334',' cannot reset type "string"."string". Dependent tables must be upgraded to latest version.',' An attempt was made to reset the type version when the data in the dependent table has not been upgraded to the latest type version.',' Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22335',' The client cannot work with an altered type',' A pre 9.0.0 client has requested a type that has been altered on the server.',' Only 9.0.0 and higher clients can access altered types.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22336',' table contained 8.0 image format, must specify INCLUDING DATA',' One of the following:',' Resubmit the statement with the INCLUDING DATA option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22337',' the type of accessed object has been evolved',' The type of the accessed object has been altered and the client''s object is based on an earlier type definition.',' The user needs to exit the application and modify the application to accommodate the type change. From SQL/PLUS, reconnect and resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22338',' must specify CASCADE INCLUDING DATA when altering the final property',' An attempt was made to alter the final property of a type with dependent tables without specifying the CASCADE INCLUDING DATA option.',' Resubmit the statement with the CASCADE INCLUDING DATA option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22339',' cannot alter to not final since its attribute column is substitutable',' An attempt was made to alter a type to not final when its embedded attribute is defined as substitutable in some tables. Note, this is a restriction in 9.0 version because when a type is altered to not final, column of that type is set to not substitutable at all levels; thus, it is an error if one of its embedded attribute column is already marked substitutable.',' Recreate the table and specify NOT SUBSTITUTABLE AT ALL LEVELS for all columns of non final type. Then resubmit the ALTER TYPE statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22340',' cannot string type "string"."string". Dependent tables must be upgraded to latest version',' An attempt was made to reset the version, drop or alter a type when the data in dependent table has not been upgraded to the latest version.',' Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22341',' cannot assign supertype instance to subtype',' An attempt was made to assign or copy a supertype instance to a container (destination) that can only hold a subtype instance.',' Make sure the runtime type of the source of the assignment or copy is the same type as the destination or is a subtype of the destination type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22342',' dependent VARRAY column exceeds the maximum inline column size',' An attempt was made to alter a type (add or modify attribute) which causes the size of its dependent VARRAY column to exceed the maximum inline column size. However, the VARRAY column was not specified to be stored as LOB at the table level when the table was created.',' Specify the VARRAY column to be stored as LOB at the table level when the table is created.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22343',' Compilation error for type invalidated by ALTER TYPE',' Compilation failed for a type which was invalidated by ALTER TYPE.',' Check what is causing the compilation error, correct it, and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22344',' can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change',' An attempt was made to specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change.',' Specify CONVERT TO SUBSTITUTABLE option only for ALTER TYPE NOT FINAL change.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22345',' recompile type string.string before attempting this operation',' An attempt was made to perform an operation which requires the specified datatype to be valid, but the datatype is invalid.',' Recompile the specified type and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22369',' invalid parameter encountered in method string',' An invalid parameter is being passed to this method of SYS.AnyType, SYS.AnyData, or SYS.AnyDataSet.',' Check the parameters being passed to this method and make sure that the parameters are allowed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22370',' incorrect usage of method string',' This method of SYS.AnyType, SYS.AnyData, or SYS.AnyDataSet is being used inappropriately.',' Check the documentation for correct usage.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22371',' Table contains data of type string.string, version string, which does not exist',' Some of the older versions of the type may have been deleted because one or more of the referenced types was dropped.',' These data could not be read as the whole ADT. Read the data at individual scalar attribute level.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22600',' encountered 8.0.2 (Beta) VARRAY data that cannot be processed',' Production Oracle8 (8.0.3 and beyond) encountered some VARRAY data which was created and stored by Oracle8 8.0.2 (Beta 2). Production Oracle8 cannot understand or process such VARRAY data.',' Delete the VARRAY data from the table by dropping the table, deleting the rows, or nulling out the VARRAY columns, and then reinsert the VARRAY data. There is no provided script or tool to help automate this conversion.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22601',' pickler TDS context [string] is not initialized',' An attempt was made to use the pickler TDS context without initializing it.',' Use OCIPicklerTdsCtxInit to initialize the context.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22602',' pickler TDS handle [string] is not well-formed',' An attempt was made to use the pickler TDS handle without initializing or constructing it.',' Use OCIPicklerTdsInit to initialize the handle before it is constructed. Use OCIPicklerTdsGenerate to generate the TDS before its attributes can be accessed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22603',' cannot add an attribute to the already generated TDS handle',' An attempt was made to add an attribute to the already constructed TDS.',' Use a TDS handle that is initialized but not yet constructed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22604',' TDS handle already generated',' An attempt was made to generate TDS that is already generated.',' Use a TDS handle that is initialized but not yet generated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22605',' FDO handle [string] is not initialized',' An attempt was made to use an uninitialized FDO handle.',' Use OCIPicklerFdoInit to initialize FDO handle.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22606',' pickler image handle [string] is not well-formed',' An attempt was made to use the image handle without initializing/ constructing it.',' Use OCIPicklerImageInit to initialize the handle before it is constructed. Use OCIPicklerImageGenerate to generate the image before its attributes can be accessed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22607',' image handle already generated',' An attempt was made to generate image that is already generated.',' Use a image handle that is initialized but not yet generated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22608',' cannot add an attribute to the already generated image handle',' An attempt was made to add an attribute to the already constructed image.',' Use a image handle that is initialized but not yet constructed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22609',' error string during initialization of FDO',' An error occurred during FDO initialization.',' Take an action based on the specified error.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22610',' error while adding a scalar to the image handle',' An error occurred while adding a scalar attribute to the image handle.',' Make sure image handle is initialized before adding scalar.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22611',' TDS version is not recognized',' Incorrect TDS handle is passed.',' Make sure image handle is initialized with the correct TDS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22612',' TDS does not describe a collection TDS',' Collection construct/access routines are being on an image but the TDS does not describe that a collection TDS.',' Make sure a collection TDS is used before invoking collection routines on the image handle.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22613',' buflen does not match the size of the scalar',' BUFLEN is incorrect.',' Make sure BUFLEN is correct and matches the size of the scalar.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22614',' error while construction the collection in the image',' An error occurred during the construction of collection.',' Make sure image handle is initialized and OCIPicklerImageCollBegin is called to begin collection.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22615',' attribute is not a collection',' Collection routine is invoked upon a non-collection attribute.',' Make sure attribute is a collection.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22616',' image is not of Oracle 8.1 format',' The function being invoked is applicable only for 8.1 images.',' Make sure image is of 8.1 format.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22617',' error while accessing the image handle collection',' An error occurred while accessing collection in the image handle.',' Make sure image is initialized correctly and the collection is constructed properly.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22618',' attribute is a BAD NULL in the image handle',' The attribute in question is probably the attribute of a null embedded image.',' Make sure attribute number is valid or it is NULL or NOT NULL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22619',' all collection elements have already been accessed',' An attempt was made to access a collection element after all the collection elements are already accessed.',' This function should not be invoked any more.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22620',' buffer size too small to hold the value',' Buffer size is not enough to hold the value. Most likely while doing the character set conversion, a bigger buffer is needed.',' Pass in a bigger buffer. If the client character set format differs from that of server, doing the conversion may result in 4X expansion.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22621',' error transfering an object from the agent',' An error was returned from the pickler routines on the agent side.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22625',' OCIAnyData is not well-formed',' Attempt to use the OCIAnyData without initializing constructing it.',' Use OCIAnyDataBeginConstruct to initialize the handle before it is adding attributes. Use OCIAnyDataEndConstruct to complete the construction. Or use OCIAnyDataConvert to do the construction. MAke sure it is properly constructed before accessing attributes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22626',' Type Mismatch while constructing or accessing OCIAnyData',' Type supplied is not matching the type of the AnyData. If piece wise construction or access is being attempted, the type supplied is not matching the type of the current attribute.',' Make sure the type supplied matches the type of object to be constructed or accessed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22627',' tc [string] must be that of object/varray/nested table',' Type code is not that of object/varray/nested table',' Make sure the type code is OCI_TYPECODE_OBJECT, OCI_TYPECODE_VARRAY, or OCI_TYPECODE_TABLE');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22628',' OCIAnyData already constructed',' Attempt to add attributes to OCIAnyData that is already constructed.',' Use the OCIAnyData that is initialized but not yet constructed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22629',' OCIAnyData is null',' Attempting an operation that is not valid on null OCIAnyData.',' Make sure OCIAnyData is not null.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22630',' attribute [string] is null or it is not well-formed',' Passing an attribute that is null or not well-formed.',' Make sure the attribute is not null or is well-formed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22631',' attribute [string] is is not well-formed or does not match the type',' Passing an attribute that is not well-formed or does not match the input type.',' Make sure the attribute is well-formed and matches the type specified.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22632',' AnyDataSet parameter is not valid for the current operation',' The AnyDataSet parameter is null or invalid for the current operation.',' Check the documentation for the current operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22633',' Error freeing AnyDataSet',' AnyDataSet that is passed in may not be valid.',' Check all the AnyDataSet parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22634',' Error adding new instance to AnyDataSet',' Current instance in the AnyDataSet has not been fully constructed.',' Make sure that the current instance is fully constructed before adding new instance.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22800',' invalid user-defined type',' An attempt was made to use an incomplete type as a constructor.',' Complete the type definition before using it in a query.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22801',' invalid object row variable',' The specified object row variable is not available in the scope of name resolution.',' Verify the specified object row variable is correct, or use an object row variable visible in scope.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22803',' object type contains zero attributes',' An attempt was made to create or specify a column or constructor of an object type that has no attributes. Only object types that have at least one attribute are allowed in this context.',' Specify a valid object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22804',' remote operations not permitted on object tables or user-defined type columns',' An attempt was made to perform queries or DML operations on remote object tables or on remote table columns whose type is one of object, REF, nested table or VARRAY.',' Remove the reference to remote tables in the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22805',' cannot insert NULL object into object tables or nested tables',' An attempt was made to insert a NULL object into an object table or a Nested Table.',' Ensure that a non-NULL object is inserted into the table or insert an object with attributes whose values are NULL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22806',' not an object or REF',' An attempt was made to extract an attribute from an item that is neither an object nor a REF.',' Use an object type or REF type item and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22807',' cannot resolve to a scalar type or a collection type',' Invalid use of a non-scalar (for example, object type) item.',' Change the item''s data type and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22808',' REF dereferencing not allowed',' An attempt was made to access an object type''s attributes by de-referencing a REF item.',' Make the item an object type instead of a REF to an object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22809',' nonexistent attribute',' An attempt was made to access a non-existent attribute of an object type.',' Check the attribute reference to see if it is valid. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22810',' cannot modify object attributes with REF dereferencing',' An attempt was made to modify the attributes an object by de-referencing a REF column in an UPDATE statement.',' Update the table containing the object that the REF points to, or change the REF column to an object type column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22812',' cannot reference nested table column''s storage table',' An attempt to access the nested table column''s storage table is not allowed in the given context.',' Issue the statement against the parent table containing the nested table column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22813',' operand value exceeds system limits',' Object or Collection value was too large. The size of the value might have exceeded 30k in a SORT context, or the size might be too big for available memory.',' Choose another value and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22814',' attribute or element value is larger than specified in type',' Value provided for the object type attribute or collection element exceeded the size specified in the type declaration.',' Choose another value and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22816',' unsupported feature with RETURNING clause',' RETURNING clause is currently not supported for object type columns, LONG columns, remote tables, INSERT with subquery, and dereferencing inside returning clause.',' Use separate SELECT statements to get the values.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22817',' subquery not allowed in the default clause',' An attempt was made to use a subquery in the column default clause expression.',' Remove the subquery from the default clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22818',' subquery expressions not allowed here',' An attempt was made to use a subquery expression where these are not supported.',' Rewrite the statement without the subquery expression.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22819',' scope of input value does not correspond to the scope of the target',' An attempt was made to operate on a REF value scoped to a different table than the expected one.',' Use a REF which is scoped to the expected table and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22826',' cannot construct an instance of a non instantiable type',' An attempt was made to use a non instantiable type as a constructor.',' None.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22828',' input pattern or replacement parameters exceed 32K size limit',' Value provided for the pattern or replacement string in the form of VARCHAR2 or CLOB for LOB SQL functions exceeded the 32K size limit.',' Use a shorter pattern or process a long pattern string in multiple passes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22850',' duplicate LOB storage option specificed',' A LOB storage option (CHUNK, PCTVERSION, CACHE, NOCACHE, TABLESPACE, STORAGE, INDEX) was specified more than once.',' Specify all LOB storage options only once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22851',' invalid CHUNK LOB storage option value',' The specified CHUNK LOB storage option value must be an integer.',' Choose an appropriate integer value and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22852',' invalid PCTVERSION LOB storage option value',' The specified PCTVERSION LOB storage option value must be an integer.',' Choose an appropriate integer value and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22853',' invalid LOB storage option specification',' A LOB storage option was not specified.',' Specify one of CHUNK, PCTVERSION, CACHE, NOCACHE, TABLESPACE, STORAGE, INDEX as part of the LOB storage clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22854',' invalid option for LOB storage index',' A valid LOB store index option was not specified.',' Specify one of (INITTRANS, MAXTRANS, TABLESPACE, STORAGE) as part of the LOB storage index.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22855',' optional name for LOB storage segment incorrectly specified',' The optional name for LOB storage segment was specified with multiple columns in the column list.',' Specify each column LOB storage only with optional name(s).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22856',' cannot add columns to object tables',' An attempt was made to add columns to an object table. Object tables cannot be altered to add columns since its definition is based on an object type.',' Create a new type with additional attributes, and use the new type to create an object table. The new object table will have the desired columns.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22857',' cannot modify columns of object tables',' An attempt was made to alter the object table by modifying existing columns. An object table cannot be altered to modify existing columns since it is based on an object type. The table definition must be in sync with the corresponding type.',' Create a new type with the desired attribute types and use it to create an object table. The new object table will have the desired columns.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22858',' invalid alteration of datatype',' An attempt was made to modify the column type to object, REF, nested table, VARRAY or LOB type.',' Create a new column of the desired type and copy the current column data to the new type using the appropriate type constructor.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22859',' invalid modification of columns',' An attempt was made to modify an object, REF, VARRAY, nested table, or LOB column type.',' Create a new column of the desired type and copy the current column data to the new type using the appropriate type constructor.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22860',' object type expected',' An attempt was made to create an object table using a non- object type, or to create a column that is a REF to a non-object type.',' Use a valid object type in the table or column definition.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22861',' invalid user-defined type',' An attempt was made to create a column or object table of a non-existent type.',' Specify a valid type in the table or column definition.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22862',' specified object identifier doesn''t match existing object identifier',' An attempt was made to specify an object identifier for the type that does not match the existing identifier of the incomplete type of the same name.',' Specify the correct object identifier or leave it out of the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22863',' synonym for datatype string.string not allowed',' A synonym specification for a datatype is not supported.',' Do not use the synonym for the datatype.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22864',' cannot ALTER or DROP LOB indexes',' An attempt was made to ALTER or DROP a LOB index.',' Do not operate directly on the system-defined LOB index. Perform operations on the corresponding LOB column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22865',' more than one column specified',' An attempt was made to specify multiple columns where only one is allowed.',' Specify a single column and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22866',' default character set is of varying width',' A character LOB was defined but the default character set is not fixed width.',' Ensure that the character set is of fixed width before defining character LOBs.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22868',' table with LOBs contains segments in different tablespaces',' An attempt was made to drop a tablespace which contains the segment(s) for the LOB columns of a table but does not contain the table segment.',' Find table(s) with LOB columns which have non-table segments in this tablespace. Drop these tables and reissue drop tablespace.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22869',' depth of type dependency hierarchy exceeds maximum limit',' The type dependency hierarchy was structured to have depth greater than 1024.',' Restructure the type dependency hierarchy to a shorter depth.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22870',' ALTER TYPE with REPLACE option a non-object type',' An attempt was made to perform ALTER TYPE with REPLACE option a non-object type.',' Drop the non-object type first, then re-create it as an object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22871',' ALTER TYPE with REPLACE is not allowed for pure incomplete types',' An attempt was made to perform ALTER TYPE with REPLACE option for a pure incomplete type.',' Completely define the original type, before using the ALTER TYPE with REPLACE option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22872',' OID INDEX clause not allowed on tables with primary key based object identifiers',' An attempt was made to create an OID INDEX on a table with primary key-based object identifiers.',' Remove the OID INDEX clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22873',' primary key not specified for primary key based object table',' An attempt was made to create a primary key based object table without specifying a primary key.',' Specify a primary key and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22874',' attribute "string" is not part of the type "string"',' Attribute specified in the USER_DEFINED clause is not an attribute of the REF type.',' Ensure that the name specified in the USER_DEFINED clause is the name of a valid attribute of the REF type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22875',' cannot drop primary key of an object table whose object identifier is primary key based',' An attempt was made to drop the primary key of an object table which has a primary key based object identifier.',' Remove the drop primary key clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22876',' this user-defined type is not allowed or it cannot be used in this context',' An attempt was made to create a kind of user-defined type which is not allowed, or an attempt to create table columns or use default constructor with a type on which these are not supported.',' Ensure that the type is permitted in this context.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22877',' invalid option specified for a HASH partition or subpartition of a LOB column',' One or more invalid options were encountered while parsing the physical attributes of a LOB partition or subpartition. Either the LOB partition is in a table partitioned using the HASH method, or the LOB subpartition is in a table subpartitioned using the HASH method. TABLESPACE is the only valid option for a HASH partition or subpartition.',' Remove the invalid option(s).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22878',' duplicate LOB partition or subpartition specified',' An attempt was made was made to specify a partition or subpartition that has already been specified for the LOB column.',' Remove the duplicate specification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22879',' cannot use the LOB INDEX clause for partitioned tables',' An attempt was made to specify a LOB INDEX clause in a CREATE TABLE or ALTER TABLE statement for a partitioned table.',' Remove the LOB INDEX clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22880',' invalid REF',' An invalid REF was accessed.',' Modify the REF and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22881',' dangling REF',' The object corresponding to the REF that was accessed does not exist.',' Ensure that the REF value is pointing to an existing object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22882',' object creation failed',' The object cannot be created in the database.',' Check to see if the object table exists and the object size is not too big. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22883',' object deletion failed',' The object could not be deleted from the database.',' Check to see if the object table exists. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22884',' object modification failed',' The object could not be modified in the database.',' Check to see if the object table exists and the object size is not too big. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22885',' cannot get REF to a non-persistent object',' An attempt was made to get a REF for something other than an object in an object table. REFs can only be taken for objects in object tables.',' Rewrite the query to obtain REF values from object tables.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22886',' scoped table "string" in schema "string" is not an object table',' The scoped table specified for a REF column is not an object table.',' Ensure that the scoped table is an object table. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22887',' type of REF column is not the same as that of its scoped table',' The type specified for the REF column and the type specified for the scope table are different.',' Ensure that the types of a REF column and its scoped table are the same.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22888',' duplicate SCOPE clauses for a REF column',' Multiple SCOPE clauses were specified for a single REF column.',' Remove the duplicate SCOPE clauses and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22889',' REF value does not point to scoped table',' An attempt was made to insert a REF value that does not point to the scoped table.',' Ensure that the REF values point to the scoped table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22890',' cannot specify name for REF column constraint',' An attempt was made to specify a constraint name for a constraint on a REF column.',' Remove the constraint name and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22891',' cannot have multiple columns in REF constraint',' An attempt was made to specify multiple columns in a single REF constraint.',' Specify separate constraints for each column and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22892',' scoped table "string" does not exist in schema "string"',' The scoped table specified for a REF column does not exist.',' Ensure that the scoped table exists and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22893',' constraint can be specified only for REF columns',' The constraint specified does not apply to non-REF columns.',' Remove the constraint and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22894',' cannot add constraint on existing unscoped REF columns of non-empty tables',' An attempt was made to add a constraint to existing unscoped REF columns of a table which contains one or more rows.',' Remove the constraint specification or add the constraint after emptying the table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22895',' referenced table "string" in schema "string" is not an object table',' The referenced table specified for a REF column is not an object table.',' Ensure that the referenced table is an object table. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22896',' cannot have both scope and referential constraint on REF column "string"',' REF column has both a referential and a scope constraint. A referential constraint implies a scope constraint.',' Remove either the referential or scope constraint and then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22897',' no scope clause specified for user-defined REF column "string"',' User-defined REF column does not have a scope constraint.',' Specify a scope constraint for the user-defined REF column and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22898',' existing scope clause on "string" points to a table other than the one mentioned in the referential constraint',' Table mentioned in the referential integrity constraint is different from the scope table of the REF column.',' Specify the scope table of the REF column in the referential integrity constraint and then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22899',' cannot specify both scope and rowid constraint on ref column',' An attempt was made to specify both a scope and a ROWID constraint on a REF column.',' Remove either the ROWID or scope constraint and then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22900',' the SELECT list item of THE subquery is not a collection type',' The THE subquery must SELECT a nested table or VARRAY item.',' Change the subquery to SELECT a nested table or VARRAY item.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22901',' cannot compare nested table or VARRAY or LOB attributes of an object type',' Comparison of nested table or VARRAY or LOB attributes of an object type was attempted in the absence of a MAP or ORDER method.',' Define a MAP or ORDER method for the object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22902',' CURSOR expression not allowed',' CURSOR on a subquery is allowed only in the top-level SELECT list of a query.',' Remove the CURSOR expression and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22903',' MULTISET expression not allowed',' MULTISET expressions are allowed only inside a CAST to a nested table or VARRAY type.',' put the MULTISET (subquery) expression inside a CAST to a nested table or VARRAY type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22904',' invalid reference to a nested table column',' An invalid reference was made to a nested table column.',' Remove invalid reference to the nested table column and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22905',' cannot access rows from a non-nested table item',' An attempt was made to access rows of an item whose type is not known at parse time or that is not of a nested table type.',' Use CAST to cast the item to a nested table type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22906',' cannot perform DML on expression or on nested table view column',' An attempt was made to perform a DML on an expression or on a nested table view column where a nested table column of a base table is expected.',' Only nested table column of a base table is allowed in the DML.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22907',' invalid CAST to a type that is not a nested table or VARRAY',' An attempt was made to CAST to a type that is not a nested table or VARRAY.',' Respecify CAST to a nested table or VARRAY type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22908',' reference to NULL table value',' The evaluation of the THE subquery or nested table column resulted in a NULL value implying a NULL table instance. The THE subquery or nested table column must identify a single non-NULL table instance.',' Ensure that the evaluation of the THE subquery or nested table column results in a single non-null table instance. If happening in the context of an INSERT statement where the THE subquery is the target of an insert, then ensure that an empty nested table instance is created by updating the nested table column of the parent table''s row specifying an empty nested table constructor.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22909',' exceeded maximum VARRAY limit',' The total number of elements used in VARRAY construction exceeds the specified VARRAY limit.',' Do not use the more than the specified limit of elements for VARRAY construction.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22910',' cannot specify schema name for nested tables',' Table name was qualified with schema name in the nested table column''s (or attribute''s) storage clause.',' Respecify the nested table item''s storage clause without the schema name qualification. By default, the storage table for the nested table item is created in the same schema as the containing table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22911',' duplicate storage specification for the nested table item',' The storage clause is specified more than once for the NESTED TABLE column.',' Remove the duplicate storage specification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22912',' specified column or attribute is not a nested table type',' The storage clause is specified for a column or attribute that is not a nested table column or attribute.',' Specify a valid nested table column or attribute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22913',' must specify table name for nested table column or attribute',' The storage clause is not specified for a nested table column or attribute.',' Specify the nested table storage clause for the nested table column or attribute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22914',' DROP of nested tables not supported',' An attempt was made to DROP a nested table.',' Nested tables cannot be explicitly dropped. nested tables can only be dropped by dropping their containing parent table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22915',' cannot ALTER nested tables to ADD/MODIFY columns',' An attempt was made to ADD or MODIFY columns of a nested table. Columns cannot be added or modified for a nested table.',' Instead, alter the parent table''s nested table column to cause any such change.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22916',' cannot do an exact FETCH on a query with Nested cursors',' Exact FETCH on a query was specified which is not allowed if the query returns any cursors.',' Do not use an exact FETCH.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22917',' use VARRAY to define the storage clause for this column or attribute',' Not using VARRAY to define storage clause for VARRAY column or attribute.',' Specify VARRAY before the column storage clause and resubmit the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22918',' specified column or attribute is not a VARRAY type',' An attempt was made to define a VARRAY storage clause for a column or attribute which is not VARRAY type.',' Specify VARRAY storage clause for a VARRAY column or attribute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22919',' dangling REF error or lock object failed for no wait request',' The error could be one of the following: the object corresponding to the REF does not exist or the object was locked by another user and the lock with nowait request failed.',' Ensure that the REF value is pointing to an existing object or issue a lock request without the nowait option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22920',' row containing the LOB value is not locked',' The row containing the LOB value must be locked before updating the LOB value.',' Lock the row containing the LOB value before updating the LOB value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22921',' length of input buffer is smaller than amount requested',' The buffer length is not big enough to hold the amount of data requested.',' Verify that the number of bytes/characters specified in the input amount parameter is not bigger than the number of bytes specified in the input buffer length parameter. Allocate more space for the input buffer if necessary.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22922',' nonexistent LOB value',' The LOB value associated with the input locator does not exist. The information in the locator does not refer to an existing LOB.',' Repopulate the locator by issuing a SELECT statement and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22923',' amount of data specified in streaming LOB write is 0',' An attempt was made to write LOB value via the streaming mechanism (that is, unlimited write) but the input amount of data to stream was specified as 0. Thus, the user is trying to write 0 bytes to the LOB value.',' Write more than 0 bytes to the LOB value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22924',' snapshot too old',' The version of the LOB value needed for the consistent read was already overwritten by another writer.',' Use a larger version pool.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22925',' operation would exceed maximum size allowed for a LOB value',' An attempt was made to write too much data to the LOB value. LOB size is limited to 4 gigabytes.',' Either start writing at a smaller LOB offset or write less data to the LOB value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22926',' specified trim length is greater than current LOB value''s length',' The input length for which to trim the LOB value to is greater than the current length of the LOB value.',' May not need to trim the LOB value because it''s already smaller than the trim length specified. Or, if trimming the LOB value really is required, use a smaller trim length.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22927',' invalid LOB locator specified',' One of the following:',' For (1), initialize the LOB locator by selecting into the locator variable or by setting the LOB locator to empty. For (2) and (3), pass the correct type of locator into the routine. For (4), remove the trigger body code that updates the LOB value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22928',' invalid privilege on directories',' An attempt was made to grant or revoke an invalid privilege on a directory.',' Only CREATE, DELETE, READ and WRITE privileges can be granted or revoked on directories. Do not grant or revoke other privileges.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22929',' invalid or missing directory name',' The required directory name is invalid or missing.',' Specify a valid name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22930',' directory does not exist',' An attempt was made to access a directory that does not exist.',' Make sure the name is correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22931',' MOVE of nested table to a different tablespace not supported',' An attempt was made to move a nested table to a different tablespace.',' Nested tables always collocate in the same tablespace as the parent. A nested table can be moved to a different tablespace only by moving its containing table to the target tablespace.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22933',' cannot change object with type or table dependents',' An attempt was made to replace, drop, or rename an object with type or table dependents.',' Drop depending objects or use FORCE option if available.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22950',' cannot ORDER objects without MAP or ORDER method',' An object type must have a MAP or ORDER method defined for all comparisons other than equality and inequality comparisons.',' Define a MAP or ORDER method for the object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22951',' NULL returned by ORDER method',' ORDER method used to compare two object values returned NULL which is not allowed.',' Redefine the ORDER method to not return a NULL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22970',' name does not correspond to an object view',' Either the expression is not a view name or the name specified does not correspond to an object view.',' Replace the expression with the name of an object view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22971',' invalid datatype for PRIMARY KEY-based object identifier',' When creating an object view, the datatype of an expression in the WITH OBJECT OID clause is not allowed for PRIMARY KEY-based OID.',' Replace the expression with one of appropriate scalar datatype.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22972',' NULL value not allowed in PRIMARY KEY-based object identifier',' A value constituting the PRIMARY KEY-based object identifier is NULL.',' Ensure the expressions in MAKE_REF system function or attributes in the WITH OBJECT OID clause of an object view do not evaluate to NULL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22973',' size of object identifier exceeds maximum size allowed',' Size of the PRIMARY KEY-based object identifier of an object view exceeded the maximum size of 1000 bytes.',' Specify fewer or smaller PRIMARY KEY attributes in the WITH object OID clause when creating the object view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22974',' missing WITH OBJECT OID clause',' WITH OBJECT OID clause was not specified when creating an object view.',' Specify the WITH OBJECT OID clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22975',' cannot create a PRIMARY KEY-based REF to this object view',' The object view specified in the MAKE_REF function does not have a PRIMARY KEY-based object identifier. A PRIMARY KEY-based REF cannot be created for such a view.',' Specify an object view that has a PRIMARY KEY-based object identifier in the MAKE_REF function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22976',' incorrect number of arguments to MAKE_REF',' Number of arguments for MAKE_REF is different from the number of PRIMARY KEY attributes of the object view.',' Specify all the necessary arguments for MAKE_REF.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22977',' missing or invalid attribute',' Either the attribute name is missing in the WITH OBJECT OID clause or it is invalid.',' Specify a valid attribute of the object type of the object view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22978',' only simple attribute name is allowed in the WITH OBJECT OID clause',' An attempt was made to specify a Nested attribute in the WITH OBJECT OID clause.',' Specify a top-level attribute of the object type of the object view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22979',' cannot INSERT object view REF or user-defined REF',' An attempt was made to insert an object view REF or user-defined REF in a REF column created to store system generated REF values.',' Make sure the REF to be inserted is not from an object view or from a user-defined REF column');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22980',' must specify a set of attributes for the WITH OBJECT OID clause',' The WITH OBJECT OID DEFAULT clause was used, but the underlying view or table does not have a OID.',' Specify attributes for the WITH OBJECT OID clause to create a primary key based object identifier for the object view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22981',' must specify a table/view having system generated OID',' The super-view is based on a table/view having the system generated OID and the sub-view must also be based on a similar table/view.',' Specify a table/view having the system generated OID and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22982',' cannot create sub-view under this view',' The view derives its OID from a table/view having primary key based OID and sub-views cannot be created under such views.',' Specify a view having the system generated OID or a view created with the specification of attributes in the WITH OBJECT ID clause and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22983',' not a user-defined REF',' Attempt to use a system generated REF value where a user-defined REF value should be used.',' Make sure the REF value is user-defined.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22984',' view query cannot contain references to a super view',' The query defining the view contains references to a super-view of the view being created.',' Make sure that the view query does not reference a super-view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22990',' LOB locators cannot span transactions',' A LOB locator selected in one transaction cannot be used in a different transaction.',' Reselect the LOB locator and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22991',' insufficient space allocated for argument string',' The data to be returned in the argument is greater than the amount of space allocated for the argument.',' Allocate more space for the argument.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22992',' cannot use LOB locators selected from remote tables',' A remote LOB column cannot be referenced.',' Remove references to LOBs in remote tables.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22993',' specified input amount is greater than actual source amount',NULL,' (1) will happen when using OCI''s piecewise mechanism with polling or with a callback function. Modify the code either to send the amount specified or to pass 0 as the input amount so that any amount of data can be sent. (2) will happen if the specified input amount is too large for the source LOB/FILE given the starting source offset. Either decrease the starting source offset, or decrease the amount to copy/load.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22994',' source offset is beyond the end of the source LOB',' The source offset for a LOB COPY or LOB LOADFROMFILE is beyond the end of the source LOB.',' Check the length of the LOB and then adjust the source offset.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22995',' TABLESPACE DEFAULT option is invalid in this context',' TABLESPACE DEFAULT option can be specified for LOB columns only in the following contexts:',' Remove the TABLESPACE DEFAULT option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22996',' NEXT extent size is smaller than LOB chunksize',' An attempt was made to create or alter a LOB segment so that its NEXT extent size was less than the LOB chunk size.',' Specify a NEXT extent size that is greater than or equal to the LOB chunk size.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22997',' VARRAY | OPAQUE stored as LOB is not specified at the table level',' An attempt was made to specify a VARRAY|OPAQUE column to be stored as LOB at the partition/subpartition/template level. However, the VARRAY|OPAQUE column was not specified to be stored as LOB at the table level when the table was created.',' Specify the VARRAY | OPAQUE column to be stored as LOB at the table level when the table is created. Alternatively, do not specify the VARRAY | OPAQUE column to be stored as LOB at the partition/subpartition/template level if it is not specified at the table level when the table is created.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-22998',' CLOB or NCLOB in multibyte character set not supported',' A CLOB or NCLOB in a fixed-width or varying-width multibyte character set was passed to a SQL character function which does not support multibyte LOB data.',' Use DBMS_LOB functions such as DBMS_LOB.INSTR() and DBMS_LOB.SUBSTR() or use PLSQL DBMS_LOB.READ/WRITE to access LOB data.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23290',' This operation may not be combined with any other operation',' An ALTER TABLE RENAME [COLUMN | CONSTRAINT] operation was given in conjunction with another ALTER TABLE Operation. This is not allowed.',' Ensure that RENAME COLUMN/RENAME CONSTRAINT is the only operation specified in the ALTER TABLE statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23291',' Only base table columns may be renamed',' An attempt was made to rename a column of a non-base table, such as an object table, nested table, or materialized view table. This is not allowed.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23292',' The constraint does not exist',' The given constraint name does not exist.',' Give an existing constraint''s name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23293',' Cannot rename a column which is part of a join index',' The column participates in a join index.',' If you need to rename the column, then you need to drop the join index.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23300',' string',' The stored procedure RAISE_SYSTEM_ERROR was called which causes this error to be generated.',' Correct the problem as described in the error message or contact the application administrator or database administrator for more information.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23301',' mixed use of deferred rpc destination modes',' Replication catalog determined deferred RPC destinations were mixed with destination determined by other mechanisms in the same transaction.',' Do not mix destination types in the same transaction.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23302',' application raised communication failure during deferred RPC',' An application declared a communication failure during a deferred RPC.',' Retry the application when communication is restored.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23303',' application raised generic exception during deferred RPC',' An application declared a generic failure during a deferred RPC.',' Determined by the application.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23304',' malformed deferred rpc at arg string of string in call string, in tid string',' A deferred RPC call was issued without the correct number of arguments as determined by the count parameter to DBMS_DEFER.CALL.',' Be sure the number of arguments matches the count.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23305',' internal deferred RPC error: string',' An internal error occurred in deferred RPC.',' Report the error and other information to support.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23306',' schema string does not exist',' The schema name was null or misspelled, or the schema does not exist locally.',' Specify the schema correctly, or create it with CREATE USER.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23307',' replicated schema string already exists',' The given database already replicates the given schema.',' Choose a different schema or a different database.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23308',' object string.string does not exist or is invalid',' The given name was null or misspelled, the given type was wrong, the object does not exist as a valid database object, or the object does not exist as a replicated object with the appropriate status.',' Ensure the object is valid in the database, is visible to the user, and, if appropriate, is a valid object in ALL_REPOBJECT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23309',' object string.string of type string exists',' An object in the same name space exists, perhaps with a different type or shape, or the same object has already been registered as an REPOBJECT in another object group.',' Remove the offending object with the SQL DROP command, unregister the offending object with DBMS_REPCAT.DROP_MASTER_REPOBJECT(), or reinvoke the request using TRUE for a boolean parameter such as retry or USE_EXISTING_OBJECT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23310',' object group "string"."string" is not quiesced',' The requested operation requires the object group to be suspended.',' Invoke SUSPEND_MASTER_ACTIVITY at the REPGROUP''s MASTERDEF, wait until the status has changed to quiesced, and then retry the original request.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23312',' not the masterdef according to string',' The group name is null, the group name is misspelled, the invocation or given database is not the MASTERDEF, or one of the masters does not believe the invocation database is the MASTERDEF.',' If the given group name and MASTERDEF were both correct, connect to the MASTERDEF and retry the request, or relocate the MASTERDEF at the (errant) databases using RELOCATE_MASTERDEF.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23313',' object group "string"."string" is not mastered at string',' The group name is null, the group name is misspelled, the invocation database is not a master, or the invocation database does not believe the given database is a master.',' If the given group name was correct, connect to a current master and retry the request, make the invocation database a master with ADD_MASTER_DATABASE, or use SWITCH_MVIEW_MASTER if the invocation database is a materialized view site.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23314',' database is not a materialized view site for "string"."string"',' The invocation database is not a snapshot database for the given object group.',' Connect to the desired materialized view database and retry the request, or make the invocation database a materialized view site with CREATE_MVIEW_REPSCHEMA or CREATE_MVIEW_REPGROUP.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23315',' repcatlog version or request string is not supported by version string',' Either incompatible REPCAT versions are used, or a REPCATLOG record has been corrupted.',' Convert the master to a compatible version of REPCAT or retry the request.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23316',' the masterdef is string',' The requested operation is not permitted on a MASTERDEF site.',' Relocate the MASTERDEF to another master and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23317',' a communication failure has occurred',' The remote database is inaccessible.',' Ensure the remote database is running, the communications network is functioning, and the appropriate database links are present.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23318',' a ddl failure has occurred',' User-supplied or system-generated DDL did not execute successfully.',' Examine DDL, database state, REPCATLOG, and ALL_ERRORS to determine why the failure occurred.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23319',' parameter value string is not appropriate',' The given value of a parameter is either null, misspelled, or not supported.',' Refer to the documentation and use parameter values that are appropriate for the given situation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23320',' the request failed because of values string and string',' A missing DDL record for a REPCATLOG record, or inconsistency in REPCAT views.',' Retry the request, or make the views consistent.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23321',' Pipename may not be null',' You called DBMS_PIPE with a null pipe name.',' Find out the name of the pipe and call function with non-null pipe name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23322',' Privilege error accessing pipe',' You either tried to create a pipe that already existed and belonged to someone else, or remove a pipe that you were not authorized to use, or put a message into a pipe that you were not authorized for, or get a message from a pipe that you were not authorized for.',' You may have to use a different pipe name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23323',' parameter length exceeds deferred RPC limits',' A deferred RPC parameter was longer than the deferred RPC limits of 4000 bytes for char/varchar2 parameters and 2000 bytes for raw parameters.',' Use smaller parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23324',' error string, while creating deferror entry at "string" with error string',' The given error was encountered while attempting to create a DEFERROR entry for the give error code and the give database.',' Correct the cause of the given error.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23325',' parameter type is not string',' A conflict resolution priority function was given a type different than the type assigned to the priority group; or the priority group has no type assigned or a function; or DBMS_DEFER_SYS_QUERY was called to retrieve a deferred RPC parameter from the deferred RPC queue, but the type of the parameter does not match the return type of the function.',' Use the function corresponding to the parameter type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23326',' object group "string"."string" is quiesced',' Either SUSPEND_MASTER_ACTIVITY has been called before the object group has resumed normal operation or a (deferred) RPC operation was attempted while the object group was quiesced.',' If SUSPEND_MASTER_ACTIVITY has been called and a RESUME_MASTER_ACTIVITY request is pending, wait until it completes, and then reinvoke SUSPEND_MASTER_ACTIVITY. Otherwise, resume database activity with the RESUME_MASTER_ACTIVITY call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23327',' imported deferred rpc data does not match string of importing db',' Deferred RPC queues were imported from a database with a different global name or operating system than importing database.',' Deferred RPC data should only be imported into a database with the same global name and hardware and operating system.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23328',' mview base table "string"."string" differs from master table "string"."string"',' When creating a materialized view through REPCAT, the materialized view base table name did not match a replicated table name at the master.',' Change the materialized view DDL to use the same base table as the replicated table name at the master.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23329',' successful user-provided ddl but no materialized view "string"."string"',' The DDL provided by the user to create a materialized view was executed without error, but materialized view does not exist.',' Manually back-out the DDL, and reregister with matching DDL and materialized view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23330',' column group string already exists',' The column group was already registered in the object group.',' Use a column group name not yet registered in the replicated object group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23331',' column group string does not exist',' The given column group is either null, misspelled or not registered.',' Use a registered column group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23332',' group string is in use; cannot drop',' The given column group or priority group is being used to resolve conflicts.',' Call DBMS_REPCAT procedures DROP_UPDATE_RESOLUTION, DROP_DELETE_RESOLUTION, DROP_UNIQUE_RESOLUTION so that the column group or priority group is no longer in use before dropping.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23333',' column string is already part of a column group',' An attempt was made to add a column to a column group when the column was already a member of a column group.',' Drop the column from its existing column group before trying to add it to another.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23334',' column string does not exist in table or column group',' The given column is either null, misspelled or is not part of the given table or column group.',' Use a column that is a member of the table or column group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23335',' priority group string already exists',' The priority group was already registered in the object group.',' Use a column group name not yet registered in the object group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23336',' priority group string does not exist',' The priority group was already registered in the object group.',' Use a priority group name not yet registered in the object group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23337',' priority or value not in priority group string',' The specified value or priority has not been registered as part of the priority group.',' Either specify a different value or priority that is already part of the priority group, or add the value to the priority group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23338',' priority or value already in priority group string',' The specified value or priority has already been registered as part of the priority group.',' Either specify a different value or priority that not already part of the priority group, or drop the value to the priority group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23339',' duplicate conflict resolution information',' The specified combination of column group, sequence, conflict type and/or parameter table name, parameter column name, and parameter sequence number has already been registered.',' Verify that additional conflict resolution information needs to be added and provide a new sequence number. If modifying existing information, the existing information must be dropped first.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23340',' incorrect resolution method string',' User function is specified when conflict resolution method was not "USER FUNCTION" or specified resolution method is not one of the predefined methods.',' If user function is specified when conflict resolution method was not "USER FUNCTION", either reregister function with method as "USER FUNCTION" or specify a NULL user function. Otherwise, specify one of the documented supported conflict resolution methods.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23341',' user function required',' A NULL user function was specified for the "USER FUNCTION" method.',' Provide user function name (for example, "schema"."package"."function") that conforms to the documented user function specifications or specify one of the documented supported conflict resolution methods.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23342',' invalid parameter column string',' The parameter column name is null or misspelled, the invocation database is not a master, or is of the wrong type for the specified conflict resolution method.',' Specify a parameter column from the specified column group that has a correct type for the conflict resolution method.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23343',' no match for specified conflict resolution information',' The specified combination of column group, sequence, conflict type has not been registered (for example, for adding a comment).',' Specify a combination of column group, sequence, conflict type has been registered.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23344',' constraint (string.string) does not exist',' A null, misspelled or non-existent constraint was specified when registering a uniqueness conflict.',' Register a named constraint for the specified table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23345',' table "string"."string" not registered to collect statistics',' A procedure that deals with conflict resolution statistics-gathering was called for a table that was not registered to collect statistics.',' Call DBMS_REPCAT.REGISTER_STATISTICS to register the table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23346',' primary key or object ID is undefined for table or materialized view string',' An attempt was made to generate replication support for a table or materialized view without a primary key (as defined by a constraint or DBMS_REPCAT.SET_COLUMNS) or an object ID.',' For a table, add a primary key constraint or define a primary key using DBMS_REPCAT.SET_COLUMNS or use object tables. For a ROWID materialized view, set min_communication to false or use primary key or object ID materialized views.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23347',' datatype string for column string table string not supported',' The table has a column whose datatype is not supported by REPCAT.',' Remove the column from the table, or alter the column to have one of the supported datatypes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23348',' cannot replicate procedure string; only IN parameters supported',' An attempt was made to generate replication support for a package that has a procedure with OUT or IN OUT parameters.',' Remove the procedure from the package, or remove the OUT or IN OUT parameters from the procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23349',' cannot generate replication support for functions',' An attempt was made to generate replication support for a package that has a public function, or for a standalone function.',' Remove the public function from the package, or alter the function to be a procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23350',' maximum number of recursive calls exceeded',' This usually occurs when trying to resolve conflicts in a table while concurrent updates to the same row create more conflicts.',' Re-execute the deferred transaction from DefError using DBMS_DEFER_SYS.EXECUTE_ERROR.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23351',' parameter datatype string for procedure string not supported',' The procedure has a parameter whose datatype is not supported by REPCAT.',' Remove the parameter from the procedure, or alter the parameter to have one of the supported datatypes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23352',' duplicate destination for deferred transaction',' A duplicate destination was specified for a deferred transaction either in a DBMS_DEFER.CALL call or an earlier DBMS_DEFER.TRANSACTION call or a dbms_defer_sys.add_default_dest call.',' Remove the duplicate entry.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23353',' deferred RPC queue has entries for object group "string"."string"',' The requested action cannot be performed until the queue is empty for the given object group.',' Use DBMS_DEFER_SYS.EXECUTE or DBMS_DEFER_SYS.DELETE_TRAN to empty the queue.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23354',' deferred RPC execution disabled for "string" with "string"',' Deferred RPC cannot be executed at the destination with the specified catchup value because their propagation has been disabled.',' Enable deferred RPC execution with the DBMS_DEFER_SYS.SET_DISABLED call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23355',' object string.string does not exist or is invalid at master site',' The given name was null or misspelled, the given type was wrong, the object does not exist as a valid database object at the master site, or the object does not exist as a replicated object with the appropriate status.',' Ensure the object is valid in the master database, and is visible to the user, and, if appropriate, is a valid object in ALL_REPOBJECT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23356',' masterdef recognizes a master which does not recognize the masterdef',' Possibly DROP_MASTER_REPGROUP was run at a master site but REMOVE_MASTER_DATABASES was not run at master definition site for that master.',' Run REMOVE_MASTER_DATABASES from master definition site to remove the appropriate master (see associated error messages).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23357',' the propagator does not exist',' The propagator does not exist.',' Register a new propagator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23358',' invalid remote user',' The local user does not match the remote user connected via a database link.',' Drop and re-create the identified database link with the connect-to user identical to the owner of the database link.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23359',' error on creating a ddl record for a repcatlog record',' The USERID in the REPCATLOG record does not match the USERID of the connected user.',' Retry the operation with a different user.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23360',' only one materialized view for master table "string" can be created',' An attempt was made to create more than one materialized view on a given master table in the same rep group.',' Create these other materialized views in a different rep group at another site.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23361',' materialized view "string" does not exist at master site',' The materialized view does not exist at the master site for offline instantiation of the materialized view.',' The correct procedure is to create the materialized view in a different schema at the master site, and then follow the instructions for offline instantiation of materialized views.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23362',' invalid user',' The given user does not exist.',' Enter the name of a valid user and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23363',' mismatch of mview base table "string" at master and mview site',' The name of the base table of the materialized view at the master site is different from the base table at the materialized view site. This error may arise during offline instantiation of materialized views.',' Retry offline instantiation with a materialized view name less than 24 bytes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23364',' Feature not enabled: Advanced replication',' The Advanced Replication feature is not enabled at this site. Updatable materialized views, deferred RPCs, and other replication features are, therefore, unavailable.',' Do not attempt to use this feature. Contact Oracle Support Services if the Advanced Replication feature has been purchased but not enabled.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23365',' site string does not exist',' site specified in argument REFERENCE_SITE or argument COMPARISON_SITE in call to DIFFERENCES() routine or RECTIFY() routine does not name an existing site.',' Make sure that database sites specified really do exist, and rerun the routine.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23366',' integer value string is less than 1',' Value of argument MAX_MISSING to routine DIFFERENCES() cannot be less than 1. Value of argument COMMIT_ROWS to routines DIFFERENCES() and RECTIFY() cannot be less than 1.',' Choose an integer value for those arguments to be 1 or greater.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23367',' table string is missing the primary key',' Table specified in argument "oname1" or "oname2" in call to "differences()" routine does not contain either a primary key or a virtual primary key (defined through DBMS_REPCAT package under symmetric replication).',' Make sure the tables specified have a primary key defined.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23368',' name string cannot be null or the empty string',' Argument SNAME1, SNAME2, ONAME1, ONAME2, MISSING_ROWS_SNAME, MISSING_ROWS_ONAME1, MISSING_ROWS_ONAME2 to DIFFERENCES() or RECTIFY() cannot be NULL or '''' (empty string).',' Change argument to non-null or non-empty string.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23369',' value of "string" argument cannot be null',' Argument MAX_MISSING to DIFFERENCES() routine cannot be NULL.',' Legal values for MAX_MISSING are integers 1 or greater.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23370',' table string and table string are not shape equivalent (string)',' The tables specified are not shape equivalent, which means intuitively that the number of columns, the names, their datatypes and lengths are not the same. Specifically, problem is in the parentheses and is one of the following: the number of columns are not equal, datatypes of columns with same name in different tables are different, lengths of varchar2 and char columns are not equal, precision and scale of number datatypes are not equal.',' Make sure the two tables being compared have the same number of columns, same column names, and same datatypes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23371',' column string unknown in table string',' Some column in ARRAY_COLUMNS argument (or COLUMN_LIST argument) to DIFFERENCES() routine does not correspond to a column in the specified table.',' Make sure that all the columns in either ARRAY_COLUMNS or COLUMN_LIST are present in the specified table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23372',' type string in table string is unsupported',' Certain types in the table comparison utility are not supported.',' Make sure that the types of columns in the tables to be compared are the ones supported by symmetric replication.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23373',' object group "string"."string" does not exist',' The group name was null or misspelled, or the group does not exist locally.',' Specify the group correctly, or create it with DBMS_REPCAT.CREATE_MASTER_REPGROUP().');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23374',' object group "string"."string" already exists',' The given database already replicates the given object group. A&nbsp;materialized view repgroup cannot be created at a given site where a master repgroup with the same name already exists.',' Choose a different group or a different database.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23375',' feature is incompatible with database version at string',' A feature not compatible with the specified database was used.',' Set or raise the value of the COMPATIBLE initialization parameter to match the necessary compatibility level.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23376',' node string is not compatible with replication version "string"',' A feature not compatible with the remote database was used.',' Upgrade the remote database and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23377',' bad name string for missing_rows_oname1 argument',' An attempt was made to use the name of the reference site table as the name of the missing_rows_oname1 argument.',' Provide a separately created table with a different name for MISSING_ROWS_ONAME1 argument. The separately created table will contain the differences between the tables being compared.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23378',' connection qualifier "string" is not valid for object group "string"."string"',' The connection qualifier used in the database link for the specified object group does not match the qualifier specified for the group in CREATE_MASTER_REPGROUP.',' Use or create a database link which contains the correct connection qualifier.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23379',' connection qualifier "string" is too long',' The maximum length of a database link, including the connection qualifier, is 128 bytes.',' Use a shorter connection qualifier, or shorten the name of the database link');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23380',' propagation mode "string" is not valid',' The specified propagation is misspelled, or is not supported. For materialized view sites, all materialized view object groups at the same materialized view site with the same master object group must all have the same propagation method.',' Refer to Oracle9i Replication for valid propagation modes. For materialized view sites, also ensure that the propagation modes of all materialized view object groups with the same master object group are the same.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23381',' generated object for base object string.string@string does not exist',' The system generated object(s) for the specified base object do not exist at the specified site. The current operation requires the base object to have generated replication support.',' Ensure that the generated replication object(s) for the base object exist and are valid at the specified site. If the generated object(s) do not exist, then the procedure DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT() needs to be called from the master definition site for the base object. missing_rows_oname1 argument. The separately created table will contain the differences between the tables being compared.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23382',' materialized view repgroup "string"."string" is not registered at site string',' The materialized view REPGROUP is not currently registered at the master and so cannot be unregistered.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23383',' registration for materialized view repgroup "string"."string" failed at site string',' Insertion into local REPSCHEMA table failed.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23384',' replication parallel push string argument out of range',' Specified numeric argument to DBMS_DEFER_SYS.PUSH is invalid.',' Fix the argument value and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23385',' replication parallel push string argument not valid',' Specified string argument to DBMS_DEFER_SYS.PUSH is invalid.',' Fix the argument value and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23386',' replication parallel push cannot create slave processes',' An error was occurred while creating slave processes for parallel push.',' If the PARALLEL_MAX_SERVERS initialization parameter is zero, reconfigure the parameter to be greater than zero. Otherwise, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23387',' replication parallel push dequeue error',' An attempt to dequeue a deferred transaction failed while trying to assign a new queue batch number.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23388',' replication parallel push watermark error',' An error occurred during parallel push while trying to update the high-water-mark information in SYSTEM.DEF$_DESTINATION.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23389',' obsolete procedure; drop objects and recreate using new master',' DBMS_REPCAT.SWITCH_MVIEW_MASTER is no longer supported.',' Drop the objects in the object group and re-create them using the new master.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23392',' could not find materialized view to be associated with "string"."string"',' Could not find materialized view associated with a trigger or index that is being pulled from the master site.',' Ensure that materialized view, master, and master index or trigger are registered as replicated objects.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23393',' the user is already the propagator',' The given user is already the current propagator.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23394',' duplicate propagator',' More than one valid propagator exists.',' Unregister any duplicate propagator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23395',' object "string"."string" of type "string" does not exist or is invalid',' The given name was null or misspelled, the given type was wrong, the object does not exist as a valid database object, or the object does not exist as a replicated object with the appropriate status.',' Ensure the object is valid in the database, is visible to the user, and, if appropriate, is a valid object in ALL_REPOBJECT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23396',' database link "string" does not exist or has not been scheduled',' The database link does not exist in the schema of the replication propagator or has not been scheduled.',' Ensure that the database link exists in the database, is accessible and is scheduled for execution.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23397',' global name "string" does not match database link name "string"',' The database link name at the local node does not match the global name of the database that the link accesses.',' Ensure that global names is set to true and the link name matches the global name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23398',' user name "string" at database link "string" does not match local user name "string"',' The user name of the replication administration user at the local node and the user name at the node corresponding to the database link are not the same. Symmetric replication expects the two users to be the same.',' Ensure that the user ID of the replication administration user at the local node and the user ID at the node corresponding to the database link are the same.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23399',' generation of replication support for "string"."string" is not complete',' Replication support for the specified object has not been generated or the generation process is not yet complete.',' Ensure that replication support has been generated for the object. Use DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT() to generate replication support for the object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23400',' invalid materialized view name "string"',' A null, misspelled, or badly formed materialized view name was given to DBMS_MVIEW.REFRESH.',' Provide a valid materialized view name to DBMS_MVIEW.REFRESH.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23401',' materialized view "string"."string" does not exist',' A materialized view name was given to DBMS_MVIEW.REFRESH that is not in SYS.SNAP$ or its associated views.',' Provide a materialized view name that is in SYS.SNAP$, ALL_MVIEWS or USER_MVIEWS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23402',' refresh was aborted because of conflicts caused by deferred txns',' There are outstanding conflicts logged in the DefError table at the materialized view''s master.',' Resolve the conflicts in the master DefError table and refresh again after the table is empty. Alternatively, refresh with REFRESH_AFTER_ERRORS set to TRUE, which will proceed with the refresh even if there are conflicts in the master''s DefError table. Proceeding despite conflicts can result with an updatable materialized view''s changes appearing to be temporarily lost (until a refresh succeeds after the conflicts are resolved).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23403',' refresh group "string"."string" already exists',' Making a new refresh group when there is already a group of the same name in SYS.RGROUP$.',' Choose a different refresh group name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23404',' refresh group "string"."string" does not exist',' A refresh group name was given that is not in SYS.RGROUP$.',' Provide a refresh group name that is in SYS.RGROUP$ or DBS_RGROUP.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23405',' refresh group number string does not exist',' A refresh group number was given that is not in SYS.RGROUP$.',' Provide a refresh group number that is in SYS.RGROUP$ or DBS_RGROUP.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23406',' insufficient privileges on user "string"',' The caller is not the owner of the materialized view and does not have ALTER ANY MATERIALIZED VIEW privileges.',' Perform the operation as the owner of the materialized view or as a user with ALTER ANY MATERIALIZED VIEW privileges.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23407',' object name string must be shaped like "schema"."object" or "object"',' The object name (for example, the rollback segment, the materialized view name, the refresh group) was incorrectly specified.',' Retry the operation with the object name properly specified (like "schema"."object" or "object").');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23408',' this replication operation is not supported in a mixed configuration',' Operation is not supported if the object group is replicated at a pre-V8 node.',' Ensure that all nodes of the replicated object group are V8.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23409',' could not find an unused refresh group number',' 1000 consecutive refresh group numbers, as defined by the RGROUPSEQ number, were already used by rows in SYS.RGROUP$.',' Alter the sequence number to be within a legal unused range and destroy unneeded refresh groups.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23410',' materialized view "string"."string" is already in a refresh group',' A materialized view of the same name is already in a refresh group.',' Subtract the materialized view from the current refresh group and add it to its new refresh group, or combine the two refresh groups into a single refresh group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23411',' materialized view "string"."string" is not in refresh group "string"."string"',' The specified materialized view is not in the specified refresh group.',' Try again with the proper materialized view and refresh group names.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23412',' master table''s primary key columns have changed',' The master table''s primary key constraint was modified after the primary key materialized view was created.',' Drop and re-create the primary key materialized view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23413',' table "string"."string" does not have a materialized view log',' The fast refresh cannot be performed because the master table does not contain a materialized view log.',' Use the CREATE MATERIALIZED VIEW LOG command to create a materialized view log on the master table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23414',' materialized view log for "string"."string" does not record rowid values',' A ROWID materialized view is being fast refreshed, but the materialized view log does not record ROWID information.',' Use the CREATE MATERIALIZED VIEW LOG...ADD ROWID command to begin recording ROWID information in the materialized view log.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23415',' materialized view log for "string"."string" does not record the primary key',' A primary key materialized view is being fast refreshed, but the materialized view log does not record primary key information.',' Use the CREATE MATERIALIZED VIEW LOG...ADD PRIMARY KEY command to begin recording primary key information in the materialized view log.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23416',' table "string"."string" does not contain a primary key constraint',' The master table does not contain a primary key constraint or the primary key constraint has been disabled.',' Create a primary key constraint on the master table or enable the existing constraint.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23417',' unknown materialized view type: string',' A fast refresh is being performed on a materialized view of an unknown or unsupported type.',' Check ALL_MVIEWS and ensure that the materialized view being refreshed is a valid materialized view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23418',' cannot unregister the propagator who is currently in use',' The propagator is currently used in propagating replication RPCs.',' Try again later when there is no transaction active in propagating replication RPCs.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23419',' regenerate replication support before resuming master activity',' There are tables in the object group that require regeneration of replication support.',' Check the GENERATION_STATUS column in the ALL_REPOBJECT view. Regenerate replication support for any table in the object group with a ''NEEDSGEN'' status. Resume master activity.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23420',' interval must evaluate to a time in the future',' The parameter INTERVAL evaluates to a time earlier than SYSDATE.',' Choose an expression that evaluates to a time later than SYSDATE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23421',' job number string is not a job in the job queue',' There is no job visible to the caller with the given job number.',' Choose the number of a job visible to the caller.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23422',' Oracle Server could not generate an unused job number',' Oracle Server could not generate a job number that was not used to identify another job.',' Retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23423',' job number string is not positive',' The given job number is less than 1.',' Choose a positive integer.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23424',' materialized view "string"."string" at string not registered',' The specified materialized view has not been successfully registered at this site.',' Register the materialized view manually at either the master site or the materialized view site.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23425',' invalid materialized view identifier string',' The argument provided to DBMS_MVIEW.PURGE_MVIEW_FROM_LOG is an invalid materialized view identifier or it does not identify an Oracle8 fast refreshable materialized view or the materialized view has already been purged.',' If the materialized view is an Oracle8 fast refreshable materialized view then provide PURGE_MVIEW_FROM_LOG with its valid materialized view identifier.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23426',' deferred RPC queue has entries for string',' The requested action cannot be performed until the queue is empty for the given site/database link.',' Use DBMS_DEFER_SYS.PUSH, DBMS_DEFER_SYS.PURGE_QUEUE or DBMS_DEFER_SYS.DELETE_TRAN to empty the queue.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23427',' deferred purge queue argument string out of range',' Specified numeric argument to DBMS_DEFER_SYS.PURGE_QUEUE is invalid.',' Fix the argument value and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23428',' job associated instance number string is not valid',' A job is associated with an instance that is not running.',' Choose a running instance for job affinity, or set force parameter to TRUE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23430',' argument "string" cannot be NULL or empty string',' The caller has provided an argument whose value cannot be NULL or the empty string.',' Check that the varchar2 value provided is not NULL or the empty string, and retry the call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23431',' wrong state: string',' The routine was executed against a replicated object group that was in the wrong state.',' Make sure that the replicated object group is in the state given in the error message.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23432',' master site string already exists',' An attempt was made to instantiate a replicated object group at a master site that was already a part of the object group.',' If you were trying to add this site, do nothing because it already exists; otherwise, pick the name of another site, and rerun the routine.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23433',' executing against wrong master site string',' An attempt was made to execute the routine at a site that is different from the site specified in the argument of the routine.',' Provide an argument to the routine that correctly indicates the site against which the routine should be executing.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23434',' master site string not known for object group',' The site name given as an argument to a routine was not already known to the replicated object group.',' Execute the DBMS_OFFLINE_OG.BEGIN_INSTANTIATION() routine to add a new site to the replicated object group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23435',' cannot create an updatable ROWID materialized view with LOB columns',' The propagation of LOB data from materialized view sites to the master site requires a primary key on the replicated table. Thus updatable ROWID materialized views that contain LOB columns are not supported.',' Create a primary key materialized view instead of a ROWID materialized view. If the materialized view already exists, it can be converted to a primary key materialized view using the ALTER MATERIALIZED VIEW DDL command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23436',' missing template authorization for user',' The specified template authorization does not exist.',' Check the values for user name and refresh template name to ensure a valid row exists in the DBA_REPCAT_USER_AUTHORIZATIONS view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23437',' template authorization already exists for user',' The specified user already has been authorized to use the specified refresh group template.',' Check the values for user name and refresh template name or query the DBA_REPCAT_USER_AUTHORIZATIONS view to ensure that the correct values were passed as parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23438',' missing refresh group template',' The specified refresh group template does not exist.',' Verify that the refresh group template does not exist by querying the DBA_REPCAT_REFRESH_TEMPLATES view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23439',' refresh group template already exists',' The specified refresh group template already exists.',' Verify that the refresh group template exists by querying the DBA_REPCAT_REFRESH_TEMPLATES view.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23440',' incorrect public template value',' The public template parameter is not ''Y'', ''N'' or NULL.',' Correct the value of the public template parameter. It must be ''Y'',''N'' or NULL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23441',' object does not exist for refresh group template',' The specified object does not exist in the refresh group template.',' Correct the object name and object type parameters. Check the DBA_REPCAT_TEMPLATE_OBJECTS view to verify the correct name and type of the object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23442',' object already exists for the refresh group template',' The specified object already exists in the refresh group template.',' Change the object name and object type parameters. Query the DBA_REPCAT_REMPLATE_OBJECTS view to verify the correct name and type of the object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23443',' missing template parameter',' The specified template parameter does not exist.',' Correct the template parameter value and execute the procedure again. Use the DBA_REPCAT_TEMPLATE_PARMS view to verify the name of the refresh group template and parameter name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23444',' duplicate template parameter',' The template parameter already exists for the specified refresh group template.',' Correct the template parameter value and execute the procedure again. Use the DBA_REPCAT_TEMPLATE_PARMS view to verify the name of the refresh group template and parameter name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23445',' missing template site',' The template site specified by the site name, user name and refresh group template name does not exist.',' Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_TEMPLATE_SITES view to query the existing template sites.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23446',' duplicate template site',' The template site specified by the site name, user name and refresh group template name already exists.',' Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_TEMPLATE_SITES view to query the existing template sites.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23447',' missing user parameter value',' The user parameter value specified by the user name, parameter name and refresh group template name does not exist.',' Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_USER_PARM_VALUES view to query the existing user parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23448',' duplicate user parameter value',' The user parameter value specified by the user name, parameter name and refresh group template name already exists.',' Correct the invalid parameter and execute the procedure again. Use the DBA_REPCAT_USER_PARM_VALUES view to query the existing user parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23449',' missing user name',' The user specified by the user name parameter does not exist in the database.',' Correct an invalid user name or create the user in the master database. Use the DBA_USERS view to select the valid database users.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23450',' flavor already contains object "string"."string"',' The flavor already contains the specified object.',' Check that the specified object is correct. To add all columns of a table object, delete the object from the flavor and then add it again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23451',' flavor string already defined for object group "string"."string"',' The given object group already contains a (possibly unpublished) definition of the specified flavor.',' Check the spelling of the flavor name. Check for an unpublished flavor of the desired name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23452',' flavor string of object group "string"."string" is already published',' The given object group already contains a (published) definition of the specified flavor.',' Check the spelling of the flavor name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23453',' requested operation is not supported on top flavor',' The TOP flavor has a NULL name and may not be directly defined or deleted.',' Supply the name of a flavor other than the TOP flavor or use DBMS_REPCAT routines to implicitly change the TOP flavor.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23454',' flavor string not defined for object group "string"."string"',' The given object group does not contain a (published) definition of the specified flavor.',' Check the spelling of the flavor name. Ensure the flavor has been defined (and published) for the object group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23455',' flavor string contains object "string"',' The given flavor contains the object to be dropped.',' Purge the flavor or choose another object to drop.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23456',' flavor string does not contain "string"',' The flavor does not contain the given object, column, or attribute.',' Either drop the flavor or choose a different object, column, or attribute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23457',' invalid flavor ID string',' The given flavor ID is invalid.',' Make sure this flavor has been instantiated. If the flavor ID is outside the range (-2147483647, 2147483647), contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23458',' inappropriate flavor string at string',' The given flavor at the given database prevents the operation from succeeding.',' Either change the database flavor or choose a different operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23459',' flavor string must contain "string"',' The flavor must contain the given object, column, or attribute.',' Either choose a different database flavor or ensure the object, column, or attribute is available.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23460',' missing value for column string in resolution method "string" for "string"."string"."string"',' Before resolving conflicts, some values necessary for resolving conflicts are not available; or, after resolving conflicts, some values necessary for retrying the SQL are not available.',' define appropriate flavors, provide necessary values through availability vector in USER FLAVOR FUNCTION for conflict resolution.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23461',' fail to resolve conflict for "string"."string"."string"',NULL,NULL);
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23462',' flavor string in use at site string',' The given flavor cannot be deleted because it is being used at the given site.',' Change the flavor of the site, or unregister it if it is a materialized view site.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23463',' flavor incompatible with object "string"."string"',' An existing flavor includes the specified object with an incompatible type.',' Change the type of the object, or delete the flavor if it is not in use.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23464',' flavor lacks column string of "string"."string"',' The flavor includes some columns of an object group but not all the required columns.',' Change the flavor definition to include all required columns.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23465',' flavor already includes column string of "string"."string"',' The flavor includes the specified column which is being added.',' Check that the specified column is correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23466',' flavor requires missing object "string"."string"',' The flavor includes the specified object which does not exist.',' Check that the specified object name is correct, and create the object if appropriate.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23467',' flavor lacks object "string"."string"',' The flavor does not include the specified object which is being dropped.',' Check that the specified object is correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23468',' missing string string',' The template is missing the object with the specified key.',' Add the object to the template.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23469',' string is different between templates',' The values for the specified columns are different in each template for the same key values.',' Correct the column values to make the templates the same.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23470',' invalid status',' The status should be DELETED, INSTALLING or INSTALLED. Any other status is invalid.',' Check that the specified status value is correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23471',' template not authorized for user',' The refresh template is private and the user has not been authorized to instantiate the template.',' Authorize the user to use the template.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23472',' materialized view "string"."string" must be atomically refreshed',' Non-atomic refresh is not supported for the specified materialized view.',' Set the value of the ATOMIC parameter to FALSE in the refresh procedure being used or remove the specified materialized view from the set of materialized views being refreshed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23473',' replication RPC processing for "string"."string" is disabled',' The processing of replication RPCs for the object group that contains this object is disabled. This includes RPCs in the error queue.',' Processing of replication RPCs is disabled when the object group is being offline instantiated. Wait until offline instantiation is finished.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23474',' definition of "string"."string" has changed since generation of replication support',' The current columns in the specified table and their column types do not match the columns and column types when replication support was last generated.',' Regenerate replication support for the affected table. All flavors that include the specified table should be checked for validity. Types for any UDT columns should also be checked for validity.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23475',' key column string must be sent and compared',' The specified column is a key column and must be sent and compared during replication propagation.',' Make sure every key column is sent and compared.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23476',' cannot import from string to string',' This object was imported from a database with a different global name than the importing database.',' Only import this object into a database with the same global name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23477',' unable to alter propagation mode for object group "string"."string"',' The propagation method of a materialized view object group can only be altered when no other object groups with the same master object group are sharing the materialized view site.',' Ensure that there are no other materialized view object groups at the local site with the same master object group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23478',' object group string is already mastered at string',' There is at least one other materialized view repgroup at the local site with the same group name but a different master site.',' Ensure that all materialized view repgroups at the local site with the same group name have the same master.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23480',' Column string is not a top-level column of "string"."string".',' The column is either not a top-level column or is not present in the table or materialized view.',' Ensure only valid top-level columns are used.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23482',' column string of "string"."string": object types not allowed.',' The column is of Object Type.',' Ensure that all the columns are not of Object Type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23483',' object "string"."string" not allowed in this operation.',' The specified operation does not support the given object.',' Do not invoke the operation for this object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23484',' internal internet Application Server error: string',' An internal error occurred in internet Application Server.',' Report the error and other information to support.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23485',' Column group "string" must consist of a single numeric column only',' The column group doesn''t contain only one numeric column.',' Use a column group containing a single numeric column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23487',' object groups "string"."string" and "string"."string" do not have the same connection qualifier',' The specified two object groups do not have the same connection qualifier.',' Do not invoke the operation on the above object groups, or ensure they have the same connection qualifier.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23488',' propagation mode "string" for "string" is not allowed for this operation',' This operation does not support the specified dblink in the above propagation mode.',' Do not invoke the operation for this dblink, or change the propagation mode for this dblink.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23489',' duplicate entry "string"',' The specified value is duplicated in the parameter list.',' Remove duplicated entries in the parameter list.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23490',' extension request "string" with status "string" not allowed in this operation',' The specified operation is not allowed for the extension request with the specified status.',' Ensure the extension request has the appropriate status before retrying this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23491',' no valid extension request at "string"',' The specified database does not have a valid extension request.',' Ensure there is a valid extension request in the DBA_REPEXTENSIONS view before retrying this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23492',' no new sites for extension request "string"',' There is no new site with the specified extension request.',' Ensure there is at least one new site in the DBA_REPSITES_NEW view for this request before retrying this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23493',' "string" is not a new site for extension request "string"',' The specified extension request does not include the specified site as a new site.',' Ensure the specified site is a new site for this extension request before retrying this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23494',' too many rows for destination "string"',' The specified destination has too many rows in the system.def$_destination table.',' Ensure the specified destination has at most two valid rows before retrying this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23495',' serial propagation can not be used for "string"',' The sites involved may be in the process of adding a new site without quiescing.',' Check the def$_destination table for this destination and try parallel propagation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23496',' can not change disabled status for "string" and "string"',' The disabled status for this site is set internally for synchronization during adding a new master without quiescing.',' Ensure adding a new master without quiescing finished before invoking this procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23500',' cannot switch master for a multi-tier materialized view repgroup "string"."string"',' An attempt was made to switch master for a materialized view repgroup when its parent repgroup is also a materialized view repgroup. This is not allowed.',' Drop and recreate the materialized view repgroup based on a proper parent repgroup.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23501',' refresh template cannot be instantiated for database with compatibility equal to or less than 8.0',' Instantiation of a refresh template is not supported for database compatibility equal to or less than 8.0.',' Be sure the database compatibility is equal to 8.1 or higher.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23502',' valid directory for offline instantiation is not specified',' An attempt was made to offline instantiate to a directory which is not specified or null.',' There are two ways to specify the directory:');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23503',' error occurred during IAS instantiation',' An attempt was made to instantiate a IAS site. Error occurred during IAS instantiation.',' See the other errors on the error stack to look for the source of the problem. If the error still persists, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23504',' columns added to table do not match list of columns to be added',' The list of columns passed as a parameter does not match the columns to be added to the table.',' Correct the DDL string or list of columns and rexecute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23505',' Object "string"."string" is missing.',' The specified object does not exist.',' Check that the specified object is correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23514',' invalid or incorrect number of arguments',' The arguments passed to the online redefinition API were invalid or missing.',' Call the online redefinition API with the right number of valid arguments.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23515',' materialized views and/or their indices exist in the tablespace',' An attempt was made to drop a tablespace which contains materialized views and/or their indices.',' Drop the materialized views in this tablespace. Also, find indices belonging to materialized views in this tablespace and drop then. Then try dropping the tablespace.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23531',' site owner already exists in the template',' Site owner for the template already exists.',' Do not create multiple siteowners for this template.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23532',' tables with different synchronization mechanisms are in the same group',' Tables belonging to the same replication group were specified to be cached with different synchronization mechanisms.',' Do not specify different synchronization mechanisms while caching tables belonging to the same replication group.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23533',' object "string"."string" can not be cached',' An attempt was made to cache an object which is not supported.',' Do not cache an object which is not supported.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23534',' missing column in materialized view container table "string"."string"',' After import, the materialized view container table has missing columns.',' Check if materialized view container table was imported correctly.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23535',' instantiating templates from multiple back ends is not allowed',' An attempt was made to set a new non-null back end database for an iAS site.',' Call dbms_ias_configure.set_back_end_db procedure with null dblink. Then, call the same procedure with the new non-null dblink.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23536',' the object "string"."string" is not cached at the middle tier as expected.',' The object may have been dropped or renamed at the back end after dbms_ias_inst.start_ias_inst was executed.',' Check the validity of the object at the back end and retry the instantiation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23537',' function or procedure string is not allowed to be invoked from this site.',' This function or procedure is restricted to the backend or middle tier site.',' Connect to the proper site before calling this function or procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23538',' cannot explicitly refresh a NEVER REFRESH materialized view ("string")',' An attempt was made to explicitly refresh a NEVER REFRESH materialized view.',' Do not perform this refresh operation or remove the materialized views from the list.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23600',' cannot create PROPAGATION, string already exists',' The propagate_name already exists.',' Drop the propagate_name using DROP_PROPAGATE command or specify propagate_name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23601',' PROPAGATION_NAME string does not exist',' Propagation does not exist.',' Query the DBA_PROPAGATION view to find existing propagation_name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23602',' Invalid streams process type string',' Specified streams process type is not valid.',' Specify either capture or apply.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23605',' invalid value "string" for STREAMS parameter string',' An attempt was made to specify an invalid parameter value.',' Specify a valid value for the parameter. Check the documentation for valid parameter values.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23606',' invalid object string',' An attempt was made to specify an invalid object.',' Specify a valid object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23607',' invalid column "string"',' An invalid column was specified in the column list.',' Check the columns in the object and specify the right column name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23608',' invalid resolution column "string"',' An invalid column was specified as the resolution column. The resolution column must belong to the list of columns specified in the ''column_list'' parameter.',' Check the columns in the column_list and specify the right resolution column name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-23619',' non-Oracle system error: string',' A non-Oracle database has returned an error message to STREAMS when attempting to apply a DML statement. The non-Oracle system error message is a parameter to this Oracle error.',' Corrective action may or may not be possible (depending on the non-Oracle system error). If corrective action is possible, then correct the problem and try applying the transaction again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24000',' invalid value string, string should be of the form [SCHEMA.]NAME',' An invalid value was specified for the parameter.',' Specify a string of the form [SCHEMA.]NAME.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24001',' cannot create QUEUE_TABLE, string already exists',' The queue table already exists in the queueing system.',' Drop the table first using the DROP_QUEUE_TABLE() command or specify another table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24002',' QUEUE_TABLE string does not exist',' QUEUE_TABLE does not exist.',' Query on the user view USER_QUEUE_TABLES to find out existing queue tables.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24003',' Queue table index string inconsistent with queue table string',' The queue table index has not yet been successfully imported.',' Import the queue table index before attempting to use the queue table. If the import failed, correct the problem and try to import the queue table index again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24004',' invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY',' Invalid column name was specified in the SORT_LIST.',' The valid column names are ENQ_TIME and PRIORITY.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24005',' must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables',' An attempt was made to use the SQL command DROP TABLE for queue tables, but DROP TABLE is not supported for queue tables.',' Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure instead of the DROP TABLE command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24006',' cannot create QUEUE, string already exists',' The queue requested to be created already exists.',' Specify another queue name. Query USER_QUEUES for all the existing queues in the users''s schema.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24007',' invalid value string, MAX_RETRIES should be non-negative integer',' An invalid value was specified for MAX_RETRIES.',' Specify a non-negative integer.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24008',' queue table string.string must be dropped first',' An error was detected when dropping a queue table in a cluster, tablespace, or schema.',' Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure to drop the specified queue table first; then, retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24009',' invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE',' Invalid queue type parameter.',' Valid values are NORMAL_QUEUE for normal queue and EXCEPTION_QUEUE for exception queue.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24010',' QUEUE string does not exist',' The specified queue does not exist.',' Specify a valid queue. Query USER_QUEUES for all the valid queues.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24011',' cannot drop QUEUE, string should be stopped first',' The queue has not been stopped. That is, either enqueue or dequeue is still enabled.',' Stop the queue first using the STOP_QUEUE command and disable it from both enqueueing and dequeueing.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24012',' cannot drop QUEUE_TABLE, some queues in string have not been dropped',' A queue exists in the queue table which has not been dropped. All queues need to be dropped first.',' Drop all queues belonging to this queue table using the DROP_QUEUE() command. Be sure to stop the queues appropriately before dropping them. Alternately, use the force option in DROP_QUEUETABLE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24013',' invalid value string, RETRY_DELAY should be non-negative',' A negative value was specified for RETRY_DELAY.',' Specify a non-negative value for RETRY_DELAY.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24014',' invalid value string, RETENTION_TIME should be FOREVER or non-negative',' Queue retention was specified, but the retention time was specified to be less than zero.',' Specify the retention time to be non-negative or FOREVER. Alternately do not specify retention.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24015',' cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist',' An invalid QUEUE_PAYLOAD_TYPE specified during CREATE_QUEUE_TABLE.',' The QUEUE_PAYLOAD_TYPE should be RAW or an object type that already exists in the database.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24016',' cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string',' An invalid object type specified for QUEUE_PAYLOAD_TYPE during CREATE_QUEUE_TABLE.',' Make sure you have execute privileges on the object type specified for the queue.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24017',' cannot enable enqueue on QUEUE, string is an exception queue',' An attempt was made to enable enqueueing to an exception queue.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24018',' STOP_QUEUE on string failed, outstanding transactions found',' There were outstanding transactions on the queue, and WAIT was set to false, so STOP_QUEUE was unsuccessful in stopping the queue.',' Set WAIT to TRUE and try STOP_QUEUE again. It will hang till all outstanding transactions are completed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24019',' identifier for string too long, should not be greater than string characters',' The identifier specified is too long.',' Try again with a shorter identifier.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24020',' Internal error in DBMS_AQ_IMPORT_INTERNAL, string',' An internal error occurred in the package. DBMS_AQ_IMPORT_INTERNAL.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24021',' queue table definition not imported for string.string',' The queue definition is not updated because the queue table was not imported properly.',' Import the queue table again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24022',' the specified parameters has no effect on the queue',' The parameter combination will not cause the queue to be started or stopped.',' No action required. This is a warning.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24023',' Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]',' An internal error occurred in the package DBMS_AQ_EXP_INTERNAL.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24024',' Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]',' An internal error occurred in the package DBMS_AQ_IMP_INTERNAL.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24025',' invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type',' Parameter QUEUE_PAYLOAD_TYPE has invalid value.',' Specify a valid object type or RAW.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24026',' operation failed, queue string.string has errors',' An attempt was made to enqueue, dequeue or administer a queue which has errors.',' Drop the queue table setting the force option to true.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24027',' AQ HTTP propagation encountered error, status-code string, string',' AQ propagation''s HTTP request to the propagation servlet at the specified address encountered an error.',' Specify a valid address in the connect string of the propagation destination dblink, the dblink user has the correct permissions, check if the AQ propagation servlet was properly installed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24028',' cannot create a reciever non-repudiable single consumer queue',' Tried to create a reciever non-repudiable single consumer queue.',' This feature is not supported.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24029',' operation not allowed on a single-consumer queue',' Tried an operation not allowed on a single-consumer queue.',' Specify the operation on a multi-consumer queue.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24030',' Only one of rule or rule-set must be specified',' Specified both a rule and rule-set for the operation.',' Specify only one of rule or rule-set.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24031',' invalid value, string should be non-NULL',' Parameter is NULL.',' Specify a non-NULL value for the parameter.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24032',' object string exists, index could not be created for queue table string',' Oracle AQ tried to create an index with the name specified in the error message. The index could not be created for the specified queue table because a object exists with the same name.',' Drop the object specified in the error message and retry the command. You can also choose a different name for the queue table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24033',' no recipients for message',' An enqueue was performed on a queue that has been set up for multiple dequeuers but there were neither explicit recipients specified in the call nor were any queue subscribers determined to be recipients for this message.',' Either pass a list of recipients in the enqueue call or add subscribers to the queue for receiving this message.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24034',' application string is already a subscriber for queue string',' An application name that was already a subscriber for the queue was specified in the DBMS_AQ.SUBSCRIBE call.',' Choose another application name and retry the call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24035',' AQ agent string is not a subscriber for queue string',' An AQ agent that was not a subscriber for the queue was specified.',' Check the name and/or address of the agent and retry the call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24036',' invalid SORT_ORDER column string specified for queue table',' The CREATE QUEUE TABLE command was issued with MESSAGE_GROUPING set to TRANSACTIONAL and a sort order column other than priority. Only the priority column can be specified in the sort order for queue tables with transactional grouping.',' Change the sort order list in the CREATE QUEUE TABLE command and retry the call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24037',' schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE',' The schema specified in the QUEUE_NAME parameter of CREATE_QUEUE is not the same as the schema specified in the QUEUE_TABLE parameter.',' Use the same schema name for both the QUEUE_NAME and QUEUE_TABLE parameters and retry the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24038',' RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue',' The CREATE_QUEUE or ALTER_QUEUE command was issued with a non-zero RETRY_DELAY and a QUEUE_TABLE that was created for multiple consumers and with COMPATIBLE parameter set to ''8.0''.',' Either set the RETRY_DELAY to zero or upgrade the queue table to 8.1 compatible using the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24039',' Queue string not created in queue table for multiple consumers',' Either an ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or REMOVE_SUBSCRIBER procedure, or an ENQUEUE with a non-empty recipient list, was issued on a queue that was not created for multiple consumers.',' Create the queue in a queue table that was created for multiple consumers and retry the call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24041',' propagation schedule exists for QUEUE string and DESTINATION string',' A SCHEDULE_PROPAGATION was issued for a queue and destination pair which has an existing propagation schedule.',' Issue UNSCHEDULE_PROPAGATION to remove the existing schedule and then reissue the SCHEDULE_PROPAGATION call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24042',' no propagation schedule exists for QUEUE string and DESTINATION string',' AN UNSCHEDULE_PROPAGATION was issued for a queue and destination pair which has no existing propagation schedule.',' Verify the spelling of the specified QUEUE and DESTINATION and then reissue the call with the correct spelling.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24043',' destination string uses a reserved name, names with AQ$_ prefix are not valid',' An attempt was made to specify a reserved name for a destination.',' Enter a different value or NULL for the local destination. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24044',' source string and destination string object types do not match',' A message recipient''s queue has a different object structure than the sender''s queue. The message cannot be propagated.',' Either remove the recipient from the subscriber''s list for the sender''s queue or create the destination queue with an object type that matches the source queue''s object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24045',' invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]',' An invalid value was specified for the agent address parameter.',' Specify a string of the form [SCHEMA.]NAME[@DATABASE LINK].');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24046',' protocol attribute reserved for future use',' The protocol attribute of the AQ agent object type is reserved for future use.',' Do not specify the protocol attribute in the agent object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24047',' invalid agent name string, agent name should be of the form NAME',' An invalid value was specified for the agent name parameter.',' Specify a string of the form NAME. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24048',' cannot create QUEUE_TABLE, user does not have access to AQ object types',' An attempt was made to issue the CREATE_QUEUE_TABLE command, but the user who issued the command does not have access to internal AQ object types.',' Use the DBMS_AQADM.GRANT_TYPE_ACCESS procedure to grant the user access to the AQ object types.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24049',' invalid agent name string, names with AQ$_ prefix are not valid',' An attempt was made to use a reserved prefix in the agent name.',' Enter a different value for the agent name. Then, retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24050',' subscribers are not supported for exception queue string',' An ADD_SUBSCRIBER, ALTER_SUBSCRIBER, or REMOVE_SUBSCRIBER procedure was issued on a queue that was created as an EXCEPTION_QUEUE.',' Specify a NORMAL_QUEUE in the procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24051',' cannot propagate object type payloads that have a REF or BFILE attribute',' An ADD_SUBSCRIBER or ENQUEUE procedure with a non-NULL address field in the agent type was issued on a queue whose payload has a REF or BFILE attribute. Propagation of object type payloads that have a REF or BFILE attribute currently is not supported.',' Specify an agent with a NULL address field so that the agent can dequeue from the same queue. Or, change the object type definition to one that does not use REF or BFILE attributes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24052',' cannot propagate object type payloads with LOB attributes to an 8.0 release',' The recipient of a message with LOB attributes was using an Oracle 8.0 release. Propagation of LOB attributes is supported only in Oracle 8.1 and higher releases.',' Upgrade the target release to Oracle 8.1 and retry. Or, change the object type definition to one that does not use LOBs.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24053',' PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative',' One of PRIMARY_INSTANCE or SECONDARY_INSTANCE was negative.',' Specify non-negative integers for PRIMARY_INSTANCE and SECONDARY_INSTANCE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24054',' cannot propagate to an Oracle 8.0.3 release or lower release',' The recipient of a message was using an Oracle 8.0.3 release or lower release. Propagation is supported only in Oracle 8.0.4 and higher releases.',' Upgrade the target release to Oracle 8.0.4 or higher and retry.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24055',' cannot delete propagation status rows that are in prepared state',' An attempt was made to use the internal administration procedure to delete status rows from the SYS.AQ$_PROPAGATION_STATUS table that were in the prepared state.',' Wait for the propagation to complete successfully before retrying the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24056',' internal inconsistency for QUEUE string and destination string',' The sequence numbers used in the SYS.AQ$_PROPAGATION_STATUS table were inconsistent for the given queue and destination.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24057',' cannot define subscriber with rule for queue string',' An ADD_SUBSCRIBER or ALTER_SUBSCRIBER procedure with a rule was issued on a queue for which rule based subscribers are not supported. Rule based subscribers currently are supported only for NORMAL (persistent) multi-consumer queues created using an Oracle release 8.1.0 or higher compatible queue table.',' Create a NORMAL multi-consumer queue in an Oracle release 8.1.0 or higher compatible queue table, and retry the call. Or, if the queue is a normal (persistent) multi-consumer queue, convert the queue table to Oracle 8.1.0 or higher compatibility and retry.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24058',' cannot downgrade QUEUE_TABLE that has propagation in a prepared state',' An attempt was made to downgrade the queue table when there were messages being propagated that were in the prepared state.',' Wait for the propagation to complete before retrying the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24059',' invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string',' An invalid compatible parameter was specified in the DBMS_AQADM procedure. The parameter setting must be of the form ''8.x.y'' where x is the release number and y is the update number.',' Specify a valid COMPATIBLE parameter setting, and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24060',' cannot convert QUEUE_TABLE, string already is compatible with release string',' The source queue table in the DBMS_AQADM procedure is compatible with the specified COMPATIBLE parameter setting.',' Choose a different COMPATIBLE parameter setting to convert the queue table to the desired compatibility.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24061',' cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero',' A non-zero value was specified for SECONDARY_INSTANCE when PRIMARY_INSTANCE was zero.',' Specify a non-zero primary instance before you specify a non-zero secondary instance.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24062',' Subscriber table string inconsistent with queue table string',' The subscriber table has not yet been successfully imported.',' Import the subscriber table before attempting to use the queue table. If the import failed, correct the problem and try to import the subscriber table again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24063',' cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers',' An attempt was made to downgrade the queue table when there were queues on which rule-based subscribers are defined.',' Remove the rule-based subscribers for all queues in this queue table and retry.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24064',' propagation for QUEUE string and DESTINATION string already enabled',' An ENABLE_SCHEDULE_PROPAGATION command was issued for a queue and destination pair whose propagation schedule already was enabled.',' Make sure the QUEUE and DESTINATION are correct when you issue the ENABLE_SCHEDULE_PROPAGATION command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24065',' propagation for QUEUE string and DESTINATION string already disabled',' A DISABLE_SCHEDULE_PROPAGATION command was issued for a queue and destination pair whose propagation schedule already was disabled.',' Make sure the QUEUE and DESTINATION are correct when you issue the DISABLE_SCHEDULE_PROPAGATION command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24066',' invalid privilege specified',' An invalid privilege is specified for granting or revoking privilege.',' Specify a valid privilege.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24067',' exceeded maximum number of subscribers for queue string',' An attempt was made to add new subscribers to the specified, but the number of subscribers for this queue has exceeded the maximum number (1024) of subscribers allowed per queue.',' Remove existing subscribers before trying to add new subscribers.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24068',' cannot start queue string, queue table string is being migrated',' An attempt was made to start a queue in a queue table that is being migrated.',' Complete the queue table migration, and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24069',' cannot downgrade queue table string while it is being upgraded',' An attempt was made to downgrade a queue table, but a previous command to upgrade the queue table has not yet completed successfully.',' Complete the upgrade of the queue table by re-executing the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure. Then, downgrade the queue table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24070',' cannot upgrade queue table string while it is being downgraded',' An attempt was made to upgrade a queue table, but a previous command to downgrade the queue table has not yet completed successfully.',' Complete the downgrade of the queue table by re-executing the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure. Then, upgrade the queue table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24071',' cannot perform operation string, queue table string is being migrated',' An attempt was made to perform an operation on a queue in a queue table that is being migrated.',' Complete the queue table migration, and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24072',' cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table',' An attempt was made to upgrade or downgrade a queue table using the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure, but the user who executed the procedure does not own the queue.',' Reconnect as the owner of the queue table, and then execute the DBMS_AQADM.MIGRATE_QUEUE_TABLE procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24073',' cannot specify RETENTION_TIME on exception queue string.string',' An attempt was made to create or alter an exception queue by specifying a non-zero RETENTION_TIME.',' Use the default RETENTION_TIME parameter value for exception queues.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24074',' RETRY_DELAY and MAX_RETRIES cannot be used for exception queue string',' The CREATE_QUEUE or ALTER_QUEUE command was issued with a non-zero RETRY_DELAY and an exception queue.',' Do not specify RETRY_DELAY or MAX_RETRIES for exception queues.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24075',' cannot specify agent with NULL address and non-NULL protocol',' An ADD_SUBSCRIBER or enqueue was attempted with an agent that had a NULL address and a non-NULL protocol.',' Either specify a non-NULL address or set the protocol to NULL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24076',' cannot perform operation string for NON_PERSISTENT queue string.string',' One of the operations, SCHEDULE_PROPAGATION, ALTER_QUEUE, LISTEN, DEQUEUE was issued for a NON_PERSISTENT queue.',' Do not specify a NON_PERSISTENT queue for these operations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24077',' cannot create propagation schedule for EXCEPTION queue string.string',' A SCHEDULE_PROPAGATION was issued for an EXCEPTION queue. Propagation schedules can be created only for NORMAL queues.',' To propagate messages from a queue, specify the queue type as NORMAL.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24078',' cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL',' A non-NULL value was specified for SECONDARY_INSTANCE when PRIMARY_INSTANCE was NULL.',' Specify a non-NULL primary instance before you specify a non-NULL secondary instance.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24079',' invalid name string, names with AQ$_ prefix are not valid for string',' An attempt was made to use a reserved prefix for the object name.',' Enter a different name for this object. Then, retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24080',' unschedule_propagation pending for QUEUE string and DESTINATION string',' A propagation administration command was issued for a queue and destination pair whose propagation is being unscheduled.',' Do not issue propagation administration commands for a propagation schedule on which there is a pending unschedule request.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24081',' compatible parameter needs to be string or greater',' The value of the COMPATIBLE parameter was not high enough to allow the operation.',' Shut down and restart with a higher compatibility setting.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24082',' propagation may still be happening for the schedule for QUEUE string and DESTINATION string',' The snapshot process executing the propagation schedule did not respond to the disable propagation command.',' Make sure that the job for the propagation schedule has been ended.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24083',' cannot specify remote subscribers for string QUEUE string',' An ADD_SUBSCRIBER call with a non-null address field was issued on a queue which does not support remote subscribers. Remote subscribers are not supported for NON_PERSISTENT QUEUES.',' Specify a null address field and retry the call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24084',' DBLINK name in address field of agent string is not unique within the first 24 bytes"',' Advanced Queuing requires that the agent''s DBLINK name should be unique within the first 24 bytes (for 8.0 compatible queue tables)',' Specify a DBLINK name that is unique within the first 24 bytes or migrate to 8.1 compatible queue tables where this restriction is not there.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24085',' operation failed, queue string is invalid',' An attempt was made to enqueue, dequeue or administer a queue which is invalid. This could have occurred because the payload type of the queue''s queue table was dropped.',' Drop the queue table setting the force option to true.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24086',' cannot create an 8.0 compatible string queue',' An attempt was made to create an 8.0 compatible queue table and enable a feature that is supported only on 8.1 style queue tables.',' This feature is not supported.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24087',' Invalid database user string',' An invalid database username was specified.',' Specify a valid database user.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24088',' AQ Agent string does not exist',' This AQ Agent does not exist.',' Specify a valid AQ agent. Check the DBA_AQ_AGENTS view for a list of valid aq agents.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24089',' AQ Agent string already exists',' This AQ agent has already been created.',' Specify another agent name or use the ALTER api to modify the agent.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24090',' at least one protocol must be enabled',' No protocol was enabled for aq agent.',' Enable one of the protocols by setting one of the enable parameters to true.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24093',' AQ agent string not granted privileges of database user string',' The specified AQ agent does not have privileges of the specified database user.',' Specify a valid combination of AQ agent and database user. Check the DBA_AQ_AGENT_PRIVS or USER_AQ_AGENT_PRIVS view for user/agent mappings.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24094',' invalid transformation, target type does not match that of the queue',' The target type of the transformation specified was different from the type of the queue.',' Provide a valid transformation whose target type is the same as the queue type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24095',' invalid transformation, source type does not match that of the queue',' The source type of the transformation specified was different from the type of the queue.',' Provide a valid transformation whose source type is the same as the queue type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24096',' invalid message state specified',' Invalid value was specified for message state.',' Provide a valid message state as specified in the documentation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24097',' Invalid value string, string should be non-negative',' A negative value or NULL was specified for the parameter.',' Specify a non-negative integer.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24098',' invalid value string for string',' An Invalid value or NULL was specified for the parameter.',' Check the documentation for valid values.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24099',' operation not allowed for 8.0 compatible queues',' The specified operation is only supported for queues with compatibility equal to 8.1 or higher.',' Upgrade the 8.0 compatible queue to release 8.1 using DBMS_AQADM.MIGRATE_QUEUE_TABLE or specify a queue with compatibility euqal to 8.1 or higher.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24100',' error in ktz testing layer',' There is an error in the Transaction layer test ICDs.',NULL);
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24120',' invalid string parameter passed to DBMS_REPAIR.string procedure',' An invalid parameter was passed to the specified DBMS_REPAIR procedure.',' Specify a valid parameter value or use the parameter''s default.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24121',' both cascade and a block range passed to DBMS_REPAIR.CHECK_OBJECT procedure',' Both cascade and a block range were specified in a call to DBMS_REPAIR.CHECK_OBJECT.',' Use either cascade or a block range, or do not use either one.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24122',' invalid block range specification',' An incorrect block range was specified.',' Specify correct values for the BLOCK_START and BLOCK_END parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24123',' feature string is not yet implemented',' An attempt was made to use the specified feature, but the feature is not yet implemented.',' Do not attempt to use the feature.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24124',' invalid ACTION parameter passed to DBMS_REPAIR.string procedure',' An invalid ACTION parameter was specified.',' Specify CREATE_ACTION, PURGE_ACTION or DROP_ACTION for the ACTION parameter.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24125',' Object string.string has changed',' An attempt was made to fix corrupt blocks on an object that has been dropped or truncated since DBMS_REPAIR.CHECK_OBJECT was run.',' Use DBMS_REPAIR.ADMIN_TABLES to purge the repair table and run DBMS_REPAIR.CHECK_OBJECT to determine whether there are any corrupt blocks to be fixed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24126',' invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure',' CASCADE_FLAG was specified for an object that is not a table.',' Use CASCADE_FLAG only for tables.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24127',' TABLESPACE parameter specified with an ACTION other than CREATE_ACTION',' The TABLESPACE parameter can only be used with CREATE_ACTION.',' Do not specify TABLESPACE when performing actions other than CREATE_ACTION.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24128',' partition name specified for a non-partitioned object',' A partition name was specified for an object that is not partitioned.',' Specify a partition name only if the object is partitioned.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24129',' table name string does not start with string prefix',' An attempt was made to pass a table name parameter without the specified prefix.',' Pass a valid table name parameter.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24130',' table string does not exist',' An attempt was made to specify a map, repair, or sync table that does not exist.',' Specify a valid table name parameter.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24131',' table string has incorrect columns',' An attempt was made to specify a map, repair, or sync table that does not have a correct definition.',' Specify a table name that refers to a properly created table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24132',' table name string is too long',' An attempt was made to specify a table name is greater than 30 characters long.',' Specify a valid table name parameter.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24141',' rule set string.string does not exist',' An attempt to access or modify a ruleset was made, which failed because the ruleset does not exist.',' Only access or modify existing rulesets.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24142',' invalid ruleset name',' An attempt to create a ruleset with an invalid name was made. The ruleset name cannot be NULL, and cannot be more than 26 characters, unless a RULES_TABLE_NAME is also specified, in which case the ruleset name may be up to 30 characters.',' Retry the create with a valid ruleset name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24143',' invalid evaluation context name',' An attempt to create a rule/ruleset on an invalid evaluation name was made. The evaluation_context can not be more than 30 characters. The evaluation context with the name specified must exist.',' Retry the create with a valid evaluation context name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24144',' rules engine internal error, arguments: [string], [string]',' An internal error occurred in the rules engine. This indicates that the rules engine has encountered an exception condition.',' Contact Oracle Support Services. The first argument is the error and the second argument is the package.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24145',' evaluation context string.string already exists',' An evaluation context of the given name already exists.',' Specify another name for the evaluation context being created.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24146',' rule string.string already exists',' A rule of the given name already exists.',' Specify another name for the rule being created.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24147',' rule string.string does not exist',' The rule of the given name does not exist.',' Create the rule or specify one that exists.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24148',' cannot drop rule string.string with dependents',' The rule still belongs to some rulesets, cannot be dropped.',' Do not drop a rule that belongs to rulesets without force option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24149',' invalid rule name',' An attempt to create a rule with an invalid name was made.',' The rule name can not be NULL, and can not be more than 30 characters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24150',' evaluation context string.string does not exist',' The evaluation context of the given name does not exist.',' Create the evaluation context or specify one that exists.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24151',' no evaluation context is associated with rule string.string or rule set string.string',' When adding a rule to a rule set, either the rule or the rule set must have an evaluation context associated with it.',' Do not add a rule without an evaluation context to a ruleset that does not have a default evaluation context.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24152',' cannot drop evaluation context string.string with dependents',' The evaluation context still belongs to some rules or rule sets, cannot be dropped.',' Do not drop an evaluation context with dependents without force option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24153',' rule set string.string already exists',' A rule set of the given name already exists.',' Specify another name for the rule set being created.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24154',' rule string.string already in rule set string.string',' A rule can be added to a rule set only once.',' Do not add a rule to a rule set that already contains this rule.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24155',' rule string.string not in rule set string.string',' The rule to be removed from the rule set is not in the rule set.',' Do not remove a rule from a rule set that does not contain the rule.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24156',' duplicate table alias string',' There is a table alias of the same name in the evaluation context.',' Do not add two table aliases of the same name to an evaluation context.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24157',' duplicate variable name string',' There is a variable of the same name in the evaluation context.',' Do not add two variables of the same name to an evaluation context.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24158',' invalid table alias',' Table alias name or base table name is not specified in the table alias definition.',' Specify both alias name and alias base table in the table alias structure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24159',' invalid variable definition',' Variable name or variable type is not specified in the variable definition.',' Specify both variable name and variable type in the variable definition structure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24160',' name string already exists in the name value pair list',' There is already a name-value pair with the same name in the NVlist.',' Try another name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24161',' name string does not exist in the name value pair list',' There is not such a name-value pair in the NVlist.',' Check that the name-value pair exists in the NVList.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24162',' name value pair list is full, cannot add another entry',' The NVList is full (1024 elements) and cannot hold more elements.',' Do not add elements to a full list.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24163',' dblink is not supported in rules engine DDLs',' The object name has a database link in it, which is not supported.',' Do not specify remote objects in rules engine DDLs.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24164',' invalid rule engine system privilege: string',' No such system privilege number for rule engine objects.',' Check specification of dbms_rule_adm for valid system privilege numbers.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24165',' invalid rule engine object privilege: string',' No such object privilege number for rule engine objects.',' Check specification of dbms_rule_adm for valid object privilege numbers.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24166',' evaluation context string.string has errors',' Cannot resolve the table aliases and the variable types specified in the evaluation context.',' Make sure all base tables exist and all variable types are correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24167',' incompatible rule engine objects, cannot downgrade',' There are rule engine objects in the database that cannot be downgraded.',' Check utlincmp.sql and remove all incompatible rules engine objects before downgrading.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24168',' rule string.string cannot have default evaluation context',' If a rule is added to a rule set with more than one evaluation context, then it must not have an evaluation context itself.',' Do not set the evaluation context of such rules to a non-null value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24169',' rule condition has unrecognized variables',' The rule references variables not in the evaluation context.',' Modify the rule condition to remove illegal reference.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24180',' invalid transformation expression, the transformation expression does not evaluate to the target type/attribute',' The transformation expression does not evaluate to the target type or the target type''s specified attribute.',' Provide valid transformation expression which evaluates to the target type or the target type''s specified attribute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24181',' The type string does not exist',' The source or destination type for the transformation does not exist',' Create the type or specify one that exists.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24182',' attribute number specified does not exist',' The target type of the transformation does not have the attribute number specified in the ADD_ATTRIBUTE_TRANSFORMATION command.',' check the target type definition and specify a valid attribute number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24183',' invalid transformation',' The transformation specified is invalid because the source or the target type have been dropped/modified.',' Drop and recreate the transformation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24184',' transformation string.string, already exists',' A transformation of the given name already exists.',' Specify another name for the transformation being created.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24185',' Transformation string.string, does not exist',' The transformation being specified does not exist.',' Create the transformation before using it or specify an existing transformation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24186',' wrong object type, could not transform message',' The object type of the message to be transformed does not match the source type of the specified transfomation.',' Specify another transformation or specify a message of the correct type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24190',' length of payload excceeds string',' The length of payload being taken excceeds the limit of varchar2 or raw.',' Use clob type or blob type to call get_text or get_bytes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24191',' the property name string has existed',' The property name being set has existed.',' Use another property name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24192',' the property name cannot be null',' The property name cannot be null.',' Make sure the property name is not null.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24193',' the property value exceeds the valid range string',' The property values being set exceeds the valid range.',' Make sure the property value is within the valid range.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24201',' duplicate publisher, publisher already added to the queue',' Attempted to add a publisher to the queue again.',' Specify another publisher or use DBMS_AQADM.ALTER_PUBLISHER to alter the publisher''s properties.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24202',' publisher does not exist for the queue',' Attempted to alter or drop a non existent publisher from a queue.',' Specify another publisher.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24270',' a row already exists in the string table for these parameters',' A call was made to create a new row in the specified table. A row already exists in the table with the specified values.',' Delete the existing row using the appropriate API or check the parameters used to create the row.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24271',' translation type must be either T, S or M',' The translation type parameter is not a T, S or an M. A value other than T, S or M was specified.',' Correct the translation type and re-execute the API call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24272',' initialization value must be either F or T',' The initialization value must be either F or T. A value other than F or T was specified.',' Correct the initialization value and re-execute the API call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24273',' translation text is required if translation type is T or S',' If a translation type of T or S is specified, translation text must be supplied.',' Provide translation text and re-execute the API call.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24274',' no row exists in the string table for these parameters',' A call was made to update a row that does not exist or a foreign key value supplied to create a table does not exist.',' Create the row using the appropriate API or check the parameters used to create the new row to ensure that all specified values exist.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24275',' function ''string'' parameter ''string'' missing or invalid',' The function pkgname.funcname was called with a parameter parmname that was null, 0 length, or had an invalid value.',' Correct the parameter to supply values that comply with its datatype and limits as specified in the documentation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24276',' function ''string'' output ''string'' maximum value exceeded',' The function pkgname.funcname computed a value for the output parmname that exceeded the maximum allowed. This can occur when multiple input parameters, each valid separately, combine to specify an invalid result. For example, when a length parameter multiplied by a copies parameter yields a total length exceeding the maximum for the output datatype.',' Correct the input values to produce a result that will comply with the limits as specified in the documentation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02100',' PCC: out of memory (i.e., could not allocate)',' SQLLIB was unable to allocate enough memory to execute the program.',' Allocate more memory to the user session and then rerun the program. If the error persists, contact Oracle Support Services for assistance.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02101',' PCC: inconsistent cursor cache (uce/cuc mismatch)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02102',' PCC: inconsistent cursor cache (no cuc entry for this uce)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02103',' PCC: inconsistent cursor cache (out-of-range cuc ref)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02104',' PCC: inconsistent host cache (no cuc available)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02105',' PCC: inconsistent cursor cache (no cuc entry in cache)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02106',' PCC: inconsistent cursor cache (OraCursor nr is bad)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02107',' PCC: this pgm too old for run-time library: please re-PCC it',' The program was precompiled by an older version of the Oracle Precompilers, which is incompatible with this release of SQLLIB.',' Precompile the program with a newer version of the Oracle Precompilers.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02108',' PCC: invalid descriptor passed to run-time library',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02109',' PCC: inconsistent host cache (out-of-range sit ref)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02110',' PCC: inconsistent host cache (invalid sqi type)',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02111',' PCC: heap consistency error',' This internal error typically indicates a memory-related error.',' Check the program for memory-related errors, such as invalid pointers or array-bounds violations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02112',' PCC: SELECT..INTO returns too many rows',' A SELECT...INTO statement returned more rows than can be stored in the host variable provided.',' There are three possible solutions:');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02140',' invalid tablespace name',' An identifier does not follow ALTER TABLESPACE.',' Specify a tablespace name following ALTER TABLESPACE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02141',' invalid OFFLINE option',' An option other than NORMAL or IMMEDIATE follows OFFLINE.',' The user must either specify no option following OFFLINE or one of the options NORMAL or IMMEDIATE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02142',' missing or invalid ALTER TABLESPACE option',' A valid option is not present.',' Use one of the valid options: add, rename, default, online, offline, read only, read write, begin, end, no, or force.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02143',' invalid STORAGE option',' An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, or PCTINCREASE was specified in the STORAGE clause.',' Specify only valid options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02144',' no option specified for ALTER CLUSTER',' No ALTER CLUSTER options are specified.',' Specify one or more of the following options: PCTFREE, PCTUSED, SIZE, STORAGE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02145',' missing STORAGE option',' No STORAGE options were specified following STORAGE (.',' Specify one or more STORAGE option between the parentheses.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02146',' SHARED specified multiple times',' The SHARED option was specified in a CREATE DATABASE statement multiple times.',' Only specify the SHARED option once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02147',' conflicting SHARED/EXCLUSIVE options',' Both the SHARED and EXCLUSIVE options were specified in a CREATE DATABASE statement.',' Specify SHARED or EXCLUSIVE, but not both.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02148',' EXCLUSIVE specified multiple times',' The EXCLUSIVE option was specified in a CREATE DATABASE statement multiple times.',' Only specify the EXCLUSIVE option once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02149',' Specified partition does not exist',' Partition not found for the object.',' Retry with correct partition name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02153',' invalid VALUES password string',' An encoded password string does not follow the VALUES clause.',' Place a proper encoded password string after the VALUES clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02155',' invalid DEFAULT tablespace identifier',' An identifier does not follow DEFAULT TABLESPACE.',' Place a tablespace name after DEFAULT TABLESPACE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02156',' invalid TEMPORARY tablespace identifier',' An identifier does not follow TEMPORARY TABLESPACE.',' Place a tablespace name after TEMPORARY TABLESPACE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02157',' no options specified for ALTER USER',' No options were specified.',' Specify at least one ALTER USER option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02158',' invalid CREATE INDEX option',' An option other than COMPRESS, NOCOMPRESS, PCTFREE, INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL, NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING, LOCAL, or GLOBAL was specified.',' Choose one of the valid CREATE INDEX options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02159',' installed DLM does not support releasable locking mode',' The parameter file specified GC_* parameters that allow locks to be release by the LCK process when not in use. This mode requires additional support from the DLM that is not available.',' Specify configuration parameters that do not require the additional function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02160',' index-organized table can not contain columns of type LONG',' A column of type LONG defined for index-organized table.',' Do not use columns of type LONG in index-organized tables.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02161',' invalid value for MAXLOGFILES',' A number does not follow MAXLOGFILES.',' Specify a number after MAXLOGFILES.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02162',' invalid value for MAXDATAFILES',' A number does not follow MAXDATAFILES.',' Specify a number after MAXDATAFILES.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02163',' invalid value for FREELIST GROUPS',' A number does not follow FREELIST GROUPS.',' Specify a number after FREELIST GROUPS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02164',' DATAFILE clause specified more than once',' The CREATE DATABASE command contains more than one DATAFILE clause.',' Specify at most one DATAFILE clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02165',' invalid option for CREATE DATABASE',' An invalid CREATE DATABASE option is present.',' Specify only valid CREATE DATABASE options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02166',' ARCHIVELOG and NOARCHIVELOG specified',' Both ARCHIVELOG and NOARCHIVELOG are specified in a CREATE DATABASE statement.',' Specify at most one of these two options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02167',' LOGFILE clause specified more than once',' The CREATE DATABASE command contains more than one LOGFILE clause.',' Specify at most one LOGFILE clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02168',' invalid value for FREELISTS',' A number does not follow FREELISTS.',' Specify a number after FREELISTS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02169',' FREELISTS storage option not allowed',' An attempt was made to specify the FREELISTS storage option. This option may only be specified during create table or create index.',' Remove these options and retry the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02170',' FREELIST GROUPS storage option not allowed',' An attempt was made to specify the FREELIST GROUPS storage option. This option may be specified only when using the CREATE TABLE command and when the ALLOW_FREELIST_GROUPS parameter is specified in the initialization parameter file.',' Retry the statement without the FREELIST GROUPS storage option or set the ALLOW_FREELIST_GROUPS parameter in the initialization parameter file.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02171',' invalid value for MAXLOGHISTORY',' A number does not follow MAXLOGHISTORY.',' Specify a number after MAXLOGHISTORY.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02172',' The PUBLIC keyword is not appropriate for a disable thread',' The PUBLIC keyword was specified for a disable.',' Remove the keyword and resubmit.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02173',' invalid option for DROP TABLESPACE',' Either a token other than INCLUDING was found following the tablespace name or some text was found following INCLUDING CONTENTS.',' Place nothing or only INCLUDING CONTENTS after the tablespace name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02174',' Missing required thread number',' A thread number must be specified after THREAD keyword.',' Use correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02175',' invalid rollback segment name',' In the CREATE or DROP ROLLBACK SEGMENT statements, an identifier was not found following ROLLBACK SEGMENT.',' Place the segment name following ROLLBACK SEGMENT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02176',' invalid option for CREATE ROLLBACK SEGMENT',' An invalid option was specified in a CREATE ROLLBACK SEGMENT statement.',' Specify one of the valid options: TABLESPACE and STORAGE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02177',' Missing required group number',' A group number must be specified after GROUP keyword.',' Check the syntax of the command, specify a group number after GROUP, and retry it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02178',' correct syntax is: SET TRANSACTION READ { ONLY | WRITE }',' There is a syntax error in the user''s statement.',' Correct the syntax as indicated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02179',' valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }',' There is a syntax error in the user''s statement.',' Correct the syntax as indicated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02180',' invalid option for CREATE TABLESPACE',' An invalid option appears.',' Specify one of the valid options: DATAFILE, DEFAULT STORAGE, ONLINE, OFFLINE, or FORCE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02181',' invalid option to ROLLBACK WORK',' A token other than TO follows ROLLBACK [WORK].',' Place nothing or TO SAVEPOINT name after ROLLBACK [WORK].');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02182',' savepoint name expected',' An identifier does not follow ROLLBACK [WORK] TO [SAVEPOINT].',' Place a savepoint name following TO [SAVEPOINT].');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02183',' valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }',' There is a syntax error in the user''s statement.',' Correct the syntax as indicated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02184',' resource quotas are not allowed in REVOKE',' In a revoke statement, a resource quota was specified.',' Specify resource privilege without the quota.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02185',' a token other than WORK follows COMMIT',' A token other than WORK follows COMMIT.',' Place either nothing or WORK after COMMIT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02186',' tablespace resource privilege may not appear with other privileges',' An attempt was made to grant or revoke a resource quota in the same statement in which other privileges are granted or revoked.',' Use a separate grant or revoke statement for the resource quota privilege.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02187',' invalid quota specification',' In a grant or revoke statement, an attempt was made to grant a tablespace quota above the upper limit.',' Grant a smaller tablespace quota.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02189',' ON tablespace required',' In a grant or revoke statement, the user specified a tablespace quota but did not follow it with the ON tablespace clause.',' Specify the tablespace on which the quota is to be applied with the ON tablespace clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02190',' keyword TABLES expected',' The keyword TABLES is expected following DROP CLUSTER name INCLUDING.',' Place TABLES after INCLUDING.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02191',' correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT rbs',' There is a syntax error in the user''s statement.',' Correct the syntax as indicated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02192',' PCTINCREASE not allowed for rollback segment storage clauses',' The storage parameter PCTINCREASE was specified in a CREATE or ALTER ROLLBACK SEGMENT command.',' Retry the command without the PCTINCREASE clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02194',' event specification syntax error string (minor error string) near ''string''',' There is a syntax error in an event specification.',' Check syntax and spelling and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02195',' Attempt to create string object in a string tablespace',' The object type is inconsistent with a tablespace contents.',' Create an object in a different tablespace, or change the user defaults.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02196',' PERMANENT/TEMPORARY option already specified',' In CREATE TABLESPACE, the PERMANENT and/or TEMPORARY options were specified more than once.',' Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02197',' file list already specified',' In CREATE TABLESPACE, more than one DATAFILE/TEMPFILE clause was specified.',' Merge the DATAFILE/TEMPFILE clauses into a single clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02198',' ONLINE/OFFLINE option already specified',' In CREATE TABLESPACE, the ONLINE and/or OFFLINE options were specified more than once.',' Specify at most one of ONLINE or OFFLINE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02199',' missing DATAFILE/TEMPFILE clause',' A CREATE TABLESPACE statement has no DATAFILE/TEMPFILE clause.',' Specify a DATAFILE/TEMPFILE clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02200',' WITH GRANT OPTION not allowed for PUBLIC',' An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.',' Remove the WITH GRANT OPTION clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02201',' sequence not allowed here',' An attempt was made to reference a sequence in a from-list.',' A sequence can only be referenced in a select-list.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02202',' no more tables permitted in this cluster',' An attempt was made to create a table in a cluster which already contains 32 tables.',' Up to 32 tables may be stored per cluster.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02203',' INITIAL storage options not allowed',' An attempt was made to alter the INITIAL storage option of a table, cluster, index, or rollback segment. These options may only be specified when the object is created.',' Remove these options and retry the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02204',' ALTER, INDEX and EXECUTE not allowed for views',' An attempt was made to grant or revoke an invalid privilege on a view.',' Do not attempt to grant or revoke any of ALTER, INDEX, or EXECUTE privileges on views.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02205',' only SELECT and ALTER privileges are valid for sequences',' An attempt was made to grant or revoke an invalid privilege on a sequence.',' Do not attempt to grant or revoke DELETE, INDEX, INSERT, UPDATE, REFERENCES or EXECUTE privilege on sequences.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02206',' duplicate INITRANS option specification',' INITRANS is specified more than once.',' Specify INITRANS at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02207',' invalid INITRANS option value',' The INITRANS value is not an integer between 1 and 255 and less than or equal to the MAXTRANS value.',' Choose a valid INITRANS value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02208',' duplicate MAXTRANS option specification',' MAXTRANS is specified more than once.',' Specify MAXTRANS at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02209',' invalid MAXTRANS option value',' The MAXTRANS value is not an integer between 1 and 255 and greater than or equal to the INITRANS value.',' Choose a valid MAXTRANS value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02210',' no options specified for ALTER TABLE',' No ALTER TABLE option was specified.',' Specify at least one alter table option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02211',' invalid value for PCTFREE or PCTUSED',' The specified value for PCTFREE or PCTUSED is not an integer between 0 and 100.',' Choose an appropriate value for the option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02212',' duplicate PCTFREE option specification',' PCTFREE option specified more than once.',' Specify PCTFREE at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02213',' duplicate PCTUSED option specification',' PCTUSED option specified more than once.',' Specify PCTUSED at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02214',' duplicate BACKUP option specification',' The BACKUP option to ALTER TABLE is specified more than once.',' Specify the option at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02215',' duplicate tablespace name clause',' There is more than one TABLESPACE clause in the CREATE TABLE, CREATE INDEX, or CREATE ROLLBACK SEGMENT statement.',' Specify at most one TABLESPACE clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02216',' tablespace name expected',' A tablespace name is not present where required by the syntax for one of the following statements: CREATE/DROP TABLESPACE, CREATE TABLE, CREATE INDEX, or CREATE ROLLBACK SEGMENT.',' Specify a tablespace name where required by the syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02217',' duplicate storage option specification',' A storage option (INIITAL, NEXT, MINEXTENTS, MAXEXTENTS, PCTINCREASE) is specified more than once.',' Specify all storage options at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02218',' invalid INITIAL storage option value',' The specified value must be an integer.',' Choose an appropriate integer value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02219',' invalid NEXT storage option value',' The specified value must be an integer.',' Choose an appropriate integer value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02220',' invalid MINEXTENTS storage option value',' The specified value must be a positive integer less than or equal to MAXEXTENTS.',' Specify an appropriate value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02221',' invalid MAXEXTENTS storage option value',' The specified value must be a positive integer greater than or equal to MINEXTENTS.',' Specify an appropriate value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02222',' invalid PCTINCREASE storage option value',' The specified value must be a positive integer.',' Specify an appropriate value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02223',' invalid OPTIMAL storage option value',' The specified value must be an integer.',' Choose an appropriate integer value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02224',' EXECUTE privilege not allowed for tables',' An attempt was made to grant or revoke an invalid privilege on a table.',' Do not attempt to grant or revoke EXECUTE privilege on tables.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02225',' only EXECUTE and DEBUG privileges are valid for procedures',' An attempt was made to grant or revoke an invalid privilege on a procedure, function or package.',' Do not attempt to grant or revoke any privilege besides EXECUTE or DEBUG on procedures, functions or packages.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02226',' invalid MAXEXTENTS value (max allowed: string)',' The MAXEXTENTS specified is too large for the database block size. This applies only to SYSTEM rollback segment.',' Specify a smaller value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02227',' invalid cluster name',' A cluster name was not properly formed.',' Check the rules for forming object names and enter an appropriate cluster name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02228',' duplicate SIZE specification',' The SIZE option is specified more than once.',' Specify the SIZE option at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02229',' invalid SIZE option value',' The specified value must be an integer number of bytes.',' Specify an appropriate value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02230',' invalid ALTER CLUSTER option',' An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, or SIZE is specified in an ALTER CLUSTER statement.',' Specify only legal options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02231',' missing or invalid option to ALTER DATABASE',' An option other than ADD, DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is specified in the statement.',' Specify only legal options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02232',' invalid MOUNT mode',' A mode other than SHARED or EXCLUSIVE follows the MOUNT keyword in an ALTER DATABASE statement.',' Specify either SHARED, EXCLUSIVE, or nothing following MOUNT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02233',' invalid CLOSE mode',' A mode other than NORMAL or IMMEDIATE follows the CLOSE keyword in an ALTER DATABASE statement.',' Specify either NORMAL, IMMEDIATE, or nothing following CLOSE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02234',' changes to this table are already logged',' The log table to be added is a duplicate of another.',' Do not add this change log to the system; check that the replication product''s system tables are consistent.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02235',' this table logs changes to another table already',' The table to be altered is already a change log for another table.',' Do not log changes to the specified base table to this table; check that the replication product''s system tables are consistent.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02236',' invalid file name',' A character string literal was not used in the file name list of a LOGFILE, DATAFILE, or RENAME clause.',' Use correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02237',' invalid file size',' A non-integer value was specified in the SIZE or RESIZE clause.',' Use correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02238',' filename lists have different numbers of files',' In a RENAME clause in ALTER DATABASE or TABLESPACE, the number of existing file names does not equal the number of new file names.',' Make sure there is a new file name to correspond to each existing file name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02239',' there are objects which reference this sequence',' The sequence to be dropped is still referenced by other objects.',' Make sure the sequence name is correct or drop the constraint or object that references the sequence.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02240',' invalid value for OBJNO or TABNO',' A number does not follow either OBJNO or TABNO.',' Specify a number after OBJNO or TABNO.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02241',' must of form EXTENTS (FILE n BLOCK n SIZE n, ...)',' There was an error in the extent storage clause.',' Respecify the storage clause using the correct syntax and retry the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02242',' no options specified for ALTER INDEX',' No options specified.',' Specify at least one of REBUILD, INITRANS, MAXTRANS, or STORAGE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02243',' invalid ALTER INDEX or ALTER MATERIALIZED VIEW option',' An option other than INITRANS, MAXTRANS, or STORAGE is specified in an ALTER INDEX statement or in the USING INDEX clause of an ALTER MATERIALIZED VIEW statement.',' Specify only legal options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02244',' invalid ALTER ROLLBACK SEGMENT option',' The STORAGE option is expected but not found.',' Specify the STORAGE option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02245',' invalid ROLLBACK SEGMENT name',' An identifier was expected, but not found, following ALTER [PUBLIC] ROLLBACK SEGMENT.',' Place a rollback segment name following SEGMENT.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02246',' missing EVENTS text',' A character string literal was expected, but not found, following ALTER SESSION SET EVENTS.',' Place the string literal containing the events text after EVENTS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02247',' no option specified for ALTER SESSION',' The option SET EVENTS was expected, but not found, following ALTER SESSION.',' Place the SET EVENTS option after ALTER SESSION.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02248',' invalid option for ALTER SESSION',' An option other than SET EVENTS was found following the ALTER SESSION command.',' Specify the SET EVENTS option after the ALTER SESSION command and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02249',' missing or invalid value for MAXLOGMEMBERS',' A valid number does not follow MAXLOGMEMBERS. The value specified must be between 1 and the port-specific maximum number of log file members.',' Specify a valid number after MAXLOGMEMBERS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02250',' missing or invalid constraint name',' The constraint name is missing or invalid.',' Specify a valid identifier name for the constraint name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02251',' subquery not allowed here',' Subquery is not allowed here in the statement.',' Remove the subquery from the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02252',' check constraint condition not properly ended',' The specified search condition for the check constraint is not properly ended.',' End the condition properly.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02253',' constraint specification not allowed here',' Constraint specification is not allowed here in the statement.',' Remove the constraint specification from the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02254',' DEFAULT expression not allowed here',' Default value expression is not allowed for the column here in the statement.',' Remove the default value expression from the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02255',': NOT NULL not allowed after DEFAULT NULL',' A NOT NULL specification conflicts with the NULL default value.',' Remove either the NOT NULL or the DEFAULT NULL specification and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02256',' number of referencing columns must match referenced columns',' The number of columns in the foreign-key referencing list is not equal to the number of columns in the referenced list.',' Make sure that the referencing columns match the referenced columns.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02257',' maximum number of columns exceeded',' The number of columns in the key list exceeds the maximum number.',' Reduce the number columns in the list.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02258',' duplicate or conflicting NULL and/or NOT NULL specifications',' A duplicate or conflicting NULL and/or NOT NULL was specified.',' Remove one of the conflicting specifications and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02259',' duplicate UNIQUE/PRIMARY KEY specifications',' A duplicate unique or primary key was specified.',' Remove the duplicate specification and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02260',' table can have only one primary key',' Two or more primary keys were specified for the same table.',' Remove the extra primary keys and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02261',' such unique or primary key already exists in the table',' A unique or primary key was specified that already exists for the table.',' Remove the extra key and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02262',' ORA-string occurs while type-checking column default value expressionexpression',' New column datatype causes type-checking error for existing column default value expression.',' Remove the default value expression or do not alter the column datatype.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02263',' need to specify the datatype for this column',' The required datatype for the column is missing.',' Specify the required datatype.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02264',' name already used by an existing constraint',' The specified constraint name has to be unique.',' Specify a unique constraint name for the constraint.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02265',' cannot derive the datatype of the referencing column',' The datatype of the referenced column is not defined as yet.',' Make sure that the datatype of the referenced column is defined before referencing it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02266',' unique/primary keys in table referenced by enabled foreign keys',' An attempt was made to drop or truncate a table with unique or primary keys referenced by foreign keys enabled in another table.',' Before dropping or truncating the table, disable the foreign key constraints in other tables. You can see what constraints are referencing a table by issuing the following command:');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02267',' column type incompatible with referenced column type',' The datatype of the referencing column is incompatible with the datatype of the referenced column.',' Select a compatible datatype for the referencing column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02268',' referenced table does not have a primary key',' The referenced table does not have a primary key.',' Specify explicitly the referenced table unique key.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02269',' key column cannot be of LONG datatype',' An attempt was made to define a key column of datatype LONG. This is not allowed.',' Change the datatype of the column or remove the LONG column from the key, and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02270',' no matching unique or primary key for this column-list',' An attempt was made to reference a unique or primary key in a table with a CREATE or ALTER TABLE statement when no such key exists in the referenced table.',' Add the unique or primary key to the table or find the correct names of the columns with the primary or unique key, and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02271',' table does not have such constraint',' An attempt was made to reference a table using a constraint that does not exist.',' Check the spelling of the constraint name or add the constraint to the table, and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02272',' constrained column cannot be of LONG datatype',' A constrained column cannot be defined as datatype LONG. This is not allowed.',' Change the datatype of the column or remove the constraint on the column, and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02273',' this unique/primary key is referenced by some foreign keys',' A unique or primary key referenced by foreign keys cannot be dropped.',' Remove all references to the key before dropping it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02274',' duplicate referential constraint specifications',' A referential constraint was specified more than once. This is not allowed.',' Remove the duplicate specification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02275',' such a referential constraint already exists in the table',' An attempt was made to specify a referential constraint that already exists. This would result in duplicate specifications and so is not allowed.',' Be sure to specify a constraint only once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02276',' default value type incompatible with column type',' The type of the evaluated default expression is incompatible with the datatype of the column.',' Change the type of the column, or modify the default expression.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02277',' invalid sequence name',' The specified sequence name is not a valid identifier name.',' Specify a valid identifier name for the sequence name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02278',' duplicate or conflicting MAXVALUE/NOMAXVALUE specifications',' Duplicate or conflicting MAXVALUE and/or NOMAXVALUE specifications.',' Remove one of the conflicting specifications and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02279',' duplicate or conflicting MINVALUE/NOMINVALUE specifications',' Duplicate or conflicting MINVALUE and/or NOMINVALUE clauses were specified.',' Remove one of the conflicting specifications and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02280',' duplicate or conflicting CYCLE/NOCYCLE specifications',' Duplicate or conflicting CYCLE and/or NOCYCLE clauses were specified.',' Remove one of the conflicting specifications and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02281',' duplicate or conflicting CACHE/NOCACHE specifications',' Duplicate or conflicting CACHE and/or NOCACHE clauses were specified.',' Remove one of the conflicting specifications and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02282',' duplicate or conflicting ORDER/NOORDER specifications',' Duplicate or conflicting ORDER and/or NOORDER clauses were specified.',' Remove one of the conflicting specifications and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02283',' cannot alter starting sequence number',' An attempt was made to alter a starting sequence number. This is not allowed.',' Do not try to alter a starting sequence number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02284',' duplicate INCREMENT BY specifications',' A duplicate INCREMENT BY clause was specified.',' Remove the duplicate specification and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02285',' duplicate START WITH specifications',' A duplicate START WITH clause was specified.',' Remove the duplicate specification and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02286',' no options specified for ALTER SEQUENCE',' No ALTER SEQUENCE option was specified.',' Check the syntax. Then specify at least one ALTER SEQUENCE option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02287',' sequence number not allowed here',' The specified sequence number reference, CURRVAL or NEXTVAL, is inappropriate at this point in the statement.',' Check the syntax. Then remove or relocate the sequence number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02288',' invalid OPEN mode',' A mode other than RESETLOGS was specified in an ALTER DATABASE OPEN statement. RESETLOGS is the only valid OPEN mode.',' Remove the invalid mode from the statement or replace it with the keyword RESETLOGS, and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02289',' sequence does not exist',' The specified sequence does not exist, or the user does not have the required privilege to perform this operation.',' Make sure the sequence name is correct, and that you have the right to perform the desired operation on this sequence.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02290',' check constraint (string.string) violated',' The value or values attempted to be entered in a field or fields violate a defined check constraint.',' Enter values that satisfy the constraint.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02291',' integrity constraint (string.string) violated - parent key not found',' A foreign key value has no matching primary key value.',' Delete the foreign key or add a matching primary key.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02292',' integrity constraint (string.string) violated - child record found',' An attempt was made to delete a row that is referenced by a foreign key.',' It is necessary to DELETE or UPDATE the foreign key before changing this row.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02293',' cannot validate (string.string) - check constraint violated',' An attempt was made via an ALTERTABLE statement to add a check constraint to a populated table that had no complying values.',' Retry the ALTER TABLE statement, specifying a check constraint on a table containing complying values. For more information about ALTER TABLE, see the Oracle9i SQL Reference.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02294',' cannot enable (string.string) - constraint changed during validation',' While one DDL statement was attempting to enable this constraint, another DDL changed this same constraint.',' Try again, with only one DDL changing the constraint this time.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02295',' found more than one enable/disable clause for constraint',' An attempt was made via a CREATE or ALTER TABLE statement to specify more than one ENABLE and/or DISABLE clause for a given constraint.',' Only one ENABLE or DISABLE clause may be specified for a given constraint.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02296',' cannot enable (string.string) - null values found',' An ALTER TABLE command with an ENABLE CONSTRAINT clause failed because the table contains values that do not satisfy the constraint.',' Make sure that all values in the table satisfy the constraint before issuing an ALTER TABLE command with an ENABLE CONSTRAINT clause. For more information about ALTER TABLE and ENABLE CONSTRAINT, see the Oracle9i SQL Reference.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02297',' cannot disable constraint (string.string) - dependencies exist',' An alter table disable constraint failed because the table has foreign keys that are dependent on the constraint.',' Either disable the foreign key constraints or use a DISABLE CASCADE command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02298',' cannot validate (string.string) - parent keys not found',' An ALTER TABLE ENABLE CONSTRAINT command failed because the table has orphaned child records.',' Make sure that the table has no orphaned child records before issuing an ALTER TABLE ENABLE CONSTRAINT command. For more information about ALTER TABLE and ENABLE CONSTRAINT, see the Oracle9i SQL Reference.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02299',' cannot validate (string.string) - duplicate keys found',' An ALTER TABLE ENABLE CONSTRAINT command failed because the table has duplicate key values.',' Make sure that the table has no duplicate key values before issuing an ALTER TABLE ENABLE CONSTRAINT command. For more information about ALTER TABLE and ENABLE CONSTRAINT, see the Oracle9i SQL Reference.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02300',' invalid value for OIDGENERATORS',' A number was not specified for the value of OIDGENERATORS.',' Specify a number for OIDGENERATORS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02301',' maximum number of OIDGENERATORS is 255',' A number greater than 255 was specified for the value of OIDGENERATORS.',' Make sure the number specified for OIDGENERATORS does not exceed 255.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02302',' invalid or missing type name',' An invalid or missing type name was entered in a statement.',' Enter a valid type name in the statement and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02303',' cannot drop or replace a type with type or table dependents',' An attempt was made to drop or replace a type that has dependents. There could be a substitutable column of a supertype of the type being dropped.',' Drop all types and tables depending on the type, then retry the operation using the VALIDATE option, or use the FORCE option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02304',' invalid object identifier literal',' An attempt was made to enter an object identifier literal for CREATE TYPE that is either:',' Do not specify the object identifier clause or specify a 32 hexadecimal-character object identifier literal that is unique or identical to the originally assigned object identifier. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02305',' only EXECUTE, DEBUG, and UNDER privileges are valid for types',' An attempt was made to GRANT or REVOKE an invalid privilege (not EXECUTE, DEBUG, or UNDER) on a type.',' GRANT or REVOKE only the EXECUTE, DEBUG, or UNDER privilege on types.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02306',' cannot create a type that already has valid dependent(s)',' An attempt was made to create a type that already has some valid dependent(s) (these dependents depend on the fact that the type does not exist).',' Drop the dependents first before creating the type, or do not create the type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02307',' cannot alter with REPLACE option a type that is not valid',' An attempt was made to ALTER with REPLACE option a type that is not valid.',' Use the CREATE OR REPLACE TYPE command to modify the type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02308',' invalid option string for object type column',' An attempt was made to specify an invalid option, such as PACKED or UNPACKED, for the object type column.',' Remove the invalid option from column specification and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02309',' atomic NULL violation',' An attempt was made to access the attributes of a NULL object instance.',' Ensure that the object instance is non-NULL before accessing.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02310',' exceeded maximum number of allowable columns in table',' The attributes in the object type column exceeded the maximum number of columns allowed in a table.',' Specify fewer attributes for the object type and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02311',' cannot alter with COMPILE option a valid type with type or table dependents',' An attempt was made to ALTER with COMPILE option a type that is valid and has type or table dependents.',' No need to perform this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02313',' object type contains non-queryable type string attribute',' The specified object type contains a nested attribute whose type is non-queryable.',' Use an object type with queryable attribute types.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02315',' incorrect number of arguments for default constructor',' The number of arguments specified for the default constructor does not match the number of attributes of the object type.',' Specify the correct number of arguments for the default constructor and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02320',' failure in creating storage table for nested table column string',' An error occurred while creating the storage table for the specified nested table column.',' See the messages that follow for more details. If the situation they describe can be corrected, do so; otherwise contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02322',' failure in accessing storage table of the nested table column',' An error occurred while performing DML on the storage table of the nested table column.',' If the situation described in the following messages can be corrected, do so; otherwise contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02324',' more than one column in the SELECT list of THE subquery',' More than one column was selected in the THE subquery.',' Specify only one column in the SELECT list of the THE subquery and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02327',' cannot create index on expression with datatype string',' An attempt was made to create an index on a non-indexable expression.',' Change the column datatype or do not create the index on an expression whose datatype is one of VARRAY, nested table, object, LOB, or REF.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02329',' column of datatype string cannot be unique or a primary key',' An attempt was made to place a UNIQUE or a PRIMARY KEY constraint on a column of datatype VARRAY, nested table, object, LOB, FILE or REF.',' Change the column datatype or remove the constraint. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02330',' datatype specification not allowed',' An attempt was made to specify the data type in the column constraint specification of an object table.',' Remove data type specification and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02331',' cannot create constraint on column of datatype string',' An attempt was made to create a constraint on a column possessing a non-constrainable datatype: VARRAY, nested table, object, LOB, FILE, or REF.',' Change the column datatype, or remove the constraint.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02332',' cannot create index on attributes of this column',' An attempt was made to create an index on an attributes of an object type column.',' Do not specify the index on the attribute.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02333',' cannot create constraints on attributes of this column',' An attempt was made to create a constraint on an attribute of an object type column.',' Remove the constraint or change the object type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02334',' cannot infer type for column',' A datatype was not declared for this column (in the CREATE TABLE) and an attempt was made to create a constraint on an attribute of this column.',' Declare a datatype for the column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02335',' invalid datatype for cluster column',' An attempt was made to declare a CLUSTER column of datatype object, REF, nested table, VARRAY, LOB, or FILE.',' Remove the CLUSTER column or change the datatype of the column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02336',' column attribute cannot be accessed',' An attempt was made to extract an attribute of an object type column.',' Change the object type for the column and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02337',' not an object type column',' An attempt was made to use dotted notation on a non-ADT column; that is, "a.b.c" where "a" is not an object type.',' Either change the column type to an object type or do not perform this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02338',' missing or invalid column constraint specification',' A column constraint was not specified.',' Remove the column specification or specify a column constraint. Then retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02339',' invalid column specification',' An attempt was made to specify the PACKED or UNPACKED keyword for a non-object type column.',' Remove the PACKED or UNPACKED keyword in the column specification and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02340',' invalid column specification',' An attempt was made to specify an UNPACKED column within a packed table.',' Remove the UNPACKED keyword in the column specification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02342',' replacement type has compilation errors',' The use of the ALTER...REPLACE statement on a valid type caused a compilation error.',' Use the ALTER...REPLACE statement to replace the type with a valid type which does not cause compilation errors.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02344',' cannot revoke execute on a type with table dependents',' An attempt was made to revoke execute on a type that has dependents.',' Drop all table(s) depending on the type, then retry the operation, or use the FORCE option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02345',' cannot create a view with column based on CURSOR operator',' A CURSOR operator was used as one of the SELECT elements in the subquery of a CREATE VIEW or CREATE TABLE ... AS SELECT statement.',' Remove the CURSOR operator and replace it with the CAST operator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02347',' cannot grant privileges on columns of an object table',' An attempt was made to grant privileges on the columns of an object table.',' Choose another table. Privileges cannot be granted on columns of an object table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02348',' cannot create VARRAY column with embedded LOB',' An attempt was made to create a column of a VARRAY type which has an embedded LOB attribute. The LOB could be an attribute of a subtype of the declared type of VARRAY''s element.',' Remove the offending attribute from the type. If it is a subtype attribute then declare the VARRAY column NOT SUBSTITUTABLE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02349',' invalid user-defined type - type is incomplete',' An attempt was made to use an incomplete type definition as a column or table datatype.',' Complete the type definition and retry the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02351',' Record string: Rejected - Error on table string, column string',' The record indicated caused an Oracle error on insert.',' Determine the Oracle error and correct the record.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02352',' Direct path connection must be homogeneous',' The user-side to kernel-side connection is heterogeneous.',' In versions prior to 9.0.0, the connection must be between identical hardware and operating systems. In addition, the SQL*Loader and RDBMS versions must be the same.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02353',' Multibyte character error',' Text specified by POSITION or terminated by newlines is invalid.',' Edit the control file or the datafile to fix alignment of column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02354',' Conversion initialization error occurred on field string',' An error occurred during conversion initialization for a field. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02355',' Conversion error occurred on CONSTANT field string',' A CONSTANT field caused an Oracle error; all rows will be rejected.',' Determine the Oracle error and correct the record.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02356',' The database is out of space. The load cannot continue',' The load was discontinued due to space exhaustion in the database.',' Add space for the specified table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02357',' Packed Decimal conversion error',' The column could not be converted from packed decimal to character.',' Check the column and make it conform to packed decimal format.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02358',' Zoned Decimal conversion error',' The column could not be converted from packed decimal to character.',' Check the column and make it conform to packed decimal format.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02359',' Field in data file exceeded maximum specified length',' The field is too long for the specified column.',' Shorten the field so that its length is less than or equal to the column length.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02360',' Column not found before end of logical record (use TRAILING NULLCOLS)',' A column started after the end of the logical record had been reached.',' Use the TRAILING NULLCOLS option or supply data for the column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02361',' Initial enclosing character not found',' The initial enclosing character of an enclosed field was not found.',' Supply the character before the start of the field.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02362',' Logical record ended - second enclosing character not present',' The second enclosing character of an enclosed field was not found.',' Supply the character after the end of the field.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02363',' No terminator found after TERMINATED and ENCLOSED field',' No terminator was found after a terminated and enclosed field.',' Supply the character after the end of the field.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02364',' Record string: Discarded - failed all WHEN clauses',' The record was not loaded because it failed the WHEN clauses of all the tables.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02365',' Index string was made Index Unusable due to',' The index was not loaded. The cause of the error is stated after the message.',' Correct the cause of the error, then reload.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02366',' The following index(es) on table string were processed:',' The indexes listed for the named table were loaded.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02367',' Index string was loaded.',' The index specified in the message was loaded.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02368',' Record string: Discarded - all columns null.',' The record was not loaded because all of the columns in the table were null for that record.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02369',' Warning: Variable length field was truncated.',' A variable length field was truncated by the end of the logical record.',' This is just a warning, but since a variable length field has the length embedded in the data for each row, you may want to check your data.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02370',' Record string - Warning on table string, column string',' The record indicated caused an warning.',' Determine the warning and correct the record if necessary.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02371',' Loader must be at least version string.string.string.string.string for direct path',' The loader being used is incompatible with this version of the kernel.',' Upgrade your loader to at least the specified version or use the conventional path.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02372',' Relative start position &gt; absolute field end position.',' A field specified as POSITION(*+n:y) had its relative start occur after the absolute position y.',' Check that you are not missing a delimiter and that the values of n and y are correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02373',' Error parsing insert statement for table string.',' A parsing error occurred.',' Check the message following this parsing error message.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02374',' No more slots for read buffer queue.',' There are no free read buffers.',' Use the READBUFFERS keyword in the loader to increase the number of read buffers.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02375',' Record string: Rejected - Error on table string',' The record indicated caused an Oracle error on insert.',' Determine the Oracle error and correct the record. The offending column(s) are not known.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02376',' invalid or redundant resource',' A resource that is not defined or that is specified twice appears in the CREATE or ALTER PROFILE statement.',' Define the resource before issuing a CREATE or ALTER PROFILE command. Also check the statement to see that each resource is listed only once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02377',' invalid resource limit',' An invalid resource limit of 0 was specified.',' Specify a resource limit greater than 0.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02378',' duplicate resource name string',' The same resource was specified twice in a CREATE or ALTER PROFILE statement.',' Issue the statement again, carefully checking that each resource is used only once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02379',' profile string already exists',' An attempt was made to create a profile that already exists.',' Create the profile with a name not already used by another profile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02380',' profile string does not exist',' An attempt was made to assign a user to a non-existent profile.',' Assign the user to an existing profile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02381',' cannot drop PUBLIC_DEFAULT profile',' An attempt was made to drop the PUBLIC_DEFAULT profile.',' The PUBLIC_DEFAULT profile cannot be dropped.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02382',' profile string has users assigned, cannot drop without CASCADE',' An attempt was made to drop a profile that had users assigned to it without using the CASCADE option of the DROP PROFILE statement. A profile that has users assigned to it cannot be dropped, unless the CASCADE option is specified. CASCADE reassigns users to the PUBLIC_DEFAULT profile before dropping the profile.',' To reassign all users to the PUBLIC_DEFAULT profile, issue the DROP PROFILE statement with the CASCADE option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02383',' illegal cost factor',' A negative value or UNLIMITED cost was specified for this resource in the ALTER RESOURCE COST statement.',' Only positive integer values can be specified for resources in the ALTER RESOURCE COST statement. Issue the statement again, using a positive integer value for each resource specified.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02390',' exceeded COMPOSITE_LIMIT, you are being logged off',' The COMPOSITE_LIMIT for the profile is exceeded. That is, the weighted sum of the connection time, logical reads per session, CPU usage per session, and private SGA space used during the session exceeded the limit set by the COMPOSITE_LIMIT clause set in the user profile.',' If this happens often, ask the database administrator to raise the COMPOSITE_LIMIT of the user profile, or determine which resource is used the most and raise the limit on that resource.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02391',' exceeded simultaneous SESSIONS_PER_USER limit',' An attempt was made to exceed the maximum number of concurrent sessions allowed by the SESSIONS_PER_USER clause of the user profile.',' End one or more concurrent sessions or ask the database administrator to increase the SESSIONS_PER_USER limit of the user profile. For more information about SESSIONS_PER_USER and the database administrator''s specific tasks of adjusting concurrent sessions, see the Oracle9i SQL Reference and the Oracle9i Database Administrator''s Guide.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02392',' exceeded session limit on CPU usage, you are being logged off',' An attempt was made to exceed the maximum CPU usage allowed by the CPU_PER_SESSION clause of the user profile.',' If this happens often, ask the database administrator to increase the CPU_PER_SESSION limit of the user profile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02393',' exceeded call limit on CPU usage',' An attempt was made to exceed the maximum CPU time for a call, a parse, execute, or fetch, allowed by the CPU_PER_CALL clause of the user profile.',' If this happens often, ask the database administrator to increase the CPU_PER_CALL limit of the user profile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02394',' exceeded session limit on IO usage, you are being logged off',' An attempt was made to exceed the maximum I/O allowed by the LOGICAL_READS_PER_SESSION clause of the user profile.',' If this happens often, ask the database administrator to increase the LOGICAL_READS_PER_SESSION limit of the user profile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02395',' exceeded call limit on IO usage',' An attempt was made to exceed the maximum I/O for a call, a parse, execute, or fetch, allowed by the LOGICAL_READS_PER_CALL clause of the user profile.',' If this happens often, ask the database administrator to increase the LOGICAL_READS_PER_CALL limit of the user profile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02396',' exceeded maximum idle time, please connect again',' A user has exceeded the maximum time allowed to remain idle.',' The user must reconnect to the database.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02397',' exceeded PRIVATE_SGA limit, you are being logged off',' This error occurs only when using a multi-threaded server.',' Contact the database administrator to expand the PRIVATE_SGA limit.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02398',' exceeded procedure space usage',' Stored procedures used up too much space in the SYSTEM tablespace.',' Use fewer stored procedures or add an additional file to the system tablespace.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02399',' exceeded maximum connect time, you are being logged off',' A user has exceeded the maximum time allowed to be connected to the database.',' The user must reconnect to the database.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02401',' cannot EXPLAIN view owned by another user',' The view specified in the SQL statement belongs to another user and cannot be explained.',' Create a view with the same definition that belongs to current user.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02402',' PLAN_TABLE not found',' The table used by EXPLAIN to store row source information does not exist in the current schema.',' Create a plan table in the current schema or use the INTO clause of the statement to put the results of the explain command in an existing plan table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02403',' plan table does not have correct format',' The explicit plan table does not have the appropriate field definitions.',' Redefine the plan table to have the appropriate field definitions.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02404',' specified plan table not found',' The specified plan table does cannot be found.',' Create the specified plan table or use an existing plan table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02420',' missing schema authorization clause',' The AUTHORIZATION clause is missing from a create schema statement.',' Proceed the schema authorization identifier with the AUTHORIZATION keyword.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02421',' missing or invalid schema authorization identifier',' One of the following:',' If the cause is');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02422',' missing or invalid schema element',' A statement other than a CREATE TABLE, CREATE VIEW, or GRANT appears in a CREATE SCHEMA statement.',' See the Oracle9i SQL Reference or the valid elements of the CREATE SCHEMA statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02423',' schema name does not match schema authorization identifier',' A table definition with a schema name prepended to the table name does not match the schema name provided in the AUTHORIZATION clause of a CREATE SCHEMA STATEMENT.',' Check that the schema names match the one given in the CREATE SCHEMA statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02424',' potential circular view references or unknown referenced tables',' The CREATE SCHEMA statement contains a view that depends on other views contained in the CREATE SCHEMA statement, or they contain references to non-existing tables.',' Create the dependent views in a separate CREATE SCHEMA statement and ensure that all referenced tables are either defined in the CREATE SCHEMA statement or exist outside the statement.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02425',' create table failed',' A CREATE TABLE statement failed in the CREATE SCHEMA statement.',' The cause for failure will be presented below this message. Follow the appropriate actions as suggested by the subsequent messages.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02426',' privilege grant failed',' A GRANT statement failed in the CREATE SCHEMA statement.',' The cause for failure will be presented below this message. Follow appropriate actions, as suggested by the subsequent messages.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02427',' create view failed',' A CREATE VIEW statement failed in the CREATE SCHEMA statement.',' The cause for failure will be presented below this message. Follow appropriate actions, as suggested by the subsequent messages.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02428',' could not add foreign key reference',' Oracle could not add a foreign key reference because of an error in the declaration. Either the referenced table does not exist or the table does not have a unique key.',' Check that the referenced table exists and/or has a unique key.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02429',' cannot drop index used for enforcement of unique/primary key',' An attempt was made to drop an index that is being used as the enforcement mechanism for a unique or primary key.',' Drop the integrity constraint instead of dropping the index.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02430',' cannot enable constraint (string) - no such constraint',' The named constraint does not exist for this table.',' Check that a constraint exists before trying to enable it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02431',' cannot disable constraint (string) - no such constraint',' The named constraint does not exist for this table.',' Check that a constraint exists before trying to disable it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02432',' cannot enable primary key - primary key not defined for table',' An attempt was made to enable a primary key that is not defined for the table.',' Add a primary key definition for the table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02433',' cannot disable primary key - primary key not defined for table',' An attempt was made to disable a primary key that is not defined for the table.',' Check that a primary key exists before trying to disable it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02434',' cannot enable unique(string) - unique key not defined for table',' An attempt was made to enable a unique key that is not defined for the table.',' Check that a unique key exists before trying to enable it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02435',' cannot disable unique(string) - unique key not defined for table',' An attempt was made to disable a unique key that is not defined for the table.',' Check that a unique key exists before trying to disable it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02436',' date or system variable wrongly specified in CHECK constraint',' An attempt was made to use a date constant or system variable, such as USER, in a check constraint that was not completely specified in a CREATE TABLE or ALTER TABLE statement. For example, a date was specified without the century.',' Completely specify the date constant or system variable.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02437',' cannot validate (string.string) - primary key violated',' An attempt was made to validate a primary key with duplicate values or null values.',' Remove the duplicates and null values before enabling a primary key.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02438',' Column check constraint cannot reference other columns',' An attempt was made to define a column check constraint that references another column.',' Define it as a table check constraint.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02439',' Unique index on a deferrable constraint is not allowed',' An attempt was made to enable a deferrable primary key/unique constraint that has an existing unique index on the constraint columns.',' Drop the index on the constraint columns or make the constraint not deferrable.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02440',' Create as select with referential constraints not allowed',' Integrity constraints on a table cannot be created when creating the table using the CREATE TABLE... AS SELECT... form.',' First, create the table, and then alter the table to add the desired integrity constraints.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02441',' Cannot drop nonexistent primary key',' An attempt was made to drop the primary key constraint on a table, but there is no primary key constraint on this table.',' Ensure the correct table name is entered in the statement. Otherwise, no action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02442',' Cannot drop nonexistent unique key',' An attempt was made to drop a unique key constraint for a column that does not have a unique key constraint.',' Make certain the correct column name was entered. Otherwise, no action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02443',' Cannot drop constraint - nonexistent constraint',' An attempt was made to drop a constraint that does not exist.',' Make certain the constraint and table name are correct and attempt the procedure again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02444',' Cannot resolve referenced object in referential constraints',' An attempt was made to define a foreign key with a reference to a schema object that cannot be resolved to a base table reference.',' Define referential constraints only with schema objects resolving to a base table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02445',' Exceptions table not found',' The explicitly or implicitly declared exceptions table does not exist.',' If the correct exceptions table name was used, then create the table and retry the enable command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02446',' CREATE TABLE ... AS SELECT failed - check constraint violated',' An attempt was made to use a CREATE TABLE ... AS SELECT statement when some rows violated one or more CHECK constraints.',' Do not select rows that violate constraints.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02447',' cannot defer a constraint that is not deferrable',' An attempt was made to defer a nondeferrable constraint.',' Drop the constraint and create a new one that is deferrable.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02448',' constraint does not exist',' The named constraint does not exist.',' Choose a constraint that does exist or do not perform this operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02449',' unique/primary keys in table referenced by foreign keys',' An attempt was made to drop a table with unique or primary keys referenced by foreign keys in another table.',' Before performing the above operations the table, drop the foreign key constraints in other tables. You can see what constraints are referencing a table by issuing the following command:');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02450',' Invalid hash option - missing keyword IS',' Missing IS keyword.',' Specify HASH IS option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02451',' duplicate HASHKEYS specification',' The HASHKEYS option is specified more than once.',' Only specify the HASHKEYS option once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02452',' invalid HASHKEYS option value',' The specified HASHKEYS option must be an integer value.',' Specify an appropriate value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02453',' duplicate HASH IS specification',' The HASH IS option is specified more than once.',' only specify the HASH IS option once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02454',' Number of hash keys per block (string) exceeds maximum of string',' The SIZE argument is too small.',' Increase the SIZE argument.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02455',' The number of cluster key column must be 1',' When specifying the HASH IS option, the number of key columns must be 1.',' Either do not specify the HASH IS option or reduce the number of key columns.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02456',' The HASH IS column specification must be NUMBER(*,0)',' The column specification must specify an integer.',' Specify the column definition as type NUMBER(precision, 0).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02457',' The HASH IS option must specify a valid column',' The HASH IS column name is not specified in the cluster definition.',' Specify a valid column name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02458',' HASHKEYS must be specified for a HASH CLUSTER',' The HASHKEYS option must be specified when creating a HASH CLUSTER.',' Specify the HASHKEYS option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02459',' Hashkey value must be a positive integer',' The value of the hash key was not a positive number.',' Specify a positive integer.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02460',' Inappropriate index operation on a hash cluster',' An attempt to create a cluster index was issued on a hash cluster.',' Do not attempt to create such an index.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02461',' Inappropriate use of the INDEX option',' This option is only valid for non hash clusters.',' Do not specify this option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02462',' Duplicate INDEX option specified',' The INDEX option is specified more than once.',' Only specify the INDEX option once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02463',' Duplicate HASH IS option specified',' The HASH IS option is specified more than once.',' Only specify the HASH IS option once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02464',' Cluster definition can not be both HASH and INDEX',' The cluster can either be a hash or indexed cluster, not both.',' Remove either the HASH IS or INDEX options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02465',' Inappropriate use of the HASH IS option',' This option is only valid for clusters.',' Do not specify this option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02466',' The SIZE option is not allow to be altered for HASH CLUSTERS',' The SIZE cannot be changed once the hash cluster has been created.',' Do not specify this option.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02467',' Column referenced in expression not found in cluster definition',' A column in the hash is expression was not present in cluster definition.',' Re-create the cluster and correct the error in hash expression.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02468',' Constant or system variable wrongly specified in expression',' A constant or system variable was specified in the hash expression.',' Re-create the cluster and correct the error in hash expression.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02469',' Hash expression does not return an Oracle Number.',' Result of evaluating hash expression is not an Oracle Number.',' Re-create the cluster and correct the error in hash expression.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02470',' TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.',' TO_DATE, USERENV and SYSDATE are not allowed in hash expressions.',' Re-create the cluster and correct the error in hash expression.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02471',' SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.',' SYSDATE, UID, USER, ROWNUM, or LEVEL are not allowed in hash expressions.',' Re-create the cluster and remove the offending keywords.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02472',' PL/SQL functions not allowed in hash expressions',' A PL/SQL function was used in the hash expression.',' Re-create the cluster and remove the PL/SQL function.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02473',' Error while evaluating the cluster''s hash expression.',' An error occurred while evaluating the clusters hash expression.',' Correct the query and retry.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02474',' Fixed hash area extents used (string) exceeds maximum allowed (string)',' The number of extents required for creating the fixed hash area exceeds the maximum number allowed.',' Reduce the number of extents required by increasing the extent allocation sizes within the STORAGE clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02475',' maximum cluster chain block count of string has been exceeded',' The number of blocks in a cluster chain exceeds the maximum number allowed.',' Increase SIZE parameter in CREATE CLUSTER statement or reconsider suitability of cluster key.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02476',' can not create index due to parallel direct load on table',' A parallel direct load is occurring to the specified table.',' Retry statement after load is complete.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02477',' can not perform parallel direct load on object string',' A parallel direct load is not possible because an index is being created on the table.',' Retry load after index creation is complete.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02478',' merge into base segment would overflow MAXEXTENTS limit',' Merge of temporary segment into base segment failed because MAXEXTENTS was larger than the total in the temporary and base segments.',' Use a larger value for MAXEXTENTS on the base segment or make the extents in the temporary segments larger.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02479',' error while translating file name for parallel load',' An invalid file name was specified to load data into.',' Specify a valid database file.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02481',' Too many processes specified for events (max string)',' Too many processes specified than allowed per event.',' Enter fewer processes by using ranges or wildcards if possible.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02482',' Syntax error in event specification (string)',' Illegal event string.',' Enter a legal event string.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02483',' Syntax error in process specification (string)',' Illegal process string.',' Enter a legal process string.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02486',' Error in writing trace file string',' Error occurred in creating/writing the file.',' Check the file name and make sure it is constructed properly. Also, check permissions for directories.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02490',' missing required file size in RESIZE clause',' No value was specified for the RESIZE clause.',' Use the correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02491',' missing required keyword ON or OFF in AUTOEXTEND clause',' The keyword ON or OFF was not specified for the AUTOEXTEND clause.',' Use the correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02492',' missing required file block increment size in NEXT clause',' No value was specified for the NEXT clause.',' Use the correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02493',' invalid file increment size in NEXT clause',' A non-integer value was used for the NEXT clause of the DATAFILE list.',' Use the correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02494',' invalid or missing maximum file size in MAXSIZE clause',' UNLIMITED was not specified, or an invalid integer value was specified, for the MAXSIZE clause in the DATAFILE file list. The MAXSIZE value cannot be smaller than the SIZE value.',' Use the correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02495',' cannot resize file string, tablespace string is read only',' An attempt was made to resize a datafile in a tablespace that is read only.',' Change the tablespace to read/write and retry the resize operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02700',' osnoraenv: error translating ORACLE_SID',' Two-task driver could not find the value of ORACLE_SID in the environment.',' Make sure that the ORACLE_SID environment variable has been properly set and exported.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02701',' osnoraenv: error translating oracle image name',' ORACLE_HOME environment variable not set.',' Make sure that the ORACLE_HOME environment variable has been properly set and exported.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02702',' osnoraenv: error translating orapop image name',' ORACLE_HOME environment variable not set.',' Make sure that the ORACLE_HOME environment variable has been properly set and exported.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02703',' osnpopipe: pipe creation failed',' The pipe driver failed to create pipes for communications with the ORAPOP process.',' You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02704',' osndopop: fork failed',' The two-task driver could not fork ORAPOP.',' Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02705',' osnpol: polling of communication channel failed',' The pipe driver failed while polling the communications channel.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02706',' osnshs: host name too long',' The length of your host-string specified by the TWO_TASK environment variable exceeds the Oracle system-imposed limit.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02707',' osnacx: cannot allocate context area',' The invoked UNIX two-task driver could not allocate heap space for the context area.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02708',' osnrntab: connect to host failed, unknown ORACLE_SID',' The invoked UNIX two-task driver failed to find an entry in ORATAB for the SID you supplied.',' First, check whether you have read access to ORATAB, and see if the desired sid is there. Add an entry to ORATAB for the desired SID, if necessary.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02709',' osnpop: pipe creation failed',' The pipe driver failed to create pipes for two-task communications with the Oracle shadow process.',' You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02710',' osnpop: fork failed',' The pipe driver could not fork the Oracle shadow process.',' Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02711',' osnpvalid: write to validation channel failed',' The pipe driver failed to write to the ORAPOP process.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02712',' osnpop: malloc failed',' The pipe driver failed to allocate enough heap space for its context area buffers.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02713',' osnprd: message receive failure',' The pipe driver failed to read a message from the communications channel.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02714',' osnpwr: message send failure',' The pipe driver failed to write a message to the communications channel.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02715',' osnpgetbrkmsg: message from host had incorrect message type',' The pipe driver received a message having an unrecognizable message type.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02716',' osnpgetdatmsg: message from host had incorrect message type',' The Pipe driver received a message having an unrecognizable message type.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02717',' osnpfs: incorrect number of bytes written',' The Pipe driver sent a message that was apparently successful, but the number of bytes transmitted did not match the number of bytes furnished to the driver.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02718',' osnprs: reset protocol error',' The two-task driver could not reset the connection.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02719',' osnfop: fork failed',' The fast driver could not fork the Oracle shadow process.',' Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02720',' osnfop: shmat failed',' When the fast driver was invoked, processes failed to attach to the shared memory buffer. You probably supplied an illegal shared memory attach address, or the system ran out of data space to accommodate the buffer.',' Try invoking the Fast driver later, or use the default attach address.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02721',' osnseminit: cannot create semaphore set',' The Fast driver failed to get a semaphore set.',' The system-imposed limit on semaphores or semaphore identifiers may have been exceeded. Read the returned operating system error code and check with your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02722',' osnpui: cannot send break message to orapop',' The Pipe driver could not send a break message to ORAPOP.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02723',' osnpui: cannot send break signal',' The Pipe driver could not send a break message to the Oracle shadow process.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02724',' osnpbr: cannot send break message to orapop',' The Pipe driver could not send a break message to ORAPOP.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02725',' osnpbr: cannot send break signal',' The Pipe driver could not send a break message to the Oracle shadow process.',' Kill system call failed. Check the error code (errno) and contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02726',' osnpop: access error on oracle executable',' The Pipe driver could not access the Oracle executable.',' Check the permissions on the Oracle executable and each component of the ORACLE_HOME/bin path.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02727',' osnpop: access error on orapop executable',' The Pipe driver could not access the ORAPOP executable.',' Check the permissions on the ORAPOP executable and each component of the ORACLE_HOME/bin path.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02728',' osnfop: access error on oracle executable',' The Fast driver could not access the Oracle executable.',' Check the permissions on the Oracle executable and each component of the ORACLE_HOME/bin path.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02729',' osncon: driver not in osntab',' The driver you have specified is not supported.',' Check with your database administrator which drivers are supported.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02730',' osnrnf: cannot find user logon directory',' The driver you have specified could not find your logon directory while searching for your local .SQLNET file.',' Set and export the HOME environment variable to identify your home directory. Check with your system administrator to make sure that your UID and home directory are correct in the /etc/passwd file.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02731',' osnrnf: malloc of buffer failed',' The specified driver could not find enough heap space to MALLOC a buffer.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02732',' osnrnf: cannot find a matching database alias',' Database alias specified was not identified in either $HOME/.sqlnet or /etc/sqlnet.',' Create the alias in a file called .sqlnet in the home directory for personal use, or have system administrator create the alias in /etc/sqlnet for system-wide use.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02733',' osnsnf: database string too long',' While converting a database alias to a database ID, the resulting database ID string exceeded the Oracle system-imposed limit.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02734',' osnftt: cannot reset shared memory permission',' The Fast driver was unable to reset shared memory permissions.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02735',' osnfpm: cannot create shared memory segment',' The Fast driver failed to create a shared memory segment for two-task communication.',' Check whether the system-imposed limit on shared memory identifiers has already been reached for your system.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02736',' osnfpm: illegal default shared memory address',' The Fast driver failed to establish a default shared memory address.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02737',' osnpcl: cannot tell orapop to exit',' The Pipe driver failed to send ORAPOP the command to exit.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02738',' osnpwrtbrkmsg: incorrect number of bytes written',' The pipe driver apparently sent an incomplete break message.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02739',' osncon: host alias is too long',' The alias used for a SQLNET host is longer than 161 characters.',' Use a shorter alias.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02750',' osnfsmmap: cannot open shared memory file ?/dbs/ftt_pid.dbf',' The Fast driver failed to create a shared memory file for two-task communication.',' Check the permissions on the directory ?/dbs.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02751',' osnfsmmap: cannot map shared memory file',' The Fast driver failed to map a shared memory file for two-task communication.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02752',' osnfsmmap: illegal shared memory address',' The Fast driver failed to attach shared memory at the expected location.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02753',' osnfsmmap: cannot close shared memory file',' The Fast driver cannot close the shared memory file.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02754',' osnfsmmap: cannot change shared memory inheritence',' The Fast driver could not alter the inheritance attributes of the shared memory.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02755',' osnfsmcre: cannot create chared memory file ?/dbs/ftt_pid.dbf',' The Fast driver failed to create a file for shared memory.',' Check the permissions on the directory ?/dbs.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02756',' osnfsmnam: name translation failure',' The Fast driver encountered an error translating the shared memory file name ?/dbs/ftt_pid.dbf.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02757',' osnfop: fork_and_bind failed',' The Fast driver failed to fork a process onto the desired cluster and node number.',' Check the desired node number in sercose[0] and cluster ID in sercose[1]. If these seem valid, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02758',' Allocation of internal array failed',' The package was unable to allocate memory for an array because the system ran out of memory.',' Either reclaim memory by killing other processes or restart the machine with more memory.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02759',' Not enough request descriptors available',' All of the package''s request descriptors are in use performing other requests.',' Either wait until enough requests are done, or shut the package down and re-initialize it with more request descriptors.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02760',' Client close of file failed.',' The client was unable to close a file after forking the servers.',' This is a system problem; contact your System Administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02761',' File number to be canceled is negative.',' The file number contained with the SFIOV structure is less than zero.',' This may be a programming error. If it is not, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02762',' file number to be cancelled is greater than the maximum.',' The file number contained with the SFIOV structure is greater than the maximum.',' This may be a programming error. If it is not, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02763',' Unable to cancel at least one request',' No requests were found that could be cancelled.',' This error can occur if all the requests dealing with that file number have already been filled.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02764',' Invalid package mode',' The mode of the package can only be parallel or duplex.',' See SFA.H for the correct values.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02765',' Invalid maximum number of servers',' The number of servers given was less than or equal to zero.',' Use a number greater than zero.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02766',' Invalid maximum of request descriptors',' The number of request descriptors was less than or equal to zero.',' Use a number greater than zero.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02767',' Less than one request descriptor was allocated per server',' The package requires that the number of request descriptors be greater than or equal to the number of servers used.',' Use a higher number');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02768',' Maximum number of files is invalid',' The maximum number of files to be used by the package was less than or equal to zero.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02769',' Setting of handler for SIGTERM failed',' The package was unable to set up handling by the server for the termination signal. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02770',' Total number of blocks is invalid',' The total number of blocks to be allocated for use by the package was not greater than zero.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02771',' Illegal request time out value',' The number was not a positive number.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02772',' Invalid maximum server idle time',' The time given was not a positive number.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02773',' Invalid maximum client wait time',' The time given was not a positive number.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02774',' Invalid request list latch time out value',' The time given was not a positive number.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02775',' Invalid request done signal',' The signal number was not a positive number.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02776',' Value for request done signal exceeds maximum',' The value sent to the package for use as the "request done" signal exceeds the maximum allowed by the operating system.',' Contact your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02777',' Stat failed on log directory',' The package was unable to get information about the directory in which the log files are to reside.',' Check the permissions on the directory or use a different directory name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02778',' Name given for the log directory is invalid',' The name given for the directory in which the logs are to be kept does not correspond to a directory.',' Use a different name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02779',' Stat failed on core dump directory',' The package was unable to get information about the directory into which the servers are to dump core in the event of an exception.',' Check the permissions on the directory or use a different directory name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02780',' Name given for the core dump directory is invalid',' The name given for the directory in which the server processes are to dump core in the event of an exception does not correspond to a directory.',' Use a different name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02781',' Invalid value given for the timing wanted flag',' The value given was not TRUE or FALSE.',' Specify TRUE or FALSE for the timing wanted flag.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02782',' Both read and write functions were not specified',' To ensure that the functions act symmetrically, pointers to both the read and write functions must be given.',' Either specify both functions or specify neither. The package will supply its own functions.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02783',' Both post and wait functions were not specified',' To ensure that the functions act symmetrically, pointers to both the posting and waiting functions must be given.',' Either specify both functions or specify neither. The package will supply its own functions.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02784',' Invalid shared memory ID specified',' The ID of the segment specified for use as the shared buffer region was invalid.',' Use a different ID, or let the package specify its own.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02785',' Invalid shared memory buffer size',' The size given for the shared memory segment to be used as the shared buffer region was less than or equal to zero.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02786',' Size needed for shared region is greater than segment size',' The size of the shared segment that was specified for the shared buffer region is less than the number of bytes required. The first field of the "additional information" field is the size needed. The second is the size of the segment.',' Use a larger size segment or let the package allocate its own.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02787',' Unable to allocate memory for segment list',' The package cannot allocate memory for an internal segment list because the system has run out of memory. The "additional information" field is the amount of memory that the package attempted to allocate.',' Close some processes or contact your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02788',' Unable to find kernel process pointer in async process array',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02789',' Maximum number of files reached',' The maximum number of files that can be used for asynchronous I/O has been reached.',' Shut down the servers and re-initialize the package with a higher number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02790',' File name is too long',' The length of the name of a file that is being opened for asynchronous I/O is longer than the maximum. The "additional information" field is the maximum length.',' Use a shorter name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02791',' Unable to open file for use with asynchronous I/O',' The package could not open file for some reason.',' Check the file name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02792',' Unable to fstat() a file being used for asynchronous I/O.',' The fstat(2) call on a file being used for asynchronous I/O failed.',' Check the file name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02793',' Close of asynchronous I/O failed.',' The client was unable to close a file being used for asynchronous I/O.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02794',' Client unable to get key for shared memory',' The client was unable to get a key so that it obtain shared memory for use with shared memory. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02795',' Request list is empty',' The client was signalled by a server that it was done with a request but the "done" list was empty. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02796',' Done request is not in correct state',' A request is not in the right state. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02797',' No requests available',' No free request descriptors are available.',' Wait until some requests are filled and then retry the request, or shut down the servers and initialize the package with a higher number of requests.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02798',' Invalid number of requests',' The number of operations sent to either SFARD() or SFAWRITE() is less than zero. This is a user programming error.',' Check the calling program.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02799',' Unable to arm signal handler',' The arming of a signal handler for the "done" signal failed. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02800',' Requests timed out',' Some of the requests for asynchronous input or output were not serviced in the required amount of time.',' If the load on the system is high, it is possible that the timeout limit is too low. Reset it with SFAINIT(). If the server processes are dying due to unexpected signals, this is an internal error, and Oracle Support Services should be contacted.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02801',' Operations timed out',' Some asynchronous operations timed out in kernel mode. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02802',' No idle servers available in parallel mode',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02803',' Retrieval of current time failed',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02804',' Allocation of memory failed for log file name',' The client was unable to allocated a buffer for the name of the log file.',' Contact your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02805',' Unable to set handler for SIGTPA',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02806',' Unable to set handler for SIGALRM',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02807',' Allocation of memory for I/O vectors failed.',' The client was unable to allocate memory for the array of I/O vectors that the servers are to use.',' Contact your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02808',' Allocation of memory of open files array failed.',' The client was unable to allocate memory for an array of flags that the servers are to use.',' Contact your system administrator.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02809',' Jump buffer not valid',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02810',' Unable to make temporary file name for memory mapped file',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02811',' Unable to attach shared memory segment',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02812',' Bad attach address',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02813',' Unable to make temporary file name in order to get key',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02814',' Unable to get shared memory',' SHMGET(2) failed.',' Check the UNIX number. If you are unsure about what it means, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02815',' Unable to attach shared memory',' SHMAT(2) failed.',' Check the UNIX number. If you are unsure about what it means, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02816',' Unable to kill a process',' A server did not die after being sent a kill signal.',' The process may be a runaway; contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02817',' Read failed',' A server could not read a requested amount of data.',' Check the call to SFARD(). An incorrect file descriptor may have been sent to SFARD(). The number in the "additional information" field is the starting block number of the data segment being read in.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02818',' Less than the number of blocks requested was read in',' A server could not read in the request amount of data. The first number in the "additional information" field is the block number being read in. The second is the actual number of bytes that was read in. This is a programming error.',' Check the calling program.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02819',' Write failed',' A server was unable to perform a write. The number in the "additional information" field is the starting block number of the data segment being written out. The first number in the "additional information" field is the block number being written out. The second is the actual number of bytes that was written out. The disk may have filled up.',' Check the UNIX error number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02820',' Unable to write the requested number of blocks',' A server could not write the requested amount of data out to disk. The disk may have run out of space.',' Check the UNIX error number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02821',' Unable to read the requested number of blocks.',' A server could not read the number of blocks that was requested. The end of the file may have been read.',' Check the file on disk.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02822',' Invalid block offset',' A server was unable to seek to the designated block.',' Check the UNIX error number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02823',' Buffer is not aligned.',' The buffer on which an I/O is being done is not on the correct boundary.',' Check the calling program.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02824',' Request free list is empty',' The list from which the package allocates request descriptors is empty because all of the descriptors is in use.',' Wait until some become free, or initialize the package with a higher number of request descriptors.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02825',' Request on free list was not free',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02826',' Illegal block size',' A negative number was given for the I/O block size to be used by the asynchronous I/O package. This is a programming error.',' Use either a positive number or zero to get the default value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02827',' Invalid file number',' The file number upon which an operation is to done is either less than zero or greater than the maximum number of files than can be open.',' Since the calling program should not touch this number, this is a programming error.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02828',' Segment free list is empty',' No segments are available to allocated.',' Free some segments or shut down the package and re-initialize it with a higher number of segments.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02829',' No segment of the proper size is available',' No segment of the proper size is ready for use by the caller.',' Free some segments and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02830',' Segment could not be split - no free segments available',' A segment that is larger than that desired could not be split because no free segment was available.',' Free some segments and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02831',' Segment deallocation failed - empty segment list',' The caller attempted to deallocate a segment but the "in use" list was empty. This is a programming error.',' Check the calling program.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02832',' Segment deallocation failed - segment not on list',' The caller attempted to deallocate a segment that was not on the "in use" list. This is a programming error.',' Check the calling program.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02833',' Server was unable to close file',' A server was unable to close a file being used for asynchronous I/O.',' See the UNIX error number for more information.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02834',' Server unable to open file',' The server was unable to open a file for use with asynchronous I/O.',' Check the UNIX error number for more information.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02835',' Server unable to send signal to client',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02836',' Unable to create temporary key file',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02837',' Unable to unlink temporary file',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02838',' Unable to arm signal handler for the alarm signal',' The arming of a signal handler for the alarm signal failed. This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02839',' Sync of blocks to disk failed.',' The server was unable to flush its writes out to disk.',' Check the UNIX error number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02840',' Open of log file by client failed',' The client process was unable to open its log file.',' Check the UNIX error number for more information.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02841',' Server died on start up',' A server exited during its initialization process.',' Check the servers'' logs for more information.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02842',' Client unable to fork a server',' The client could not spawn a server. A possible reason is that the operating system has reached its limit on the number of processes that it can spawn.',' Either reduce the number of servers that are to be used, or reconfigure the operating system so that it can handle more processes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02843',' Invalid value for kernel flag',' An illegal value was given for the kernel flag in the information structure. Only TRUE and FALSE are permitted. This is a programming error.',' Check the calling routine.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02844',' Invalid value for the leave open flag',' A value was given for the flag that determines whether a file is to be left open after the client checks it to see if the servers can use it. Only TRUE and FALSE are supported. This is a programming error.',' Check the calling routine.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02845',' Invalid value for the timing wanted flag',' A value was given for the flag that indicates that operations are to be timed out. Only TRUE and FALSE are supported. This is a programming error.',' Check the calling routine.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02846',' Unkillable server',' A server failed to respond to the termination signal. The first number is the number of the server. The second is its UNIX process number. This is an internal problem.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02847',' Server did not terminate when posted',' A server did not respond to a posted request to shut down. The first number is the number of the server. The second is its UNIX process number. This is an internal problem.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02848',' Asynchronous I/O package is not running',' An operation using the asynchronous I/O package was attempted without first initializing the package using SFAINIT().',' Call SFAINIT() before using the package.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02849',' Read failed because of an error',' A server could not read the requested amount of data from disk.',' Check the UNIX error number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02850',' File is closed',' A file upon which an asynchronous I/O operation is to be performed has already been closed by the package. This is a programming error.',' Check the calling program.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02851',' Request list is empty when it should not be',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02852',' Invalid critical-section time out value',' The time given was not a positive number.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02853',' Invalid server list latch time out value',' The time given was not a positive number.',' Use a positive number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02854',' Invalid number of request buffers',' The value given for DB_SLAVE_BUFFERS in your INIT.ORA file is less than 0.',' Use a number that is greater than or equal to 0.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02855',' Number of requests is less than the number of slaves',' The value given for DB_SLAVE_BUFFERS in your INIT.ORA file is less than the number specified for the number of slaves, DB_SLAVES.',' Specify a number that is greater than that given for DB_SLAVES Alternatively, specify 0. The kernel will supply the appropriate number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02875',' smpini: Unable to get shared memory for PGA',' Stated in error code (errno).',' Resolve the problem.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02876',' smpini: Unable to attach to shared memory for PGA',' Stated in error code (errno).',' Resolve the problem.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02877',' smpini: Unable to initialize memory protection',' The ADSPCINIT program has not been executed.',' Execute the ADSCPINIT program as shown in your Installation and Users'' Guide. If the problem persists, try restarting your computer.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02878',' sou2o: Variable smpdidini overwritten',' The variable SMPDIDINI was overwritten, probably by client code.',' Verify client code (for example, in Pro*C check for illegal memory access). If the problem occurs outside Single Task operation, contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02879',' sou2o: Could not gain access to protected memory',' This is an internal error, note error code in errno.',' Restarting your application or your computer may cure the problem. If not, report the error to Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02880',' smpini: Could not register PGA for protection',' This is an internal error, note error code in errno.',' Restarting your application or your computer may cure the problem. If not, report the error to Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02881',' sou2o: Could not revoke access to protected memory',' This is an internal error, note error code in errno.',' Restarting your application or your computer may cure the problem. If not, report the error to Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02882',' sou2o: Could not register SGA for protection',' This is an internal error, note error code in errno.',' Restarting your application or your computer may cure the problem. If not, report the error to Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-02899',' smscre: Cannot create SGA with Extended Shared Memory feature',' The environment variable EXTSHM was set before starting Oracle.',' Unset the environment variable EXTSHM and restart Oracle.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03001',' unimplemented feature',' At attempt was made to use a feature that is not currently implemented.',' Do not attempt to use this feature at this time.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03002',' operator not implemented',' At attempt was made to use an operator that is not currently implemented.',' Do not attempt to use this operator at this time.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03007',' obsolete feature',' An attempt was made to use a feature that is no longer supported.',' No action required.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03008',' parameter COMPATIBLE &gt;= string needed for string',' An attempt was made to use a feature for a later Oracle version than the setting of the initialization parameter, COMPATIBLE.',' Set COMPATIBLE to the value in the message (or higher), and retry the command, but be aware that this will limit your downgrade options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03100',' communication area cannot be allocated; insufficient memory',' An attempt to allocate stack space for communication purposes failed. This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03105',' internal protocol error',NULL,NULL);
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03106',' fatal two-task communication protocol error',' The communication path between Oracle and the user task has stopped. This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03107',' oranet buffer underflow',' This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03108',' oranet: ORACLE does not support this interface version',' The version of Oracle connected to via Net8 does not support this version of the Net8 protocol.',' Upgrade the older version of Oracle and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03109',' oranet buffer overflow',' Data being transferred between the user program and Oracle overflowed the buffer space available. This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03110',' oranet: ORACLE does not support this SQL version',' The version of Oracle connected to via Net8 does not support the version of the Net8 protocol.',' Upgrade the older version of Oracle and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03111',' break received on communication channel',' A break was processed on the communications channel, but was not properly handled by Net8 software. This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03112',' a server linked as single-task cannot use SQL*Net',' A statement containing a Net8t connect string was issued to the single-task server. For example, a database link was used in a SQL statement.',' Do not use Net8t connect strings in a single-task environment.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03113',' end-of-file on communication channel',' An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.',' If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03114',' not connected to ORACLE',' A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client''s connection to the database is terminated without waiting for the client to issue a request.',' Try again. If the message recurs and the program is user written, check the program.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03115',' unsupported network datatype or representation',' A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.',' Upgrade the older version of Oracle and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03116',' invalid buffer length passed to a conversion routine',' This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03117',' two-task save area overflow',' This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03118',' two-task coroutine has invalid state',' This is an internal error message not usually issued.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03119',' two-task detected inconsistent datatype specification',' Found both a datatype, and an anonymous datatype, declaration.',' Correct the specification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03120',' two-task conversion routine: integer overflow',' An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in the user application.',' Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03121',' no interface driver connected - function not performed',' This message occurs usually because the Net8 driver is not loaded into memory or there is a mismatch of the version of the driver. A user program linked with an obsolete library may also cause this message. Only programs provided by Oracle Corporation should use this interface.',' If the message occurred during use of a program provided by Oracle Corporation, contact Oracle Support Services. If a user program caused the message, relink the program with current versions of the Oracle libraries.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03122',' attempt to close ORACLE-side window on user side',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03123',' operation would block',' The attempted operation cannot complete now.',' Retry the operation later.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03124',' two-task internal error',' This is an internal error.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03125',' client-server protocol violation',' The application received a bad escape sequence from the server and may indicate a problem with the client application user code.',' Contact Oracle Support Services.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03126',' network driver does not support non-blocking operations',' A non-blocking operation was attempted and the network driver does not support non-blocking operations.',' Use default blocking operations or use a driver supporting non-blocking operations.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03127',' no new operations allowed until the active operation ends',' An attempt was made to execute a new operation before the active non-blocking operation completed or a new operation was attempted before all the pieces of a column were inserted or fetched.',' Execute the new operation after the non-blocking operation completes. If piecewise binds/defines were done, execute the new operation after all the pieces have been inserted or fetched.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03128',' connection is in blocking mode',' The OCI test for non-blocking mode on a connection indicates that the connection is in blocking mode.',' If non-blocking mode is required use appropriate OCI calls to change the mode.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03129',' the next piece to be inserted is required',' The application performed a piecewise bind on a column.',' Provide the next piece of this bind variable.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03130',' the buffer for the next piece to be fetched is required',' The application performed a piecewise define on the column.',' Provide the next buffer for the next piece to be retrieved.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03131',' an invalid buffer was provided for the next piece',' The application either provided the length of the buffer for the next piece to be zero or provided a null pointer.',' Verify if the buffer pointer for the next piece is null or if the length is zero.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03132',' two-task default value overflow',' The default value specified for a record field was too large.',' Change the default value to fit the field size.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03200',' the segment type specification is invalid',' The segment type is not TABLE, INDEX, or CLUSTER.',' Use a correct segment type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03201',' the group number specification is invalid',' The freelist group number is either negative or larger than the number of freelist groups in the segment.',' Use a correct group number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03202',' the scan limit specification is invalid',' The scan limit does not have a positive integer value greater than the number of freelist groups in the segment.',' Use a correct scan limit.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03203',' concurrent update activity makes space analysis impossible',' High volume of user updates interfere with the space analysis.',' Retry the command or lock the underlying objects.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03204',' the segment type specification should indicate partitioning',' A partition name was specified for the space analysis, but the object type does not indicate partitioning.',' Specify PARTITION in the segment type if the object is partitioned, Otherwise, omit the partition name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03205',' partition name is required when partitioned type is specified',' A partition name was not specified for the space analysis, but the object type indicates partitioning.',' Specify a partition name if the object is partitioned. Otherwise, specify a non-partitioned type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03206',' maximum file size of (string) blocks in AUTOEXTEND clause is out of range',' The maximum file size for an autoextendable file has exceeded the maximum number of blocks allowed.',' Reduce the size and retry.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03207',' subpartitioned type must be specified for composite object',' A partition type is specified for the space analysis, but the object type indicates composite partitioning.',' Specify a subpartition name and a subpartition type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03208',' partitioned type must be specified for a non-composite object',' A subpartition type is specified for the space analysis, but the object type indicates non-composite partitioning.',' Specify a partition name and a partition type.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03209',' DBMS_ADMIN_PACKAGE invalid file/block specification',' The value of file number or block number is outside of limits or inconsistent.',' Fix the file number/block number value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03210',' DBMS_ADMIN_PACKAGE invalid option specification',' The value of one of the option parameters is incorrect.',' Fix the option value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03211',' The segment does not exist or is not in a valid state',' The segment specified in the DBMS_SPACE_ADMIN or DBMS_SPACE operation does not exist or is not in a state appropriate for this operation.',' Fix the segment specification, or put the segment in the appropriate state.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03212',' Temporary Segment cannot be created in locally-managed tablespace',' An attempt was made to create a temporary segment for SORT/HASH/LOBS in a locally-managed permanent tablespace.',' Alter temporary tablespace of user to a temporary tablespace or a dictionary-managed permanent tablespace.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03213',' Invalid Lob Segment Name for DBMS_SPACE package',' The LOB segment specified in the DBMS_SPACE operation does not exist.',' Fix the segment specification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03214',' File Size specified is smaller than minimum required',' File size specified for add/resize datafile/temporary file does not allow for the minimum required of one allocation unit.',' Increase the specification for the file size.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03215',' File Size specified for resize is too small',' File size specified for resize datafile/temporary file causes bitmap control structures to overlap.',' Increase the specification for the file size.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03216',' Tablespace/Segment Verification cannot proceed',' Corruption was detected during verification which cannot be dealt with',' Do manual verification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03217',' invalid option for alter of TEMPORARY TABLESPACE',' Invalid option for alter of temporary tablespace was specified.',' Specify one of the valid options: ADD TEMPFILE, TEMPFILE ONLINE, TEMPFILE OFFLINE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03218',' invalid option for CREATE/ALTER TABLESPACE',' Invalid option for create/alter tablespace of type locally-managed.',' Specify one of the valid options.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03219',' Tablespace ''string'' is dictionary managed, offline, or temporary.',' An operation which is only applicable to permanent, online, locally managed tablespaces is specified for a tablespace that is either dictionary managed, offline, or temporary.',' Reissue the operation for a different tablespace, mount the tablespace, or do not issue it at all since it does not apply for the given tablespace.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03220',' DBMS_ADMIN_PACKAGE required parameter is NULL or missing',' Some of the procedures were called with missing or NULL parameters.',' Specify the missing parameter.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03221',' temporary tablespaces and temporary segments must have standard block size',' An attempt was made to do one of the following:',' There are three possible solutions:');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03230',' segment only contains string blocks of unused space above high water mark',' Attempt to preserve too many blocks.',' Reduce the KEEP amount.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03231',' the INITIAL extent may not be deallocated',' Attempt to deallocate space from the segment which was truncated prior to the 7.3 release.',' Increase the KEEP amount, or truncate the segment, and reissue the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03233',' unable to extend table string.string subpartition string by string in tablespace string',' Failed to allocate an extent for table subpartition segment in tablespace.',' Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03234',' unable to extend index string.string subpartition string by string in tablespace string',' Failed to allocate an extent for index subpartition segment in tablespace.',' Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03235',' max # extents (string) reached in table string.string subpartition string',' A table subpartition tried to extend past MAXEXTENTS.',' If the value of MAXEXTENTS is less than the system maximum, raise it. Otherwise, you must re-create with larger initial, next or PCTINCREASE parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03236',' max # extents (string) reached in index string.string subpartition string',' An index subpartition tried to extend past MAXEXTENTS.',' If the value of MAXEXTENTS is less than the system maximum, raise it. Otherwise, you must re-create with larger initial, next or PCTINCREASE parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03237',' Initial Extent of specified size cannot be allocated in tablespace (string)',' Too large a size for an initial extent due to freelist group specification.',' Reduce number of freelist groups specified for the segment.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03238',' unable to extend LOB segment string.string subpartition string by string in tablespace string',' An attempt was made to allocate an extent for LOB subpartition segment in tablespace, but the extent could not be allocated because there is not enough space in the tablespace indicated.',' Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03239',' maxextents (string) reached in LOB segment string.string subpartition string',' A LOB subpartition segment tried to extend past MAXEXTENTS.',' If the value of MAXEXTENTS is less than the system maximum, raise it. Otherwise, re-create the subpartition with larger INITIAL, NEXT, or PCTINCREASE parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03240',' User''s temporary tablespace same as tablespace being migrated',' Users default temporary tablespace must be different from the tablespace being migrated.',' alter users default temporary tablespace to be different.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03241',' Invalid unit size',' User specified an invalid unit size for the tablespace.',' Specify the correct unit size. To estimate unit size, refer to the Oracle9i Database Administrator''s Guide.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03242',' Tablespace migration retried 500 times',' For migration to complete, temporary segments should not be present in the tablespace at the time of migration.',' Avoid migrating the tablespace when there is heavy temporary segment creation going on as with object drops.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03243',' destination dba overlaps with existing control information',' Cannot overlap control information during relocation.',' Choose another destination address.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03244',' No free space found to place the control information',' During migration of tablespace found no place to put the control information. If during bitmaps relocation, found no space at the specified destination.',' If during migration, add more space to the tablespace and retry migration. If during bitmaps relocation, specify a destination address where there is enough free space.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03245',' Tablespace has to be dictionary managed, online and permanent to be able to migrate',' Tablespace was not dictionary managed, online, or permanent.',' Make sure the tablespace is online, permanent, or dictionary managed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03246',' Invalid block number specified',' Control information cannot be placed at the specified DBA either because the block number specified is beyond the file end or the file is not large enough to accomodate the control information at that location.',' specify a correct block number.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03247',' Invalid block number specified',' Relocation of bitmaps to the said destination will make the tablespace self descriptive.',' Choose another destination DBA.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03248',' Too much of segment creation activity during migration',' Temporary segments were attempted to be created during migration.',' The error is signalled after retrying migration for 500 times. Run migration when there is less segment creation activity going on.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03249',' Uniform size for auto segment space managed tablespace should have atleast string blocks.',' For the given blocksize, the specified uniform size is insufficient.',' Specify a larger extent size and retry.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03250',' Cannot mark this segment corrupt',' This segment cannot be marked corrupt because it contains data dictionary objects.',' Check the segment information and re-issue the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03251',' Cannot issue this command on SYSTEM tablespace',' It is not permitted to migrate SYSTEM tablespace from locally managed format to dictionary managed format or relocate bitmaps.',' Check the tablespace name and procedure name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03274',' both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified',' The DEALLOCATE option and the ALLOCATE option are specified in the same command.',' Choose one of the options or issue two separate commands.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03275',' duplicate DEALLOCATE option specification',' The DEALLOCATE UNUSED option to ALTER TABLE or ALTER INDEX is specified more than once.',' Specify the option at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03276',' duplicate ALLOCATE EXTENT option specification',' The ALLOCATE EXTENT option to ALTER TABLE or ALTER INDEX is specified more than once.',' Specify the option at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03277',' invalid SIZE specified',' The specified value must be an integer.',' Choose an appropriate integer value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03278',' duplicate ALLOCATE EXTENT option specification',' An option (DATAFILE, SIZE or INSTANCE) was specified more than once.',' Specify each option at most once.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03279',' invalid INSTANCE specified',' The specified value is not recognized as a valid instance name.',' Use a valid name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03280',' invalid DATAFILE filename specified',' A character string literal is expected, but not found.',' Specify file names using character string literals.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03281',' invalid ALLOCATE EXTENT option',' An option other than DATAFILE, SIZE or INSTANCE was specified.',' Remove invalid option and retry the command.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03282',' missing ALLOCATE EXTENT option',' No ALLOCATE EXTENT options were specified.',' Specified one or more of the following options: DATAFILE, SIZE or INSTANCE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03283',' specified datafile string does not exist',' The datafile does not exist.',' Retry the option with the correct datafile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03284',' datafile string is not a member of tablespace string',' The specified datafile does not belong to the tablespace that the object resides in.',' Retry the option with the correct datafile.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03286',' ALLOCATE EXTENT not valid for HASH CLUSTERS',' The cluster cannot use the allocate extent option because it is a hash cluster.',' Do not use this command on a hash cluster.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03287',' invalid FREELIST GROUP specified',' The specified FREELIST GROUP number is invalid.',' Choose a number between 1 and the number of freelist groups for this object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03288',' both FREELIST GROUP and INSTANCE parameters may not be specified',' Both FREELIST GROUP and INSTANCE were specified in clause.',' Remove one of the two parameters.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03289',' partition name and segment type do not match',' Partition name and segment type specified for space analysis do not match.',' Specify type PARTITION if the object is partitioned, specify SUBPARTITION if the object is composite.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03290',' Invalid truncate command - missing CLUSTER or TABLE keyword',' Invalid object specification given.',' Either specify TRUNCATE CLUSTER or TRUNCATE TABLE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03291',' Invalid truncate option - missing STORAGE keyword',' Expected STORAGE keyword.',' Either specify DROP STORAGE or REUSE STORAGE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03292',' Table to be truncated is part of a cluster',' The table being truncated is a member of a cluster.',' Either use TRUNCATE CLUSTER or DROP TABLE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03293',' Cluster to be truncated is a HASH CLUSTER',' Only INDEX CLUSTERS can be truncated.',' Drop and re-create the HASH CLUSTER instead of using truncate.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03296',' cannot resize datafile - file string not found',' The specified datafile is not available for resizing.',' Ensure that the datafile name is valid, and if so, ensure the file is accessible.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03297',' file contains used data beyond requested RESIZE value',' Some portion of the file in the region to be trimmed is currently in use by a database object.',' Drop or move segments containing extents in this region prior to resizing the file, or choose a resize value such that only free space is in the trimmed.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03298',' cannot shrink datafile - file string is under hot backup',' Attempt to shrink a datafile while it is under hot backup. This is not allowed.',' Retry shrinking the file after the hot backup completes.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-03299',' cannot create dictionary table string',' A dictionary table is created upon the first execution of the command ALTER DATABASE DATAFILE AUTOEXTEND ON for a database. This operation did not succeed. The most probable cause for this is insufficient space in the system tablespace.',' See action for next error message in error stack.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04000',' the sum of PCTUSED and PCTFREE cannot exceed 100',' The sum of PCTUSED and PCTFREE for a cluster or table exceeds 100.',' Create the table/cluster specifying values whose sum is less than or equal to 100.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04001',' sequence parameter string must be an integer',' string (a sequence parameter) specified was not an integer.',' Create the sequence, giving the specified parameter an integer value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04002',' INCREMENT must be a non-zero integer',' A sequence increment was specified to be zero.',' Specify the increment to be a non-zero value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04003',' sequence parameter string exceeds maximum size allowed (string digits)',' string (a sequencer parameter) had too many digits.',' Specify the parameter with the allowed number of digits.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04004',' MINVALUE must be less than MAXVALUE',' MINVALUE was specified to be greater than or equal to MAXVALUE.',' Specify a MINVALUE that is less than MAXVALUE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04005',' INCREMENT must be less than MAXVALUE minus MINVALUE',' The INCREMENT specified is greater than or equal to MAXVALUE-MINVALUE.',' Specify an INCREMENT that is less than MAXVALUE-MINVALUE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04006',' START WITH cannot be less than MINVALUE',' The given starting value is less than MINVALUE.',' Make sure that the starting value is greater than or equal to MINVALUE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04007',' MINVALUE cannot be made to exceed the current value',' The given MINVALUE would be greater than the current value.',' Always make sure that MINVALUE is less than or equal to the current value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04008',' START WITH cannot be more than MAXVALUE',' The starting value would be larger than MAXVALUE.',' Make sure that the starting value is less than MAXVALUE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04009',' MAXVALUE cannot be made to be less than the current value',' The current value exceeds the given MAXVALUE.',' Make sure that the new MAXVALUE is larger than the current value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04010',' the number of values to CACHE must be greater than 1',' The value in the CACHE clause was one.',' Specify NOCACHE, or a value larger than one.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04011',' sequence string must range between string and string',' The value specified for one of the sequence parameters exceeds limits.',' Specify a parameter within these limits.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04012',' object is not a sequence',' The object specified cannot have sequence DDLs performed on it.',' Re-enter the statement being careful with the spelling of the name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04013',' number to CACHE must be less than one cycle',' The number to CACHE specified in a CREATE SEQUENCE statement exceeds the number of values in a cycle.',' Enlarge the cycle or cache fewer values, and try again.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04014',' descending sequences that CYCLE must specify MINVALUE',' A value was not specified in the CREATE SEQUENCE statement. Sequences that cycle must specify a value at which to begin again.',' Re-create the sequence, specifying the value at which it is to begin.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04015',' ascending sequences that CYCLE must specify MAXVALUE',' A value was not specified in the CREATE SEQUENCE statement. Sequences that cycle must specify a value at which to begin again.',' Recreate the sequence, specifying the value at which it is to begin.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04016',' sequence string no longer exists',' Sequence was dropped while processing its next value.',' Re-create the sequence.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04017',' invalid value string (length = string) for parameter max_dump_file_ size',' Neither did the string supplied for MAX_DUMP_FILE_SIZE parameter match the "UNLIMITED" string value nor did it represent a base 10 integer.',' Reassign a proper value to this parameter.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04018',' invalid value string for parameter _scn_scheme',' The value specified for initialization parameter _SCN_SCHEME is not recognized as one of the defined schemes.',' Reassign a proper value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04019',' SCN scheme incompatible with other instances',' Either different instances are running incompatible Oracle releases or different values have been assigned to the _SCN_SCHEME initialization parameter on different instances.',' Make sure the _SCN_SCHEME initialization parameter is set to the same value on all instances.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04020',' deadlock detected while trying to lock object stringstringstringstringstring',' While trying to lock a library object, a deadlock is detected.',' Retry the operation later.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04021',' timeout occurred while waiting to lock object stringstringstringstringstring',' While waiting to lock a library object, a timeout is occurred.',' Retry the operation later.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04022',' nowait requested, but had to wait to lock dictionary object',' Had to wait to lock a library object during a nowait request.',' Retry the operation later.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04028',' cannot generate diana for object stringstringstringstringstring',' Cannot generate diana for an object because of lock conflict.',' Report this error to your support representative.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04029',' error ORA-string occurred when querying stringstringstring',' The table or view being queried might be missing. The error number indicates the error.',' Fix the error.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04030',' out of process memory when trying to allocate string bytes (string,string)',' Operating system process private memory has been exhausted.',' See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04031',' unable to allocate string bytes of shared memory ("string","string","string","string")',' More shared memory is needed than was allocated in the shared pool.',' If the shared pool is out of memory, either use the DBMS_SHARED_ POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04032',' pga_aggregate_target must be set before switching to auto mode',' An attempt was made to set WORKAREA_SIZE_POLICY to AUTO while PGA_AGGREGATE_TARGET is not specified.',' Before setting WORKAREA_SIZE_POLICY, set PGA_AGGREGATE_TARGET to a value representing the total private memory available to the instance. This total is generally the total physical memory available in the system minus what is needed for the SGA minus what is needed for the operating system (for example, such as 500 MB).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04033',' insufficient memory to grow pool',' The system had insufficient memory to grow the pool to the specified size.',' Specify a smaller value to grow the pool.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04041',' package specification must be created first before creating package body',' Attempt to create a package body before creating its package specification.',' Create the package specification first before creating the package body.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04042',' procedure, function, package, or package body does not exist',' Attempt to access a procedure, function, package, or package body that does not exist.',' Make sure the name is correct.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04043',' object string does not exist',' An object name was specified that was not recognized by the system. Following are possible causes:',' Check the spelling of the named object and rerun the code. (Valid names of tables, views, functions, etc. can be listed by querying the data dictionary.)');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04044',' procedure, function, package, or type is not allowed here',' A procedure, function, or package was specified in an inappropriate place in a statement.',' Make sure the name is correct or remove it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04045',' errors during recompilation/revalidation of string.string',' This message indicates the object to which the following errors apply. The errors occurred during implicit recompilation/revalidation of the object.',' Check the following errors for more information, and make the necessary corrections to the object.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04046',' results of compilation are too large to support',' Attempt to compile and store a large stored procedure that results in compilation data that is too large for the system to support or store.',' Reduce the size of the store procedure by splitting it into smaller stored procedures.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04047',' object specified is incompatible with the flag specified',' The object type implied by the flag does not match the type of object specified.',' Specify the correct object, or use the appropriate flag.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04050',' invalid or missing procedure, function, or package name',' The required procedure, function, or package name is invalid or missing.',' Specify a valid name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04051',' user string cannot use database link string.string',' During forwarding of a remote object access, an attempt was made to use a non-existent database link or one owned by a user other than the logon user or PUBLIC.',' Change your database link structure so that all indirect remote accesses are done from the same userid that originates the request.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04052',' error occurred when looking up remote object stringstringstringstringstring',' An error has occurred when trying to look up a remote object.',' Fix the error. Make sure the remote database system has run KGLR.SQL to create necessary views used for querying/looking up objects stored in the database.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04053',' error occurred when validating remote object stringstringstringstringstring',' An error has occurred when trying to validate a remote object.',' Fix the error. Make sure the remote database system has run KGLR.SQL to create necessary views used for querying/looking up objects stored in the database.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04054',' database link string does not exist',' During compilation of a PL/SQL block, an attempt was made to use a non-existent database link.',' Either use a different database link or create the database link.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04055',' Aborted: "string" formed a non-REF mutually-dependent cycle with "string".',' This compilation was aborted because the library unit that was compiled would have formed a non-REF mutually-dependent cycle with some other library units. This happens when an attempt is made to compile types that have attributes of other types that may participate in a cycle with this type. Example:',' Break the cycle (possibly by adding a REF or by using another type).');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04060',' insufficient privileges to execute string',' Attempt to execute a stored procedure without sufficient privileges.',' Get necessary privileges.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04061',' existing state of string has been invalidated',' Attempt to resume the execution of a stored procedure using the existing state which has become invalid or inconsistent with the stored procedure because the procedure has been altered or dropped.',' Try again; this error should have caused the existing state of all packages to be re-initialized.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04062',' string of string has been changed',' Attempt to execute a stored procedure to serve an RPC stub which specifies a timestamp or signature that is different from the current timestamp/signature of the procedure.',' Recompile the caller in order to pick up the new timestamp.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04063',' string has errors',' Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax errors or references to other, non-existent procedures. For views, the problem could be a reference in the view''s defining query to a non-existent table. Can also be a table which has references to non-existent or inaccessible types.',' Fix the errors and/or create referenced objects as necessary.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04064',' not executed, invalidated string',' Attempt to execute a stored procedure that has been invalidated.',' Recompile the stored procedure.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04065',' not executed, altered or dropped string',' Attempt to execute a stored procedure that has been altered or dropped thus making it not callable from the calling procedure.',' Recompile its dependents.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04066',' non-executable object, string',' Attempt to execute a non-procedure.',' Make sure that a correct name is given.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04067',' not executed, string does not exist',' Attempt to execute a non-existent stored procedure.',' Make sure that a correct name is given.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04068',' existing state of packagesstringstringstring has been discarded',' An error occurred when attempting to execute a stored procedure.',' Refer to the accompanying messages and fix the error mentioned. Try the procedure again after proper reinitialization of any application''s state.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04070',' invalid trigger name',' An invalid trigger name was specified.',' Verify that trigger name is not a reserved keyword.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04071',' missing BEFORE, AFTER or INSTEAD OF keyword',' The trigger statement is missing the BEFORE/AFTER/INSTEAD OF clause.',' Specify either BEFORE, AFTER or INSTEAD OF.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04072',' invalid trigger type',' An invalid trigger type was given.',' Specify either INSERT, UPDATE or DELETE.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04073',' column list not valid for this trigger type',' A column list was specified for a non-update trigger type.',' Remove the column list.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04074',' invalid REFERENCING name',' An invalid name was given in the referencing clause.',' Verify the referencing name is not a reserved word.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04075',' invalid trigger action',' An statement was given for the trigger action.',' Re-specify the trigger action.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04076',' invalid NEW or OLD specification',' An invalid NEW or OLD specification was given for a column.',' Re-specify the column using the correct NEW or OLD specification.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04077',' WHEN clause cannot be used with table level triggers',' The when clause can only be specified for row level triggers.',' Remove the when clause or specify for each row.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04078',' OLD and NEW values cannot be identical',' The referencing clause specifies identical values for NEW and OLD.',' Re-specify either the OLD or NEW referencing value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04079',' invalid trigger specification',' The create TRIGGER statement is invalid.',' Check the statement for correct syntax.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04080',' trigger ''string'' does not exist',' The TRIGGER name is invalid.',' Check the trigger name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04081',' trigger ''string'' already exists',' The TRIGGER name or type already exists.',' Use a different trigger name or drop the trigger which is of the same name.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04082',' NEW or OLD references not allowed in table level triggers',' The trigger is accessing "new" or "old" values in a table trigger.',' Remove any new or old references.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04083',' invalid trigger variable ''string''',' The variable referenced in the trigger body is invalid.',' See the Oracle9i SQL Reference for valid trigger variable types.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04084',' cannot change NEW values for this trigger type',' New trigger variables can only be changed in before row insert or update triggers.',' Change the trigger type or remove the variable reference.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04085',' cannot change the value of an OLD reference variable',' Old values can only be read and not changed.',' Do not attempt to change an old variable.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04086',' trigger description too long, move comments into triggering code',' The trigger description is limited to 2000 characters (for dictionary storage reasons). The description does not include the text of the "when" clause or the text of the PL/SQL code executed for the trigger.',' If the trigger description contains a large comment, move that comment into the PL/SQL code for the trigger.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04087',' cannot change the value of ROWID reference variable',' ROWIDs can only be read and not changed.',' Do not attempt to change an ROWID value.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04088',' error during execution of trigger ''string.string''',' A runtime error occurred during execution of a trigger.',' Check the triggers which were involved in the operation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04089',' cannot create triggers on objects owned by SYS',' An attempt was made to create a trigger on an object owned by SYS.',' Do not create triggers on objects owned by SYS.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04090',' ''string'' specifies same table, event and trigger time as ''string''',' Trigger is of duplicate event and trigger time.',' Combine the triggering information into one trigger which is fired at the given time.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04091',' table string.string is mutating, trigger/function may not see it',' A trigger (or a user defined PL/SQL function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it.',' Rewrite the trigger (or function) so it does not read that table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04092',' cannot string in a trigger',' A trigger attempted to commit or roll back.',' Rewrite the trigger so it does not commit or roll back.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04093',' references to columns of type LONG are not allowed in triggers',' A trigger attempted to reference a long column in the triggering table.',' Do not reference the long column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04094',' table string.string is constraining, trigger may not modify it',' A trigger attempted to modify a table that was constraining for some referential constraint of a parent SQL statement.',' Rewrite the trigger so that it does not modify that table.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04095',' trigger ''string'' already exists on another table, cannot replace it',' Cannot replace a trigger which already exists on a different table than the one being replaced.',' Drop the trigger with the same name and re-create it.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04096',' trigger ''string'' has a WHEN clause which is too large, limit 2K',' A trigger''s WHEN clause is limited to 2K for dictionary storage reasons. The trigger being created exceeded that size.',' Use a smaller WHEN clause. Note, the trigger body could be used to perform the same limiting action as the WHEN clause.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04097',' DDL conflict while trying to drop or alter a trigger',' An attempt was made to concurrently perform two DDL operations on a trigger or trigger table.',' Investigate the new state of the trigger and retry the DDL operation, if still appropriate.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04098',' trigger ''string.string'' is invalid and failed re-validation',' A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger.',' Options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-04099',' trigger ''string'' is valid but not stored in compiled form',' A trigger was attempted to be retrieved for execution and was found to be valid, but not stored. This may mean the an upgrade was done improperly from a non-stored trigger release.',' Alter compile the trigger to create the trigger in stored form. Also, you may want to review that a proper upgrade was done.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24280',' invalid input value for parameter string',' The parameter has been provided a negative, out of range, or NULL input value.',' Correct the input value such that it is valid, and is within the range as specified in the documentation.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24281',' invalid access past the maximum size of LOB parameter string',' The value of positional or size parameters exceeds the maximum allowed LOB size of 4 Gigabytes.',' Correct the input values for amount and offset such that their sum is less than or equal to 4 Gigabytes. If error occurs in a read or write loop, check the looping conditions and/or offset increments.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24300',' bad value for mode',' An undefined mode value was specified.',' Check that the correct mode is selected and that an allowed value for that mode is specified.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24301',' null host specified in thread-safe logon',' An HDA was not specified in the logon call while running in a thread safe environment.',' Make sure that HDA is not NULL when calling the logon routine.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24302',' host connection in use by another thread',' An attempt was made to use the host connection while it was in use by another thread.',' Wait for another thread to finish before using this connection.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24303',' call not supported in non-deferred linkage',' One of the calls that is supported in deferred mode linkage exclusively was invoked when the client was linked non-deferred.',' Use this call in deferred mode of linkage.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24304',' datatype not allowed for this call',' Data of this datatype cannot be sent or fetched in pieces.',' Use other bind or define calls for this datatype.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24305',' bad bind or define context',' The call was executed on a cursor for which this is invalid.',' Verify that this call is valid for this cursor. For example, Get piece information and set piece information are valid on a cursor if appropriate binds and defines have been done on this cursor.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24306',' bad buffer for piece',' A zero length buffer or a null buffer pointer was provided.',' Verify that the buffer pointing to this piece or its length is non-zero. The buffer pointer for the next piece or its length can be zero if it is the last piece to be inserted and there are no more data for the column.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24307',' invalid length for piece',' The length of the piece exceeded the maximum possible size.',' Verify that the length of this piece and the cumulative length of all the previous pieces is not more than the desired value supplied by the application.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24308',' illegal define position',' Call to modify attributes was done for a non-existent position.',' Verify that a define has been done for this position.');
INSERT INTO errors (CODE,DESCRIPTION,CAUSE,ACTION) VALUES ('ORA-24309',' already connected to a server',' This server handle is already attached to a server.',' Disconnect from the server and then retry the call to establish a connection.');
