tag:blogger.com,1999:blog-74213060923685549042024-09-12T14:28:23.540-07:00Unknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7421306092368554904.post-1731862083723210492011-04-01T00:30:00.000-07:002011-04-01T00:37:09.658-07:00<div class="center-blog"> <div class="post-title"> <h1><a href="http://karthik.asia/">Oracle Errors</a></h1> </div> <div class="post-content"> <p><a title="Permanent Link to Oracle Interview Questions and Answers" rel="bookmark" href="http://karthik.asia/">Oracle Interview Questions and Answers</a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);"><br /></span></a></p> <h3><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);"><strong>Error Message Number Ranges</strong></span></a></h3> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);"><br />200 – 220 Control file management errors<br />250 – 299 Archival and media recovery errors<br />300 – 379 Redo log file errors<br />436 – 437 Oracle licensing errors<br />440 – 459 Background process startup errors<br />470 – 479 Background process fatal errors<br />500 – 599* V5-compatibility DECnet driver errors<br />700 – 709 Row cache errors<br />900 – 999 Parse errors<br />1000 – 1099 Program interface errors<br />1100 – 1199 Database file errors<br />1400 – 1499 SQL execution errors<br />1500 – 1699 Execution errors<br />1700 – 1799 Parse errors (continued)<br />1800 – 1899 Data function errors<br />1900 – 1999 Parse errors (continued)<br />2000 – 2099 Parse errors (continued)<br />2100 – 2139 Precompiler runtime errors<br />2140 – 2499 Parse errors (continued)<br />2500 – 2699* CT operating system errors<br />2700 – 2899* UNIX two-task errors<br />3000 – 3199 Two-task interface errors<br />3500 – 3699* Macintosh operating system errors<br />3700 – 3999* AOS/VS operating system errors<br />4000 – 4099 Invalid parameter errors<br />4100 – 4499* MVS operating system errors<br />4500 – 4899* CMS operating system errors<br />5000 – 5899* OEM operating system errors<br />5900 – 5999* Wang operating system errors<br />6000 – 6499* SQL*Net errors<br />6500 – 6599 PL/SQL errors<br />6600 – 6999* SQL*Net errors (continued)<br />7000 – 7099* SQL*Connect/DB2 errors<br />7100 – 7199* SQL*Connect/IMS errors<br />7200 – 7499* UNIX operating system errors<br />7500 – 7999* VAX/VMS operating system errors<br />8000 – 8199 Data layer errors<br /></span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);"><em>*Product-specific or System-specific error message not in this manual.</em></span></a></p> <p><a title="Permanent Link to Oracle Interview Questions and Answers" rel="bookmark" href="http://karthik.asia/">Oracle Interview Questions and Answers</a><a href="http://karthik.asia/"><br /><span style="color: rgb(0, 0, 0);"> ORA-00000: normal, successful completion<br />ORA-00001: duplicate key in index<br />ORA-00014: there no session number num in this process<br />ORA-00017: maximum number of calls exceeded<br />ORA-00018: maximum number of sessions exceeded<br />ORA-00019: maximum sessions per process (num) exceeded<br />ORA-00020: maximum number of processes (num) exceeded<br />ORA-00051: timeout occurred while waiting for resource<br />ORA-00052: maximum number of enqueue resources (num) exceeded</span></a> </p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-00053: maximum number of enqueues exceeded<br />ORA-00054: resource busy and acquire with NOWAIT specified<br />ORA-00055: maximum number of DML locks exceeded<br />ORA-00056: DDL lock on object ‘name’ is already held in an incompatible mode<br />ORA-00057: maximum number of DDL locks exceeded<br />ORA-00058: timeout occurred while waiting for DDL lock<br />ORA-00060: deadlock detected while waiting for resource<br />ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0<br />ORA-00200: cannot create control file ‘name’<br />ORA-00201: control file ‘name’ version num incompatible with ORACLE version num<br />ORA-00204: error in reading control file ‘name’ (block num, # blocks num)<br />ORA-00205: error in identifying control file ‘name’<br />ORA-00206: error in writing control file’name’ (block num, # blocks num)<br />ORA-00208: number of control file names exceeds limit of num<br />ORA-00209: block size num exceeds limit of num bytes<br />ORA-00210: cannot open control file’name’<br />ORA-00211: control file ‘name’ does not match previous control files<br />ORA-00212: block size num below minimum required size of num bytes<br />ORA-00213: cannot reuse control file ‘name’; old file size num, num required<br />ORA-00214: control file ‘name’ version num inconsistent with file ‘name’ version num<br />ORA-00215: must be at least one control file<br />ORA-00216: unable to determine physical block size for control file ‘name’<br />ORA-00217: control file ‘name’ physical block size num inconsistent with num<br />ORA-00218: control file ‘name’ was created with physical size num now is num<br />ORA-00219: required control file size num larger than<br />ORA-00250: archival not enabled<br />ORA-00251: archival/media recovery requires DBA privileges<br />ORA-00252: offline log ‘name’ is of sequence num, want log of sequence num<br />ORA-00253: length num of specified archive string ‘name’ exceeds limit of num<br />ORA-00254: error in archive control st3ring’str’<br />ORA-00255: error occurred during archival of log,name, sequence # num<br />ORA-00256: error occurred in translating archive text string ’str’<br />ORA-00260: cannot archive log sequence num; &gt;= current log sequence num<br />ORA-00261: cannot archive log sequence num; log currently being archived<br />ORA-00262: cannot archive log sequence num; log reused<br />ORA-00263: there are no logs that need archiving<br />ORA-00300: illegal redo log block size num specified – exceeds limit of num<br />ORA-00301: error in adding log file ‘name’ – file cannot be created<br />ORA-00302: limit of num logs exceeded<br />ORA-00305: log ‘name’ inconsistent; belongs to another database ‘name’<br />ORA-00306: limit of num log writer instances exceeded<br />ORA-00308: cannot open offline log’name’<br />ORA-00309: offline log belongs to wrong database ‘name’<br />ORA-00310: offline log ‘name’ contains sequence num; sequence num required<br />ORA-00313: cannot open online log’name’ (log # num, log sequence # num)<br />ORA-00314: online log ‘name’ (log # num, sequence # num) doesn’t match sequence #num<br />ORA-00317: cannot open current log ‘name’ (log # num, sequence # num) for writing<br />ORA-00320: cannot read log file header<br />ORA-00321: cannot update log file header<br />ORA-00324: log file ‘name’ translated name ‘name’ too long, num characters exceeds num limit<br />ORA-00327: log file’name’ has size num but should be size num</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-00331: log ‘name’ version num incompatible with ORACLE version num<br />ORA-00334: cannot start up logs – num logs found, at least 2 needed<br />ORA-00336: log file size num blocks is less than minimum num blocks<br />ORA-00337: log file ‘name’ does not exist and no size specified<br />ORA-00340: IO error processing online log file’name’ (log # num, log sequence num)<br />ORA-00341: online log file ‘name’ has log file # num, should be # num<br />ORA-00342: current online log ‘name’ has wrong sequence # num, should be num<br />ORA-00343: unspooled online log ‘name’ has wrong sequence num, should be num<br />ORA-00344: unable to create log ‘name’ at the end of manual recovery<br />ORA-00345: redo log write error block num count num<br />ORA-00346: log sequence in future during media recovery<br />ORA-00347: online log ‘name’ (log # num, sequence # num) has block size num should be num<br />ORA-00348: single-process redo failure<br />ORA-00349: failure obtaining block size for num<br />ORA-00436: ORACLE is not licensed. Contact Oracle Corp. for assistance<br />ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance<br />ORA-00444: background process ‘name’ failed while starting<br />ORA-00445: background process ‘name’ didn’t start<br />ORA-00446: background process started when not expected<br />ORA-00447: fatal error in background process<br />ORA-00448: normal completion of background process<br />ORA-00449: background process ‘name’ unexpectedly terminated with error num<br />ORA-00470: LGWR process terminated with error<br />ORA-00471: DBWR process terminated with error<br />ORA-00472: PMON process terminated with error<br />ORA-00474: SMON process terminated with error<br />ORA-00481: SMON process posting itself<br />ORA-00600: intemal error code, arguments: [numl, [?], [?], [?], [?], [?]<br />ORA-00601: cleanup lock conflict<br />ORA-00602: internal programming exception<br />ORA-00603: fatal ORACLE error occurred; unwise to proceed<br />ORA-00604: error occurred at recursive SQL level num<br />ORA-00700: maximum number of row cache object (parameter ‘name’) exceeded<br />ORA-00701: object necessary for warmstarting database cannot be altered<br />ORA-00702: maximum number of row cache enqueues exceeded<br />ORA-00703: maximum number of row cache instance locks exceeded<br />ORA-00816: error message translation failed<br />ORA-00900: invalid SQL statement<br />ORA-00901: invalid CREATE command<br />ORA-00902: invalid datatype<br />ORA-00903: invalid table name<br />ORA-00904: invalid column name<br />ORA-00905: missing keyword<br />ORA-00906: missing left parenthesis<br />ORA-00907: missing right parenthesis<br />ORA-00908: missing NULL keyword<br />ORA-00909: invalid number of arguments<br />ORA-00910: specified length too large for CHAR column<br />ORA-00911: invalid character<br />ORA-00913: too many values<br />ORA-00914: missing ADD keyword<br />ORA-00915: network access of dictionary table not currently allowed</span></a></p> <p><a title="Permanent Link to Oracle Interview Questions and Answers" rel="bookmark" href="http://karthik.asia/">Oracle Interview Questions and Answers</a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-00917: missing comma<br />ORA-00918: column ambiguously defined<br />ORA-00919: invalid function<br />ORA-00920: invalid relational operator<br />ORA-00921: unexpected end of SQL command<br />ORA-00922: invalid option<br />ORA-00923: FROM keyword not found where expected<br />ORA-00924: missing BY keyword<br />ORA-00925: missing INTO keyword<br />ORA-00926: missing VALUES keyword<br />ORA-00927: missing equal sign<br />ORA-00928: missing SELECT keyword<br />ORA-00929: missing period<br />ORA-00930: missing asterisk<br />ORA-00931: missing identifier<br />ORA-00932: inconsistent datatypes<br />ORA-00933: SQL command not properly ended<br />ORA-00934: group function is not allowed here<br />ORA-00935: group function is nested too deeply<br />ORA-00936: missing expression<br />ORA-00937: not a single-group function<br />ORA-00938: not enough arguments for function<br />ORA-00939: too many arguments for function<br />ORA-00940: invalid ALTER command<br />ORA-00941: missing cluster name<br />ORA-00942: table or view does not exist<br />ORA-00943: cluster does not exist<br />ORA-00944: insufficient number of clustered columns<br />ORA-00945: specified clustered column does not exist<br />ORA-00946: missing TO keyword<br />ORA-00947: illegal use of LONG datatype<br />ORA-00947: not enough values<br />ORA-00949: illegal reference to remote database<br />ORA-00950: invalid DROP option<br />ORA-00951: cluster not empty<br />ORA-00952: missing GROUP keyword<br />ORA-00953: missing index name<br />ORA-00954: missing IDENTIFIED keyword<br />ORA-00955: name is already used by an existing object<br />ORA-00956: invalid auditing option<br />ORA-00957: duplicate column name<br />ORA-00958: missing CHECK keyword<br />ORA-00959: tablespace ‘name’ does not exist<br />ORA-00964: table name not in FROM list<br />ORA-00965: column aliases not allowed for<br />ORA-00966: missing TABLE keyword<br />ORA-00967: missing WHERE keyword<br />ORA-00968: missing INDEX keyword<br />ORA-00969: missing ON keyword<br />ORA-00970: missing WITH keyword<br />ORA-00971: missing SET keyword<br />ORA-00972: nidentifier is too long<br />ORA-00974: invalid PCTFREE value (percentage)</span></a></p> <p><a title="Permanent Link to Oracle Interview Questions and Answers" rel="bookmark" href="http://karthik.asia/">Oracle Interview Questions and Answers</a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-00975: date + date not allowed<br />ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here<br />ORA-00977: duplicate auditing option<br />ORA-00978: nest group function without GROUP BY<br />ORA-00979: not a GROUP BY expression<br />ORA-00980: translation is no longer valid<br />ORA-00981: cannot mix table and system-wide auditing options<br />ORA-00982: missing plus sign<br />ORA-00983: cannot define ROWID column – no corresponding SQL datatype<br />ORA-00984: column not allowed here<br />ORA-00985: invalid program name<br />ORA-00986: missing or invalid group names(s)<br />ORA-00987: missing or invalid username(s)<br />ORA-00988: missing or invalid password(s)<br />ORA-00989: too many passwords for usernames given<br />ORA-00990: missing or invalid privilege<br />ORA-00991: invalid format for GRANT command<br />ORA-00992: invalid format for REVOKE command<br />ORA-00993: missing GRANT keyword<br />ORA-00994: missing OPTION keyword<br />ORA-00995: missing or invalid synonym identifier<br />ORA-00996: the concatenate operator is || not |<br />ORA-00998: must name this expression width a column alias<br />ORA-00999: invalid view name<br />ORA-01000: maximum open cursors exceeded<br />ORA-01001: invalid cursor<br />ORA-01002: fetch out of sequence<br />ORA-01003: no statement parsed<br />ORA-01004: default username feature not supported; logon denied<br />ORA-01005: null password given; logon denied<br />ORA-01006: bind variable does not exist<br />ORA-01007: variable not in select list<br />ORA-01008: not all variables bound<br />ORA-01009: missing mandatory parameter<br />ORA-01010: invalid OCI operation<br />ORA-01012: not logged on<br />ORA-01013: user requested cancel of current operation<br />ORA-01014: ORACLE shutdown in progress<br />ORA-01015: logon called recursively<br />ORA-01017: invalid username/password; logon denied<br />ORA-01018: column does not have a LONG datatype<br />ORA-01020: unknown context state<br />ORA-01021: invalid context size specified<br />ORA-01024: invalid datatype in OCI call<br />ORA-01025: UPI parameter out of range<br />ORA-01027: bind variables not allowed for data definition operations<br />ORA-01028: error backing out last row, transaction rolled back<br />ORA-01030: SELECT … INTO variable does not exist<br />ORA-01031: insufficient privileges<br />ORA-01032: no such userid<br />ORA-01033: ORACLE initialization or shutdown in progress<br />ORA-01034: ORACLE not available<br />ORA-01037: cannot allocate sort work area cursor; too many cursors</span></a></p> <p><a title="Permanent Link to Oracle Interview Questions and Answers" rel="bookmark" href="http://karthik.asia/">Oracle Interview Questions and Answers</a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-01038: this version of ORACLE is too old to access the database<br />ORA-01039: database version num incompatible with ORACLE version num<br />ORA-01040: this version of ORACLE does not match the mounted system<br />ORA-01046: cannot acquire space to extend context area<br />ORA-01050: cannot acquire space to open context area<br />ORA-01053: user storage address cannot be read<br />ORA-01054: user storage address cannot be written<br />ORA-01057: invalid or ambiguous block.field reference in user exit<br />ORA-01071: cannot perform operation without starting up ORACLE<br />ORA-01072: cannot stop ORACLE, ORACLE not running<br />ORA-01073: fatal connection error: unrecognized call type<br />ORA-01074: cannot shut down ORACLE; inside a logon session – log off first<br />ORA-01075: you are currently logged on<br />ORA-01076: multiple logons per process not yet supported<br />ORA-01077: background process initialization failure<br />ORA-01078: failure in sending system parameters<br />ORA-01080: error in shutting down ORACLE<br />ORA-01081: cannot star already-running ORACLE – shut it down first<br />ORA-01085: maximum savepoints exceeded<br />ORA-01086: savepoint ‘name’ never established<br />ORA-01087: cannot start up ORACLE – ctmently logged on<br />ORA-01088: cannot shut down ORACLE while active processes exist<br />ORA-01089: immediate shutdown in progress – no operations are permitted<br />ORA-01090: shutdown in progress – connection is not permitted<br />ORA-01091: failure during stop force<br />ORA-01099: cannot mount database in SHARED mode if started in single process mode<br />ORA-01100: database ready mounted<br />ORA-01101: database being created currently mounted by some other instance<br />ORA-01102: cannot mount database in EXCLUSIVE mode<br />ORA-01103: database name ‘name’ in control file is not ‘name’<br />ORA-01104: number of control files num disagrees with first instance’s number of control files num<br />ORA-01105: control file sequence num disagrees with first instance’s control file sequence num<br />ORA-01106: database must be closed before dismounting<br />ORA-01107: database must be mounted for media recovery<br />ORA-01108: too many instances opening database<br />ORA-01109: database not open<br />ORA-01110: file ‘name’ not online<br />ORA-01112: media recovery not started<br />ORA-01113: file ‘name’ needs media recovery starting at log sequence num<br />ORA-01114: IO error writing blocks of file’name’ (block num, blocks num)<br />ORA-01115: IO error reading blocks from file ‘name’ (block num, blocks num)<br />ORA-01116: error in opening database file ‘name’<br />ORA-01118: cannot add any more database files: limit of num exceeded<br />ORA-01119: error in creating database file ‘name’<br />ORA-01120: cannot remove online database file ‘name’; database is open or SHARED<br />ORA-01121: cannot rename online database file ‘name’; database is open or mounted<br />SHARED<br />ORA-01122: database file ‘name’ (file ‘name’) failed verification check<br />ORA-01123: cannot set online backup; media recovery not enabled<br />ORA-01124: cannot recover online file ‘name’ unless datab;ase mounted EXCLUSIVE<br />ORA-01125: cannot disable media recovery – file ‘name’ has online backup set</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-01126: database must be mounted EXCUSIVE and not operate for this operation<br />ORA-01127: database name ‘name’ exceeds size limit of num characters<br />ORA-01128: file ‘name’ does not exist<br />ORA-01129: user’s default tablespace does not exist<br />ORA-01130: database file ‘name’ version num incompatible with ORACLE version num<br />ORA-01131: DB_FILES system parameter value num exceeds limit of num<br />ORA-01132: length of database file name ‘name’ exceeds limit of num characters<br />ORA-01133: length of log file name’name’ exceeds limit of num characters<br />ORA-01134: database mounted EXCLUSIVE by another instance<br />ORA-01135: file ‘name’ accessed for DML/query belongs to offline tablespace<br />ORA-01136: DBWR failed to open file ‘name’ – possibly locked by another OS process<br />ORA-01137: error ending backup – begin backup timestamps do not match<br />ORA-01138: manual database recovery has not applied enough logs to make files valid<br />ORA-01139: RESETLOGS optiononIy vaIid after a manual database recovery<br />ORA-01141: error renaming datafile ‘name’ -new file ‘name’ not found<br />ORA-01143: cilnno.t disable media recovery – file ‘name’ is offline<br />ORA-01144: tablespace file ‘name’ needs media recovery starting at log sequence # num<br />ORA-01145: tablespace offline immediate disallowed unless media recovery enabled<br />ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert<br />ORA-01401: inserted value too large for column<br />ORA-01402: WITH CHECK OPTION violates view’s WHERE clause<br />ORA-01403: no data found<br />ORA-01405: fetched column value is NULL<br />ORA-01406: fetched column value was truncated<br />ORA-01407: cannot update mandatory (NOT NULL) column to NULL<br />ORA-01408: such column list already indexed<br />ORA-01409: NOSORT option may not be used; rows are not in ascending order<br />ORA-01410: invalid ROWID<br />ORA-01416: two tables cannot be outer-joined to each other<br />ORA-01417: more than one table with (+) in outer join predicate<br />ORA-01418: specified index does not exist<br />ORA-01419: datdts: illegal format code<br />ORA-01420: datstd: illegal format code<br />ORA-01421: datrnd/dattrn: illegal precision specifier<br />ORA-01427: single-row query returns more than one row<br />ORA-01430: column being added already exists in table<br />ORA-01431: internal inconsistency in GRANT command<br />ORA-01432: public synonym to be dropped does not exist<br />ORA-01433: synonym to be created is already defined<br />ORA-01434: private synonym to be dropped does not exist<br />ORA-01435: user does not exist<br />ORA-01436: CONNECT BY loop in user data<br />ORA-01437: cannot have join with CONNECT BY<br />ORA-01438: value larger than specified precision allows for this column<br />ORA-01439: column to be modified must be empty to change datatype<br />ORA-01440: column to be modified must be empty to decrease precision or scale<br />ORA-01441: column to be modified must be empty to decrease column length<br />ORA-01442: column to be modified to NOT NULL is already NOT NULL<br />ORA-01443: intemal inconsistency, illegal datatype in resultant view column<br />ORA-01444: internal inconsistency, internal datatype inaps to invalid external type<br />ORA-01445: cannot select ROWID from view of more than one table<br />ORA-01446: cannot select ROWID from view with DISTINCT, GROUP BY, etc.<br />ORA-01448: index must be dropped before changing to desired type</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-01449: column contains NULL values; cannot alter to NOT NULL<br />ORA-01450: maximum key length exceeded<br />ORA-01451: column to be modified to NULL is already NULL<br />ORA-01452: cannot CREATE UNIQUE INDEX, duplicate keys found<br />ORA-01453: SET TRANSACTION must be first statement of transaction<br />ORA-01454: cannot convert column into numeric datatype<br />ORA-01455: converting column overflows integer datatype<br />ORA-01456: may not perform update operation inside a READ ONLY transaction<br />ORA-01457: converting column overflows decimal datatype<br />ORA-01458: invalid length inside variable character string<br />ORA-01459: invalid length for variable character string<br />ORA-01460: unimplemented or unreasonable conversion requested<br />ORA-01461: can bind a LONG value only for insert into a LONG column<br />ORA-01462: cannot insert string literals longer than 255 characters<br />ORA-01463: cannot grant to or revoke from self<br />ORA-01464: circular grant (granting to grant ancestor) of table or view<br />ORA-01465: invalid hex number<br />ORA-01466: unable to read data – table definition has changed<br />ORA-01467: sort key too long<br />ORA-01469: PRIOR can only be followed by a column name<br />ORA-01471: cannot create a synonym with the same name as object<br />ORA-01472: cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.<br />ORA-01473: cannot have subqueries in CONNECT BY clause<br />ORA-01474: cannot have START WITH or PRIOR without CONNECT BY<br />ORA-01475: must parse cursor to change bind variable datat3Te<br />ORA-01476: divisor is equal to zero<br />ORA-01477: user data area descriptor is too large<br />ORA-01478: array bind may not include any LONG columns<br />ORA-01480: trailing null missing from STR bind value<br />ORA-01481: invalid TO_CHAR format string<br />ORA-01482: unsupported character set<br />ORA-01483: invalid length for DATE or NUMBER bind variable<br />ORA-01500: failure in getting date/time<br />ORA-01501: CREATE DATABASE failed<br />ORA-01503: cannot get control file name(s)<br />ORA-01505: error in adding log files<br />ORA-01506: missing or illegal database name<br />ORA-01507: database not mounted<br />ORA-01508: cannot create database; error in file ‘name’ at line num.<br />ORA-01509: specified name ‘name’ does not match actual ‘name’<br />ORA-01510: error in deleting log files<br />ORA-01511: error in renaming log/data files<br />ORA-01514: error in dropping log ‘name’; no such log<br />ORA-01515: cannot drop log at this time; log in use<br />ORA-01516: ii nonexistent log/data file ‘name”<br />ORA-01517: cannot rename log ‘name’ at this time; log in use<br />ORA-01518: CREATE DATABASE must specify more than one log file<br />ORA-01519: error while processing file ‘name’ near line num<br />ORA-01520: number of data files to add (num) exceeds limit of num<br />ORA-01521: error in adding data files<br />ORA-01522: file ‘name’ to be renamed does not exist<br />ORA-01523: name data file to ‘name’ file already part of database<br />ORA-01524: failure in renaming data file ‘name”</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-01525: error in renaming data files<br />ORA-01526: error in opening file ‘name’<br />ORA-01527: error while reading file ‘name’<br />ORA-01528: EOF while processing SQL statement<br />ORA-01529: error closing file ‘name’<br />ORA-01532: cannot create database; instance being started elsewhere<br />ORA-01533: cannot rename file ‘name’, file does not belong to tablespace<br />ORA-01534: rollback segment name doesn’t exist<br />ORA-01535: rollback segment ‘name’ already exists<br />ORA-01535: sii snapshot too old (rollback seg3nent too small)<br />ORA-01536: resource privilege or space quota exceeded for tablespace ‘name’<br />ORA-01537: cannot add data file ‘name’ – file already part of database<br />ORA-01538: failed to acquire any rollback segment<br />ORA-01539: tablespace ‘name’ is not online S@<br />ORA-01540: tablespace ‘name’ is not offline<br />ORA-01541: tablespace cannot be brought offline, shut down if necessary<br />ORA-01542: tablespace ‘name’ is of tine, cannot allocate space in it<br />ORA-01543: tablespace ‘name’ already exists<br />ORA-01544: cannot drop system rollback segment<br />ORA-01545: rollback segment ‘name’ specified not available<br />ORA-01547: ecl to allocate extent of size num in tablespace ‘name’<br />ORA-01549: tablespace not empty, use INCLUDING CONTENTS option<br />ORA-01550: cannot drop system tablespace<br />ORA-01551: extended rollback segment, pinned blocks released<br />ORA-01552: cannot use system rollback segment for non-system tablespace ‘name’<br />ORA-01554: out of transaction slots in transaction tables<br />ORA-01556: maximum number of extents exceeded<br />ORA-01557: rollback segment extents must be at least 3 blocks<br />ORA-01558: out of transaction ID’s in rollback segment ‘name’<br />ORA-01559: MAXEXTENTS for rollback segment must be greater than 1<br />ORA-01560: global hash table size mismatch<br />ORA-01561: failed to remove all object in the tablespace specified<br />ORA-01562: failed to extend rollback segment<br />ORA-01563: rollback segment is PUBLIC, need to use the keyword PUBLIC<br />ORA-01564: rollback segment is not PUBLIC<br />ORA-01565: error in identifying file’name’<br />ORA-01566: file specified more than once in DROP LOGFILE<br />ORA-01567: dropping log would leave less than two log files<br />ORA-01568: cannot set space quota on PUBLIC<br />ORA-01569: data file too small for system dictionary tables<br />ORA-01571: log records version num incompatible with ORACLE version num<br />ORA-01572: global hash table size num for rollback segments is too small for rollback<br />segment ID ‘name’<br />ORA-01573: shutting down instance, no further change allowed<br />ORA-01574: maximum number of concurrent transactions exceeded<br />ORA-01575: timeout waiting for space management resource<br />ORA-01576: instance locking protocol version num incompatible with ORACLE version<br />num<br />ORA-01577: cannot add log file ‘name’ – file already part of database<br />ORA-01578: ORACLE data block corrupted (file # num, block num)<br />ORA-01700: duplicate username in list<br />ORA-01703: missing SYNONYM keyword<br />ORA-01704: string literal too long</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-01706: user function result value was too large<br />ORA-01707: missing LIST keyword<br />ORA-01709: program does not exist<br />ORA-01710: missing OF keyword<br />ORA-01711: duplicate privilege listed<br />ORA-01712: you cannot grant a privilege which you do not have<br />ORA-01713: GRANT OPTION does not exist for that privilege<br />ORA-01714: error in execution of user function<br />ORA-01715: UNIQUE may not be used with a cluster index<br />ORA-01716: NOSORT may not be used with a cluster index<br />ORA-01717: seccta: invalid access mode token passed<br />ORA-01722: invalid number<br />ORA-01723: zero-length columns are not allowed<br />ORA-01725: must have DBA privilege to do requested GRANT or REVOKE<br />ORA-01727: numeric precision specifier is out of range (1 to 38)<br />ORA-01728: numeric scale sped ier is out of range (-84 to 127)<br />ORA-01729: database link name expected<br />ORA-01730: invalid number of column names specified<br />ORA-01731: circular view definition encountered<br />ORA-01732: data manipulation operation not legal on this view<br />ORA-01733: virtual column not allowed here<br />ORA-01734: must have DBA privilege to create or drop PUBLIC synonyms<br />ORA-01735: invalid ALTER TABLE option<br />ORA-01736: [NOT] SUCCESSFUL expected<br />ORA-01737: you may only lock a table in SHARE for EXCLUSIVE mode<br />ORA-01738: missing IN keyword<br />ORA-01739: missing MODE keyword<br />ORA-01740: missing double quote in identifier<br />ORA-01741: illegal zero-length identifier<br />ORA-01743: internal inconsistency; illegal user function index<br />ORA-01744: inappropriate INTO<br />ORA-01745: invalid host/bind variable name<br />ORA-01746: indicator variable not permitted here<br />ORA-01747: invalid user.table.column, table.column or columns specification<br />ORA-01748: only simple column names allowed here<br />ORA-01749: you may not GRANT/REVOKE privileges to/from yourself<br />ORA-01750: UPDATE REFERENCES may only be REVOKED from the whole table, not by column<br />ORA-01753: column definition incompatible with clustered column definition<br />ORA-01756: quoted string not properly terminated<br />ORA-01758: table must be empty to add mandatory (NOT NULL) column<br />ORA-01759: user function is incorrectly defined<br />ORA-01760: illegal argument for function<br />ORA-01762: vopdrv: view query block not in FROM<br />ORA-01765: specifying table’s owner name is not allowed<br />ORA-01766: dictionary table not allowed in this context<br />ORA-01767: UPDATE … SET expression must be a subquery<br />ORA-01768: number string too long<br />ORA-01769: duplicate CLUSTER option specifications<br />ORA-01770: CLUSTER option not allowed in CREATE CLUSTER command<br />ORA-01771: illegal option for a clustered table<br />ORA-01773: may not specify column datatypes in this CREATE TABLE<br />ORA-01775: looping chain of synonyms</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-01777: WITH GRANT OPTION not allowed in this system<br />ORA-01778: maximum subquery nesting level exceeded<br />ORA-01780: string literal required<br />ORA-01785: ORDER BY item must be the number of a SELECT list expression<br />ORA-01786: FOR UPDATE of this query expression is not allowed<br />ORA-01787: only one clause allowed per query<br />ORA-01788: CONNECT BY clause required in this query<br />ORA-01789: query has incorrect number of result columns<br />ORA-01790: expression must have same datatype as corresponding expression<br />ORA-01791: not a SELECTed expression<br />ORA-01792: maximum number of columns in a table or view is 254<br />ORA-01793: minimum number of index columns is 16<br />ORA-01794: maximum number of cluster columns is 16<br />ORA-01795: maximum number of expressions in a list is 254<br />ORA-01796: this operator cannot be used with lists<br />ORA-01797: this operator must be followed by ANY or ALL<br />ORA-01799: must have DBA privilege for this AUDIT operation<br />ORA-01801: date format is too long for internal buffer<br />ORA-01802: Julian date is out of range<br />ORA-01810: format code appears twice<br />ORA-01811: Julian date precludes use of day of year<br />ORA-01812 : year may only be specified once<br />ORA-01813: hour may only be specified once<br />ORA-01815: BC/AD conflicts with use of B.C./A.D.<br />ORA-01816: month may only be specified once<br />ORA-01817: day of week may only be specified once<br />ORA-01818: ‘HH24′ precludes use of meridian indicator<br />ORA-01819: signed year precludes use of BC/AD<br />ORA-01820: format code cannot appear in date input format<br />ORA-01821: date format not recognized<br />ORA-01830: date format picture ends before converting entire input string<br />ORA-01831: year conflicts with Julian date<br />ORA-01832: day of year conflicts with Julian date<br />ORA-01833: month coniflicts with Julian date<br />ORA-01834: day of month conflicts with Julian date<br />ORA-01835: day of week conflicts with Julian date<br />ORA-01836: hour conflicts with seconds in day<br />ORA-01837: minutes of hour conflicts with seconds in day<br />ORA-01838: seconds of minute conflicts with seconds in day<br />ORA-01839: date not valid for month specified<br />ORA-01840: input value not long enough for date format<br />ORA-01841: (full) year must be between -4713 and +4713<br />ORA-01842: quarter must be between 1 and 4<br />ORA-01843: not a valid month<br />ORA-01844: week of year must be between 1 and 52<br />ORA-01845: week of month must be between 1 and 5<br />ORA-01846: ot a valid day of the week<br />ORA-01847: day of month must be between 1 and last day of month<br />ORA-01848: day of year must be between 1 and 365 (366 for leap year)<br />ORA-01849: hour must be between 1 and 12<br />ORA-01850: hour must be between 0 and 23<br />ORA-01851: minutes must be between 0 and 59<br />ORA-01852: seconds must be between 0 and 59</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-01853: seconds in day must be between 0 and 86399<br />ORA-01856: BC/B.C. or AD/A.D. required<br />ORA-01857: not a valid time zone<br />ORA-01897: invalid delimiter in date input string<br />ORA-01900: LOGFILE keyword expected<br />ORA-01901: ROLLEACK keyword expected<br />ORA-01902: SEGMENT keyword expected<br />ORA-01903: EVENTS keyword expected<br />ORA-01904: DATAFILE keyword expected<br />ORA-01905: STORAGE keyword expected<br />ORA-01906: BACKUP keyword expected<br />ORA-01907: TABLESPACE keyword expected<br />ORA-01908: EXISTS keyword expected<br />ORA-01909: REUSE keyword expected<br />ORA-01910: TABLES keyword expected<br />ORA-01911: CONTENTS keyword expected<br />ORA-01912: ROW keyword expected<br />ORA-01913: EXCLUSIVE keyword expected<br />ORA-01914: invalid auditing option for sequence numbers<br />ORA-01915: invalid auditing option for views<br />ORA-02002: error while writing to audit trail<br />ORA-02003: invalid USERENV parameter<br />ORA-02004: security violation<br />ORA-02005: implicit (-l) length not valid for this bind or define datatype<br />ORA-02006: invalid packed decimal format string<br />ORA-02008: non-zero scale specified for nonnumeric column<br />ORA-02010: missing host connect string<br />ORA-02011: duplicate database link rtame<br />ORA-02012: missing USING keyword<br />ORA-02013: missing CONNECT keyword<br />ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.<br />ORA-02015: cannot select FOR UPDATE from remote table<br />ORA-02016: cannot use a subquery in a START on a remote database<br />ORA-02017: integer value required<br />ORA-02018: database link of same name has an open connection<br />ORA-02019: database link does not exist<br />ORA-02020: database link connection table is full<br />ORA-02021: inappropriate operation f or remote database<br />ORA-02023: START WITH or CONNECT BY predicate cannot be evaluated by remote<br />database<br />ORA-02024: CONNECT BY and ROWID not supported by remote database<br />ORA-02025: must have DBA privilege to create or drop PUBLIC database links<br />ORA-02026: missing LINK keyword<br />ORA-02027: multi-row UPDATE of LONG column is not supported<br />ORA-02029: missing FILE keyword<br />ORA-02030: can only select from fixed tables/views<br />ORA-02031: no ROWRD for fixed tables<br />ORA-02032: clustered tables cannot be used before the cluster index is built<br />ORA-02140: invalid tablespace name<br />ORA-02141: invalid OFFLINE option<br />ORA-02142: missing or invalid ALTER TABLESPACE option<br />ORA-02143: invalid STORAGE option<br />ORA-02144: no option specif ied for ALTER CLUSTER</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-02145: missing STORAGE option<br />ORA-02146: SHARED specified multiple times<br />ORA-02147: conflicting SHARED/EXCLUSIVE options<br />ORA-02148: EXCLUSIVE specified multiple times<br />ORA-02150: invalid username following ALTER USER<br />ORA-02151: invalid option for ALTER USER<br />ORA-02152: invalid password for ALTER USER IDENTIFIED BY<br />ORA-02153: invalid password text for ALTER USER IDENTIFIED BY VALUES<br />ORA-02154: invalid argument to ALTER USER IDENTIFIED By<br />ORA-02155: invalid DEFAULT tablespace identifier<br />ORA-02156: invalid TEMPORARY tablespace identifier<br />ORA-02157: options specified for ALTER USER<br />ORA-02158: invalid CREATE INDEX option<br />ORA-02161: invalid value for LOGFILES<br />ORA-02162: invalid value for MAXDATAFILES<br />ORA-02163: invalid value for MAXINSTANCES<br />ORA-02164: DATAFILE clause specified more than once<br />ORA-02165: invalid option for CREATED DATABASE<br />ORA-02166: ARCHIVELOG and NOARCHIVELOG specified<br />ORA-02167: LOGFILE clause specified more than once<br />ORA-02173: invalid option for DROP TABLESPACE<br />ORA-02175: invalid rollback segment name<br />ORA-02176: invalid option for CREATE ROLLBACK SEGMENT<br />ORA-02178: correct syntax is: SET TRANSACTION READ {ONLY | WRITE}<br />ORA-02180: invalid option for CREATE TABLESPACE<br />ORA-02181: invalid option to ROLLBACK WORK<br />ORA-02182: savepoint name expected<br />ORA-02184: resource quotas are not allowed in REVOKE<br />ORA-02186: tablespace resource privilege may not appear with other privileges<br />ORA-02187: invalid quota specification<br />ORA-02189: ON &lt; tablespace&gt; required<br />ORA-02190: keyword TABLES expected<br />ORA-02192: must have DBA privilege to CREATE or ALTER DATABASE<br />ORA-02193: must have DBA privilege to CREATE/ALTER/DROP ROLLBACK SEGMENT<br />ORA-02194: event specification syntax error num (minor error num) near’name’<br />ORA-02195: must have DBA privilege to CREATE(ALTER/DROP TABLESPACE<br />ORA-02196: must have DBA privilege to ALTER USER<br />ORA-02197: file list already specified<br />ORA-02198: ONLINE/OFFLINE option already specified<br />ORA-02199: missing DATAFILE clause<br />ORA-02200: WITH GRANT OPTION not allowed for PUBLIC<br />ORA-02201: sequence not allowed here<br />ORA-02202: no more tables permitted in this cluster<br />ORA-02203: INITIAL and MINEXTENTS storage options not allowed<br />ORA-02205: DELETE, INDEX, INSERT, UPDATE, and REFERENCES not allowed for sequences<br />ORA-02206: duplicate INITRANS option specification<br />ORA-02207: invalid INITRANS option value<br />ORA-02208: duplicate MAXTRANS option specification<br />ORA-02209: invalid MAXTRANS option value<br />ORA-02210: no options specified for ALTER TABLE<br />ORA-02211: invalid value for PCTFREE or PCTUSED</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-02212: duplicate PCTFREE option specification<br />ORA-02213: duplicate PCTUSED option specification<br />ORA-02214: duplicate BACKUP option specification<br />ORA-02215: duplicate tablespace name clause<br />ORA-02216: tablespace name expected<br />ORA-02217: duplicate storage option specification<br />ORA-02218: invalid INITIAL storage option value<br />ORA-02219: invalid NEXT storage option value<br />ORA-02220: invalid MINEXTENTS storage option value<br />ORA-02221: invalid MAXEXTENTS storage option value<br />ORA-02222: invalid PCTINCREASE storage option value<br />ORA-02227: invalid cluster name<br />ORA-02228: duplicate SIZE specification<br />ORA-02229: invalid SIZE option value<br />ORA-02230: invalid ALTER CLUSTER option<br />ORA-02231: missing or invalid option to ALTER DATABASE<br />ORA-02232: invalid MOUNT mode<br />ORA-02233: invalid CLOSE mode<br />ORA-02236: invalid file name<br />ORA-02237: invalid file size<br />ORA-02238: filename lists have different numbers of files<br />ORA-02242: no options specified for ALTER INDEX<br />ORA-02243: invalidALTER INDEXoption<br />ORA-02244: invalidALTER ROLLBACK SEGMENToption<br />ORA-02245: invalid ROLLBACK SEGMENT name<br />ORA-02246: missing EVENTS text<br />ORA-02247: no option sped ied for ALTER SESSION<br />ORA-02248: invalid option for ALTER SESSION<br />ORA-02250: missing or invalid constraint name<br />ORA-02251: subquery not allowed here<br />ORA-02252: check constraint condition not properly ended<br />ORA-02253: constraint specification not allowed here<br />ORA-02254: DEFAULT not allowed here<br />ORA-02255: NOT NULL not allowed after DEFAULT NULL<br />ORA-02256: number of referencing columns must be equal to number of referenced ced columns<br />ORA-02257: maximum number of columns exceeded<br />ORA-02258: Duplicate or conflicting NULL and/or NOT NULL specifications<br />ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications<br />ORA-02260: table can have only one primary key<br />ORA-02261: such unique or primary key already exists in the table<br />ORA-02262: ORA-num occurs while type-checking column default value expression<br />ORA-02263: need to specify the datatype for this column<br />ORA-02264: name already used by an existing constraint<br />ORA-02265: cannot derive the datatype of the referencing column<br />ORA-02267: column type incompatible with referenced column type<br />ORA-02268: referenced table does not have a primary key<br />ORA-02269: key column cannot be of LONG datatype<br />ORA-02270: such unique or primary key does not exist in the referenced table<br />ORA-02271: table does not have such constraint<br />ORA-02272: constrained column cannot be of LONG datatype<br />ORA-02273: this unique/primary key is referenced by some foreign keys<br />ORA-02276: default value type incompatible with column type</span></a></p> <p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);">ORA-02277: invalid sequence name<br />ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications<br />ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications<br />ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications<br />ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications<br />ORA-02282: duplicate or conflicting ORDER/NOORDER specifications<br />ORA-02283: cannot alter starting sequence number<br />ORA-02284: duplicate INCREMENT BY specifications<br />ORA-02285: duplicate START WITH specifications<br />ORA-02286: no options specified for ALTER SEQUENCE<br />ORA-02287: sequence number not allowed here<br />ORA-02288: invalid OPEN mode<br />ORA-02289: sequence does not exist<br />ORA-03001: unimplemented feature<br />ORA-03002: operator not implemented<br />ORA-03007: obsolete feature<br />ORA-03100: communication area cannot be allocated; insufficient memory<br />ORA-03106: fatal two-task communication protocol error<br />ORA-03107: oranet buffer underflow<br />ORA-03108: oranet: ORACLE does not support this interface option<br />ORA-03109: oranet buffer overflow<br />ORA-03110: oranet: ORACLE does not support this SQL version<br />ORA-03111: break received on communication channel<br />ORA-03112: host string syntax error<br />ORA-03113: end-of-file on communication channel<br />ORA-03114: not connected to ORACLE<br />ORA-03115: unsupported network datatype or representation<br />ORA-03116: ttcxxx: invalid buffer length<br />ORA-03117: ttc save area overflow<br />ORA-03118: ttc coroutine has invalid state<br />ORA-03119: ttcc2u: invalid character<br />ORA-03120: ttci2u: integer overflow<br />ORA-03121: no interface driver connected – function not performed<br />ORA-03122: attempt to close ORACLE-side window on user side<br />ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100<br />ORA-04001: ‘name’ must be an integer<br />ORA-04002: INCREMENT must be a non-zero integer<br />ORA-04003: num exceeds the maximum size allowed (num digits) for sequences<br />ORA-04004: MINVALUE must be less than MAXVALUE<br />ORA-04005: INCREMENT must be less than MAXVALUE minus MINVALUE<br />ORA-04006: START WITH cannot be less than MINVALUE<br />ORA-04007: MINVALUE cannot be made to exceed the current value<br />ORA-04008: START WITH cannot be more than MAXVALUE<br />ORA-04009: MAXVALUE cannot be made to be less than the current value<br />ORA-04010: the number of values to CACHE must be greater than 1<br />ORA-04012: object is not a sequence<br />ORA-04013: number to CACHE must be less than one cycle<br />ORA-04014: str scending sequences that CYCLE must specified str VALUE<br />ORA-06500: PL/SQL: storage error<br />ORA-06501: PL/SQL: program error<br />ORA-06502: PL/SQL: numeric or value error<br />ORA-06503: PL/SQL: error num – str<br />ORA-08001: maximum number of sequences per session exceeded</span></a></p><a href="http://karthik.asia/">ORA-08002: name.CURRVAL is not yet defined in this session<br /></a><p><a href="http://karthik.asia/"><span style="color: rgb(0, 0, 0);"> ORA-08004: name.NEXTVALstr strVALUE and cannot be instantiated<br />ORA-08005: specified row does not exist<br />ORA-08006: specified row no longer exists<br />ORA-08007: specified row has changed since selection<br />ORA-08100: index is not valid – see trace file for diagnostics<br />ORA-08101: index key does not exist<br />ORA-08102: index key not found<br />ORA-61035: ORACLE only available to users with DBA privilege</span></a></p> </div> <div class="post-meta"> </div> </div>Unknownnoreply@blogger.com1