{"id":1758,"date":"2016-03-08T09:07:39","date_gmt":"2016-03-08T06:07:39","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1758"},"modified":"2016-10-21T09:09:08","modified_gmt":"2016-10-21T06:09:08","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-04000-to-ora-04100","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-04000-to-ora-04100\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-04000 to ORA-04100"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-04000 to ORA-04100<\/strong><\/p>\n

\n
ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the sum of PCTUSED and PCTFREE for a cluster or table exceeds 100<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0create the table\/cluster specifying values whose sum is <= 100<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04001: sequence parameter\u00a0string<\/i>\u00a0must be an integer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0%s (a sequence parameter) specified was not an integer<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0create the sequence, giving the specified parameter an integer value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04002: INCREMENT must be a non-zero integer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a sequence increment was specified to be zero<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify the increment to be a non-zero value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04003: sequence parameter\u00a0string<\/i>\u00a0exceeds maximum size allowed (string<\/i>\u00a0digits)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0%s (a sequencer parameter) had too many digits<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify the parameter with the allowed number of digits<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04004: MINVALUE must be less than MAXVALUE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0MINVALUE was specified to be greater than or equal to MAXVALUE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify a MINVALUE that is less than MAXVALUE<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04005: INCREMENT must be less than MAXVALUE minus MINVALUE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the INCREMENT specified is >= MAXVALUE-MINVALUE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify an INCREMENT that is < MAXVALUE-MINVALUE<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04006: START WITH cannot be less than MINVALUE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the given starting value is less than MINVALUE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0make sure that the starting value is >= MINVALUE<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-04007: MINVALUE cannot be made to exceed the current value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the given MINVALUE would be greater than the current value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0always make sure that MINVALUE is <= the current value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04008: START WITH cannot be more than MAXVALUE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the starting value would be larger than MAXVALUE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0make sure that the starting value is less than MAXVALUE<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04009: MAXVALUE cannot be made to be less than the current value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the current value exceeds the given MAXVALUE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0make sure that the new MAXVALUE is larger than the current value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04010: the number of values to CACHE must be greater than 1<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the value in the CACHE clause was one<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify NOCACHE, or a value larger than one<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04011: sequence\u00a0string<\/i>\u00a0must range between\u00a0string<\/i>\u00a0and\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the value specified for one of the sequence parameters exceeds limits<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify parameter within these limits<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04012: object is not a sequence<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0the object specified cannot have sequence ddl’s performed on it<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0re-enter the statement being careful with the spelling of the name<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04013: number to CACHE must be less than one cycle<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0number to CACHE given is larger than values in a cycle<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0enlarge the cycle, or cache fewer values<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04014: descending sequences that CYCLE must specify MINVALUE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0sequences that cycle must have their wrap-wrap specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0re-create the sequence, specifying its wrap-value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04015: ascending sequences that CYCLE must specify MAXVALUE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0sequences that cycle must have their wrap-wrap specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0re-create the sequence, specifying its wrap-value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04016: sequence\u00a0string<\/i>\u00a0no longer exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0sequence was dropped while processing its next value.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0re-create the sequence<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04017: invalid value\u00a0string<\/i>\u00a0(length =\u00a0string<\/i>) for parameter max_dump_file_size<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0neither did the string supplied for max_dump_file_size parameter match the “UNLIMITED” string value nor did it represent a base 10 integer.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0reassign a proper value to this parameter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04020: deadlock detected while trying to lock object\u00a0stringstringstringstringstring<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0While trying to lock a library object, a deadlock is detected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the operation later.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04021: timeout occurred while waiting to lock object\u00a0stringstringstringstringstring<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0While waiting to lock a library object, a timeout occurred.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the operation later.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04022: nowait requested, but had to wait to lock dictionary object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Had to wait to lock a library object during a nowait request.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the operation later.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04023: Object\u00a0stringstringstringstringstring<\/i>\u00a0could not be validated or authorized<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A number of attempts were made to validate or authorize an object but failed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Please report this error to Oracle Support Services.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04024: self-deadlock detected while trying to mutex pin cursor\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0While trying to mutex pin a cursor, a self-deadlock is detected.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the operation later.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04027: self-deadlock during automatic validation for object\u00a0string<\/i>.string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to validate an invalidated object but it failed because of a self-deadlock.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0, e.g. compile the invalidated object separately.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04028: cannot generate diana for object\u00a0stringstringstringstringstring<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Cannot generate diana for an object because of lock conflict.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Please report this error to your support representative.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04029: error ORA-string<\/i>\u00a0occurred when querying\u00a0stringstringstring<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table or view being queried might be missing. The error number indicates the error.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the error.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04030: out of process memory when trying to allocate\u00a0string<\/i>\u00a0bytes (string<\/i>,string<\/i>)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Operating system process private memory was exhausted.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04031: unable to allocate\u00a0string<\/i>\u00a0bytes of shared memory (“string<\/i>“,”string<\/i>“,”string<\/i>“,”string<\/i>“)<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0More shared memory is needed than was allocated in the shared pool.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If 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.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04032: pga_aggregate_target must be set before switching to auto mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempt to set workarea_size_policy to AUTO while pga_aggregate_target is not specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0before 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 (e.g. 500MB)<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04033: Insufficient memory to grow pool<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The system had insufficient memory to grow the pool to the specified size.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a smaller value to grow the pool.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04034: unable to shrink pool to specified size<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The pool could not shrink to the specified size as it could not free memory.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a larger value to which to shrink the pool to.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04035: unable to allocate\u00a0string<\/i>\u00a0bytes of shared memory in shared object cache “string<\/i>” of size “string<\/i>“<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0More shared memory is needed than was allocated in the shared object cache.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04041: package specification must be created first before creating package body<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to create a package body before creating its package specification.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create the package specification first before creating the package body.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04042: procedure, function, package, or package body does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to access a procedure, function, package, or package body that does not exist.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the name is correct.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04043: object\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An object name was specified that was not recognized by the system. There are several possible causes:<\/span><\/span><\/span><\/dd>\n
– An invalid name for a table, view, sequence, procedure, function, package, or package body was entered. Since the system could not recognize the invalid name, it responded with the message that the named object does not exist.<\/span><\/span><\/span><\/dd>\n
– An attempt was made to rename an index or a cluster, or some other object that cannot be renamed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check 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.)<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04044: procedure, function, package, or type is not allowed here<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A procedure, function, or package was specified in an inappropriate place in a statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure the name is correct or remove it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04045: errors during recompilation\/revalidation of\u00a0string<\/i>.string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This message indicates the object to which the following errors apply. The errors occurred during implicit recompilation\/revalidation of the object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the following errors for more information, and make the necessary corrections to the object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04046: results of compilation are too large to support<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to compile and store a large stored procedure that results in compilation data that is too large for the system to support or store.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reduce the size of the store procedure by splitting it into smaller stored procedures.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04047: object specified is incompatible with the flag specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The object type implied by the flag does not match the type of object specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the correct object, or use the appropriate flag<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04050: invalid or missing procedure, function, or package name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The required procedure, function, or package name is invalid or missing.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04051: user\u00a0string<\/i>\u00a0cannot use database link\u00a0string<\/i>.string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0During 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change your database link structure so that all indirect remote accesses are done from the same userid that originates the request.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04052: error occurred when looking up remote object\u00a0stringstringstringstringstring<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred when trying to look up a remote object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the error. Make sure the remote database system has run CATRPC.SQL to create necessary views used for querying or looking up objects stored in the database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04053: error occurred when validating remote object\u00a0stringstringstringstringstring<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An error occurred when trying to validate a remote object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the error. Make sure the remote database system has run CATRPC.SQL to create necessary views used for querying or looking up objects stored in the database.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04054: database link\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0During compilation of a PL\/SQL block, an attempt was made to use a non-existent database link.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either use a different database link or create the database link.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04055: Aborted: “string<\/i>” formed a non-REF mutually-dependent cycle with “string<\/i>“.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This 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: create type t1; create type t2 (a t1); create type t1 (a t2);<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Break the cycle (possibly by adding a REF or by using another type).<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04060: insufficient privileges to execute\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to execute a stored procedure without sufficient privileges.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Get necessary privileges.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04061: existing state of\u00a0string<\/i>\u00a0has been invalidated<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try again; this error should have caused the existing state of all packages to be re-initialized.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04062:\u00a0string<\/i>\u00a0of\u00a0string<\/i>\u00a0has been changed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recompile the caller in order to pick up the new timestamp.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04063:\u00a0string<\/i>\u00a0has errors<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Fix the errors and\/or create referenced objects as necessary.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04064: not executed, invalidated\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to execute a stored procedure that has been invalidated.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recompile it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04065: not executed, altered or dropped\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to execute a stored procedure that has been altered or dropped thus making it not callable from the calling procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Recompile its dependents.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04066: non-executable object,\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to execute a non-procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that a correct name is given.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04067: not executed,\u00a0string<\/i>\u00a0does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to execute a non-existent stored procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that a correct name is given.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04068: existing state of packagesstringstringstring<\/i>\u00a0has been discarded<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of errors 4060 – 4067 when attempt to execute a stored procedure.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Try again after proper re-initialization of any application’s state.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04069: cannot drop or replace a library with table dependents<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop or replace a library that has dependents. There could be a table which depends on type which depends on the library being dropped.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all table(s) depending on the type, then retry.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04070: invalid trigger name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid trigger name was specified.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify that trigger name is not a reserved keyword.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The trigger statement is missing the BEFORE\/AFTER\/INSTEAD OF clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify either BEFORE, AFTER or INSTEAD OF.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04072: invalid trigger type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid trigger type was given.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify either INSERT, UPDATE or DELETE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04073: column list not valid for this trigger type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A column list was specified for a non-update trigger type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the column list.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04074: invalid REFERENCING name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid name was given in the referencing clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Verify the referencing name is not a reserved word.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04075: invalid trigger action<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An statement was given for the trigger action.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-specify the trigger action.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04076: invalid NEW or OLD specification<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid NEW or OLD specification was given for a column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-specify the column using the correct NEW or OLD specification.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04077: WHEN clause cannot be used with table level triggers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The when clause can only be specified for row level triggers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the when clause or specify for each row.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04078: OLD and NEW values cannot be identical<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The referencing clause specifies identical values for NEW and OLD.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-specify either the OLD or NEW referencing value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04079: invalid trigger specification<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The create TRIGGER statement is invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the statement for correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04080: trigger ‘string<\/i>‘ does not exist<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The TRIGGER name is invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the trigger name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04081: trigger ‘string<\/i>‘ already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The TRIGGER name or type already exists.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a different trigger name or drop the trigger which is of the same name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04082: NEW or OLD references not allowed in table level triggers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The trigger is accessing “new” or “old” values in a table trigger.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove any new or old references.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04083: invalid trigger variable ‘string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The variable referenced in the trigger body is invalid.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0See the manual for valid trigger variable types.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04084: cannot change NEW values for this trigger type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0New trigger variables can only be changed in before row insert or update triggers.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Change the trigger type or remove the variable reference.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04085: cannot change the value of an OLD reference variable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Old values can only be read and not changed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to change an old variable.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04086: trigger description too long, move comments into triggering code<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If the trigger description contains a large comment, move that<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04087: cannot change the value of ROWID reference variable<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Rowid’s can only be read and not changed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to change an rowid value.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04088: error during execution of trigger ‘string<\/i>.string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A runtime error occurred during execution of a trigger.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the triggers which were involved in the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04089: cannot create triggers on objects owned by SYS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a trigger on an object owned by SYS.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not create triggers on objects owned by SYS.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04090: ‘string<\/i>‘ specifies same table, event and trigger time as ‘string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Trigger is of duplicate event and trigger time.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Combine the triggering information into one trigger which is fired at the given time.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04091: table\u00a0string<\/i>.string<\/i>\u00a0is mutating, trigger\/function may not see it<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A trigger (or a user defined plsql 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rewrite the trigger (or function) so it does not read that table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04092: cannot\u00a0string<\/i>\u00a0in a trigger<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A trigger attempted to commit or rollback.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rewrite the trigger so it does not commit or rollback.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04093: references to columns of type LONG are not allowed in triggers<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A trigger attempted to reference a long column in the triggering table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not reference the long column.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04094: table\u00a0string<\/i>.string<\/i>\u00a0is constraining, trigger may not modify it<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A trigger attempted to modify a table that was constraining for some referential constraint of a parent SQL statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04095: trigger ‘string<\/i>‘ already exists on another table, cannot replace it<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Cannot replace a trigger which already exists on a different table than the one being replaced.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop the trigger with the same name and re-create it.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04096: trigger ‘string<\/i>‘ has a WHEN clause which is too large, limit 2K<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A trigger’s ‘when’ clause is limited to 2K for dictionary storage reasons. The trigger being created exceeded that size.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a smaller ‘when’ clause. Note, the trigger body could be used to perform the same limiting action as the ‘when’ clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04097: DDL conflict while trying to drop or alter a trigger<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to concurrently perform two DDL operations on a trigger or trigger table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Investigate the new state of the trigger and retry the DDL operation, if still appropriate.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04098: trigger ‘string<\/i>.string<\/i>‘ is invalid and failed re-validation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation\/authorization failed for the trigger.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Options are to resolve the compilation\/authorization errors, disable the trigger, or drop the trigger.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-04099: trigger ‘string<\/i>‘ is valid but not stored in compiled form<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A 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.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Alter compile the trigger to create the trigger in stored form. Also, you may want to review that a proper upgrade was done.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-04000 to ORA-04100 ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100 Cause:\u00a0the sum of PCTUSED and PCTFREE for a cluster or table exceeds 100 Action:\u00a0create the table\/cluster specifying values whose sum is <= 100 ORA-04001: sequence parameter\u00a0string\u00a0must be an integer Cause:\u00a0%s (a sequence parameter) specified…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1758","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-sm","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1758"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1758\/revisions"}],"predecessor-version":[{"id":1759,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1758\/revisions\/1759"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1758"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}