Most Common Oracle Errors
List of ORA Error Codes:
ORA-0000: normal,
successful completion
Cause: An operation done successfully without any exception.
Action: No action required.
ORA-00001: unique
constraint (.) violated
Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
Action: Either remove the unique restriction or do not insert the key.
ORA-00017: session
requested to set trace event
Cause: The current session was requested to set a trace event by another session.
Action: This is used internally; no action is required.
ORA-00018: maximum
number of sessions exceeded
Cause: All session state objects are in use.
Action: Increase the value of the SESSIONS initialization parameter.
ORA-00019: maximum
number of session licenses exceeded
ORA-00020: maximum
number of processes () exceeded
ORA-00021: session
attached to some other process; cannot switch session
ORA-00022: invalid
session ID; access denied
ORA-00023: session
references process private memory; cannot detach session
ORA-00024: logins from
more than one process not allowed in single-process mode
ORA-00025: failed to
allocate
ORA-00026: missing or
invalid session ID
ORA-00027: cannot kill
current session
ORA-00028: your session
has been killed
ORA-00029: session is
not a user session
ORA-00030: User session
ID does not exist.
ORA-00031: session
marked for kill
ORA-00032: invalid
session migration password
ORA-00033: current
session has empty migration password
ORA-00034: cannot in
current PL/SQL session
ORA-00035:
LICENSE_MAX_USERS cannot be less than current number of users
ORA-00036: maximum
number of recursive SQL levels () exceeded
ORA-00037: cannot switch
to a session belonging to a different server group
ORA-00038: Cannot create
session: server group belongs to another user
ORA-00039: error during
periodic action
ORA-00040: active time
limit exceeded - call aborted
ORA-00041: active time
limit exceeded - session terminated
ORA-00042: Unknown
Service name
ORA-00050: operating
system error occurred while obtaining an enqueue
ORA-00051: timeout
occurred while waiting for a resource
ORA-00052: maximum
number of enqueue resources () exceeded
ORA-00053: maximum
number of enqueues exceeded
ORA-00054: resource busy
and acquire with NOWAIT specified
ORA-00055: maximum
number of DML locks exceeded
ORA-00056: DDL lock on
object '.' is already held in an incompatible mode
ORA-00057: maximum
number of temporary table locks exceeded
ORA-00058: DB_BLOCK_SIZE
must be to mount this database (not )
ORA-00059: maximum
number of DB_FILES exceeded
ORA-00060: deadlock
detected while waiting for resource
ORA-00061: another
instance has a different DML_LOCKS setting
ORA-00062: DML
full-table lock cannot be acquired; DML_LOCKS is 0
ORA-00063: maximum
number of log files exceeded
ORA-00064: object is too
large to allocate on this O/S (,)
ORA-00065:
initialization of FIXED_DATE failed
ORA-00066: SID contains
an illegal character
ORA-00067: invalid value
for parameter ; must be at least
ORA-00068: invalid value
for parameter , must be between and
ORA-00069: cannot
acquire lock -- table locks disabled for
ORA-00070: command is
not valid
ORA-00071: process
number must be between 1 and
ORA-00072: process
"" is not active
ORA-00073: command takes
between and argument(s)
ORA-00074: no process
has been specified
ORA-00075: process
"" not found in this instance
ORA-00076: dump not
found
ORA-00077: dump is not
valid
ORA-00078: cannot dump
variables by name
ORA-00079: variable not
found
ORA-00080: invalid
global area specified by level
ORA-00081: address range
[, ) is not readable
ORA-00082: memory size
of is not in valid set of [1], [2], [4]
ORA-00083: warning:
possibly corrupt SGA mapped
ORA-00084: global area
must be PGA, SGA, or UGA
ORA-00085: current call
does not exist
ORA-00086: user call
does not exist
ORA-00087: command
cannot be executed on remote instance
ORA-00088: command
cannot be executed by shared server
ORA-00089: invalid
instance number in ORADEBUG command
ORA-00090: failed to
allocate memory for cluster database ORADEBUG command
ORA-00091:
LARGE_POOL_SIZE must be at least
ORA-00092:
LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
ORA-00093: must be
between and
ORA-00094: requires an
integer value
ORA-00096: invalid value
for parameter , must be from among
ORA-00097: use of Oracle
SQL feature not in SQL92 Level
ORA-00100: no data found
ORA-00101: invalid
specification for system parameter DISPATCHERS
ORA-00102: network
protocol cannot be used by dispatchers
ORA-00103: invalid
network protocol; reserved for use by dispatchers
ORA-00104: deadlock
detected; all public servers blocked waiting for resources
ORA-00105: too many
dispatcher configurations
ORA-00106: cannot
startup/shutdown database when connected to a dispatcher
ORA-00107: failed to
connect to ORACLE listener process
ORA-00108: failed to set
up dispatcher to accept connection asynchronously
ORA-00109: invalid value
for attribute :
ORA-00110: invalid value
for attribute , must be between and
ORA-00111: invalid
attribute
ORA-00112: value of is
null
ORA-00113: protocol name
is too long
ORA-00114: missing value
for system parameter SERVICE_NAMES
ORA-00115: connection
refused; dispatcher connection table is full
ORA-00116: SERVICE_NAMES
name is too long
ORA-00117: PROTOCOL,
ADDRESS or DESCRIPTION must be specified
ORA-00118: Only one of
PROTOCOL, ADDRESS or DESCRIPTION may be specified
ORA-00119: invalid
specification for system parameter
ORA-00122: cannot
initialize network configuration
ORA-00123: idle public
server terminating
ORA-00125: connection
refused; invalid presentation
ORA-00126: connection
refused; invalid duplicity
ORA-00127: dispatcher
does not exist
ORA-00128: this command
requires a dispatcher name
ORA-00129: listener
address validation failed ''
ORA-00130: invalid
listener address ''
ORA-00131: network
protocol does not support registration ''
ORA-00132: syntax error
or unresolved network name ''
ORA-00133: value of is
too long
ORA-00134: invalid DISPATCHERS
specification #
ORA-00150: duplicate
transaction ID
ORA-00151: invalid
transaction ID
ORA-00152: current
session does not match requested session
ORA-00153: internal
error in XA library
ORA-00154: protocol
error in transaction monitor
ORA-00155: cannot
perform work outside of global transaction
ORA-00160: global
transaction length is greater than maximum ()
ORA-00161: transaction
branch length is illegal (maximum allowed )
ORA-00162: external dbid
length is greater than maximum ()
ORA-00163: internal
database name length is greater than maximum ()
ORA-00164: distributed
autonomous transaction disallowed within migratable distributed transaction
ORA-00165: migratable
distributed autonomous transaction with remote operation is not allowed
ORA-00166: remote/local
nesting level is too deep
ORA-00200: control file
could not be created
ORA-00201: control file
version incompatible with ORACLE version
ORA-00202: control file:
''
ORA-00203: using the
wrong control files
ORA-00204: error in
reading (block , # blocks ) of control file
ORA-00205: error in
identifying control file, check alert log for more info
ORA-00206: error in
writing (block , # blocks ) of control file
ORA-00207: control files
are not for the same database
ORA-00208: number of
control file names exceeds limit of
ORA-00209: control file
blocksize mismatch, check alert log for more info
ORA-00210: cannot open
the specified control file
ORA-00211: control file
does not match previous control files
ORA-00212: block size
below minimum required size of bytes
ORA-00213: cannot reuse
control file; old file size , required
ORA-00214: control file
'' version inconsistent with file '' version
ORA-00215: must be at
least one control file
ORA-00216: control file
could not be resized for migration from 8.0.2
ORA-00217: control file
could not be resized for new record types
ORA-00218: block size of
control file '' does not match DB_BLOCK_SIZE ()
ORA-00219: required
control file size ( logical blocks) exceeds maximum allowable size ( logical
blocks)
ORA-00220: control file
not mounted by first instance, check alert log for more info
ORA-00221: error on
write to control file
ORA-00222: operation
would reuse name of a currently mounted control file
ORA-00223: convert file
is invalid or incorrect version
ORA-00224: control file
resize attempted with illegal record type ()
ORA-00225: expected size
of control file differs from actual size
ORA-00226: operation
disallowed while alternate control file open
ORA-00227: corrupt block
detected in control file: (block , # blocks )
ORA-00228: length of
alternate control file name exceeds maximum of
ORA-00229: operation
disallowed: already hold snapshot control file enqueue
ORA-00230: operation
disallowed: snapshot control file enqueue unavailable
ORA-00231: snapshot
control file has not been named
ORA-00232: snapshot
control file is nonexistent, corrupt, or unreadable
ORA-00233: copy control
file is corrupt or unreadable
ORA-00234: error in
identifying or opening snapshot or copy control file
ORA-00235: control file
fixed table inconsistent due to concurrent update
ORA-00236: snapshot
operation disallowed: mounted control file is a backup
ORA-00237: snapshot
operation disallowed: control file newly created
ORA-00238: operation
would reuse a filename that is part of the database
ORA-00239: timeout
waiting for control file enqueue: held by '' for more than seconds
ORA-00240: control file
enqueue held for more than seconds
ORA-00250: archiver not
started
ORA-00251:
LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string
ORA-00252: log of thread
is empty, cannot archive
ORA-00253: character
limit exceeded by archive destination string
ORA-00254: error in
archive control string ''
ORA-00255: error archiving
log of thread , sequence #
ORA-00256: cannot
translate archive destination string
ORA-00257: archiver
error. Connect internal only, until freed.
ORA-00258: manual
archiving in NOARCHIVELOG mode must identify log
ORA-00259: log of open
instance (thread ) is the current log, cannot archive
ORA-00260: cannot find
online log sequence for thread
ORA-00261: log of thread
is being archived or modified
ORA-00262: current log
of closed thread cannot switch
ORA-00263: there are no
logs that need archiving for thread
ORA-00264: no recovery
required
ORA-00265: instance
recovery required, cannot set ARCHIVELOG mode
ORA-00266: name of
archived log file needed
ORA-00267: name of
archived log file not needed
ORA-00268: specified log
file does not exist ''
ORA-00269: specified log
file is part of thread not
ORA-00270: error
creating archive log
ORA-00271: there are no
logs that need archiving
ORA-00272: error writing
archive log
ORA-00273: media
recovery of direct load data that was not logged
ORA-00274: illegal
recovery option
ORA-00275: media
recovery has already been started
ORA-00276: CHANGE
keyword specified but no change number given
ORA-00277: illegal
option to the UNTIL recovery flag
ORA-00278: log file ''
no longer needed for this recovery
ORA-00279: change
generated at needed for thread
ORA-00280: change for
thread is in sequence #
ORA-00281: media
recovery may not be performed using dispatcher
ORA-00282: UPI call not
supported, use ALTER DATABASE RECOVER
ORA-00283: recovery
session canceled due to errors
ORA-00284: recovery
session still in progress
ORA-00285: TIME not
given as a string constant
ORA-00286: no members
available, or no member contains valid data
ORA-00287: specified
change number not found in thread
ORA-00288: to continue
recovery type ALTER DATABASE RECOVER CONTINUE
ORA-00289: suggestion :
ORA-00290: operating
system archival error occurred. See error below
ORA-00291: numeric value
required for PARALLEL option
ORA-00292: parallel
recovery feature not installed
ORA-00293: control file
out of sync with redo log
ORA-00294: invalid
archivelog format specifier ''
ORA-00295:
datafile/tempfile number is invalid, must be between 1 and
ORA-00296: maximum
number of files () exceeded for RECOVER DATAFILE LIST
ORA-00297: must specify
RECOVER DATAFILE LIST before RECOVER DATAFILE START
ORA-00298: Missing or
invalid attribute value
ORA-00299: must use
file-level media recovery on data file
ORA-00300: illegal redo
log block size specified - exceeds limit of
ORA-00301: error in
adding log file '' - file cannot be created
ORA-00302: limit of logs
exceeded
ORA-00303: cannot
process Parallel Redo
ORA-00304: requested
INSTANCE_NUMBER is busy
ORA-00305: log of thread
inconsistent; belongs to another database
ORA-00306: limit of
instances in this database
ORA-00307: requested
INSTANCE_NUMBER out of range, maximum is
ORA-00308: cannot open
archived log ''
ORA-00309: log belongs
to wrong database
ORA-00310: archived log
contains sequence ; sequence required
ORA-00311: cannot read
header from archived log
ORA-00312: online log
thread : ''
ORA-00313: open failed
for members of log group of thread
ORA-00314: log of thread
, expected sequence# doesn't match
ORA-00315: log of thread
, wrong thread # in header
ORA-00316: log of thread
, type in header is not log file
ORA-00317: file type in
header is not log file
ORA-00318: log of thread
, expected file size doesn't match
ORA-00319: log of thread
has incorrect log reset status
ORA-00320: cannot read
file header from log of thread
ORA-00321: log of thread
, cannot update log file header
ORA-00322: log of thread
is not current copy
ORA-00323: Current log
of thread not useable and all others need archiving
ORA-00324: log file ''
translated name '' too long, characters exceeds limit
ORA-00325: archived log
for thread , wrong thread # in header
ORA-00326: log begins at
change , need earlier change
ORA-00327: log of thread
, physical size less than needed
ORA-00328: archived log
ends at change , need later change
ORA-00329: archived log
begins at change , need change
ORA-00330: archived log
ends at change , need change
ORA-00331: log version
incompatible with ORACLE version
ORA-00332: archived log
is too small - may be incompletely archived
ORA-00333: redo log read
error block count
ORA-00334: archived log:
''
ORA-00335: online log :
No log with this number, log does not exist
ORA-00336: log file size
blocks is less than minimum blocks
ORA-01539: tablespace ''
is not online
ORA-01540: tablespace ''
is not offline
ORA-01541: system
tablespace cannot be brought offline; shut down if necessary
ORA-01542: tablespace ''
is offline, cannot allocate space in it
ORA-01543: tablespace ''
already exists
ORA-01544: cannot drop
system rollback segment
ORA-01545: rollback
segment '' specified not available
ORA-01546: tablespace
contains active rollback segment ''
ORA-01547: warning:
RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01548: active
rollback segment '' found, terminate dropping tablespace
ORA-01549: tablespace
not empty, use INCLUDING CONTENTS option
ORA-01550: cannot drop
system tablespace
ORA-01551: extended
rollback segment, pinned blocks released
ORA-01552: cannot use
system rollback segment for non-system tablespace ''
ORA-01553: MAXEXTENTS
must be no smaller than the extents currently allocated
ORA-01554: out of
transaction slots in transaction tables
ORA-01555: snapshot too
old: rollback segment number with name "" too small
ORA-01556: MINEXTENTS
for rollback segment must be greater than 1
ORA-01557: rollback
segment extents must be at least blocks
ORA-01558: out of
transaction ID's in rollback segment
ORA-01559: MAXEXTENTS
for rollback segment must be greater than 1
ORA-01560: LIKE pattern
contains partial or illegal character
ORA-01561: failed to
remove all objects in the tablespace specified
ORA-01562: failed to
extend rollback segment number
ORA-01563: rollback
segment is PUBLIC, need to use the keyword PUBLIC
ORA-01564: rollback
segment is not PUBLIC
ORA-01565: error in
identifying file ''
ORA-01566: file
specified more than once in ALTER DATABASE
ORA-01567: dropping log
would leave less than 2 log files for instance (thread )
ORA-01568: cannot set
space quota on PUBLIC
ORA-01569: data file too
small for system dictionary tables
ORA-01570: MINEXTENTS
must be no larger than the extents currently allocated
ORA-01571: redo version
incompatible with ORACLE version
ORA-01572: rollback
segment '' cannot be brought online, extents exceeded
ORA-01573: shutting down
instance, no further change allowed
ORA-01574: maximum
number of concurrent transactions exceeded
ORA-01575: timeout
waiting for space management resource
ORA-01576: The instance
is not enabled
ORA-01577: cannot add
log file '' - file already part of database
ORA-01578: ORACLE data
block corrupted (file # , block # )
ORA-01579: write error
occurred during recovery
ORA-01580: error
creating control backup file
ORA-01581: attempt to
use rollback segment () new extent () which is being allocated
ORA-01582: unable to
open control file for backup
ORA-01583: unable to get
block size of control file to be backed up
ORA-01584: unable to get
file size of control file to be backed up
ORA-01585: error
identifying backup file
ORA-01586: database must
be mounted EXCLUSIVE and not open for this operation
ORA-01587: error during
control file backup file copy
ORA-01588: must use
RESETLOGS option for database open
ORA-01589: must use
RESETLOGS or NORESETLOGS option for database open
ORA-01590: number of
segment free list () exceeds maximum of
ORA-01591: lock held by
in-doubt distributed transaction
ORA-01592: error
converting Version 7 rollback segment () to Oracle 8 format
ORA-01593: rollback
segment optimal size ( blks) is smaller than the computed initial size ( blks)
ORA-01594: attempt to
wrap into rollback segment () extent () which is being freed
ORA-01595: error freeing
extent () of rollback segment ())
ORA-01596: cannot
specify system in parameter
ORA-01597: cannot alter
system rollback segment online or offline
ORA-01598: rollback
segment '' is not online
ORA-01599: failed to
acquire rollback segment (), cache space is full
ORA-01600: at most one
"" in clause "" of
ORA-01601: illegal
bucket size in clause "" of
ORA-01603: illegal
grouping size in clause "" of
ORA-01604: illegal
number range in clause "" of
ORA-01605: missing
numbers in clause "" of
ORA-01606:
gc_files_to_locks not identical to that of another mounted instance
ORA-01607: cannot add
logfile to the specified instance
ORA-01608: cannot bring
rollback segment '' online, its status is ()
ORA-01609: log is the
current log for thread - cannot drop members
ORA-01610: recovery
using the BACKUP CONTROLFILE option must be done
ORA-01611: thread number
is invalid - must be between 1 and
ORA-01612: instance
(thread ) is already enabled
ORA-01613: instance
(thread ) only has logs - at least 2 logs required to enable.
ORA-01614: instance
(thread ) is busy - cannot enable
ORA-01615: instance
(thread ) is mounted - cannot disable
ORA-01616: instance
(thread ) is open - cannot disable
ORA-01617: cannot mount:
is not a valid thread number
ORA-01618: redo thread
is not enabled - cannot mount
ORA-01619: thread is
mounted by another instance
ORA-01620: no public
threads are available for mounting
ORA-01621: cannot rename
member of current log if database is open
ORA-01622: thread number
must be specified - default not specific
ORA-01623: log is
current log for instance (thread ) - cannot drop
ORA-01624: log needed
for crash recovery of instance (thread )
ORA-01625: rollback
segment '' does not belong to this instance
ORA-01626: rollback
segment number '' cannot handle more transactions
ORA-01627: rollback
segment number '' is not online
ORA-01628: max # extents
() reached for rollback segment
ORA-01629: max # extents
() reached saving undo for tablespace
ORA-01630: max # extents
() reached in temp segment in tablespace
ORA-01631: max # extents
() reached in table .
ORA-01632: max # extents
() reached in index .
ORA-01633: Real
Application Clusters Option needed for this operation
ORA-01634: rollback
segment number '' is about to go offline
ORA-01635: rollback
segment # specified not available
ORA-01636: rollback
segment '' is already online
ORA-01637: rollback
segment '' is being used by another instance (#)
ORA-01638: parameter
does not allow ORACLE version to mount cluster database
ORA-01639: instance has
no thread assigned to it
ORA-01640: cannot make
tablespace read only with active transactions
ORA-01641: tablespace ''
is not online - cannot add data file
ORA-01642: begin backup
not needed for read only tablespace ''
ORA-01643: system
tablespace can not be made read only
ORA-01644: tablespace ''
is already read only
ORA-01645: previous
attempt to make read write is half complete
ORA-01646: tablespace ''
is not read only - cannot make read write
ORA-01647: tablespace ''
is read only, cannot allocate space in it
ORA-01648: log is the
current log of disabled instance (thread )
ORA-01649: operation not
allowed with a backup control file
ORA-01650: unable to
extend rollback segment by in tablespace
ORA-01651: unable to
extend save undo segment by for tablespace
ORA-01652: unable to
extend temp segment by in tablespace
ORA-01653: unable to
extend table . by in tablespace
ORA-01654: unable to
extend index . by in tablespace
ORA-01655: unable to
extend cluster . by in tablespace
ORA-01656: max # extents
() reached in cluster .
ORA-01657: invalid
SHRINK option value
ORA-01658: unable to
create INITIAL extent for segment in tablespace
ORA-01659: unable to
allocate MINEXTENTS beyond in tablespace
ORA-01660: tablespace ''
is already permanent
ORA-01661: tablespace ''
is already temporary
ORA-01662: tablespace ''
is non-empty and cannot be made temporary
ORA-01663: the contents
of tablespace '' is constantly changing
ORA-01664: Transaction
which has expanded the Sort Segment has aborted
ORA-01665: control file
is not a standby control file
ORA-01666: control file
is for a standby database
ORA-01667: cannot add
any more tablespaces: limit of exceeded
ORA-01668: standby
database requires DROP option for offline of data file
ORA-01669: standby
database control file not consistent
ORA-01670: new datafile
needed for standby database recovery
ORA-01671: control file
is a backup, cannot make a standby control file
ORA-01672: control file
may be missing files or have extra ones
ORA-01673: data file has
not been identified
ORA-01674: data file is
an old incarnation rather than current file
ORA-01675:
max_commit_propagation_delay inconsistent with other instances
ORA-01676: standby file
name convert of '' exceeds maximum length of
ORA-01677: standby file
name convert parameters differ from other instance
ORA-01678: parameter
must be pairs of pattern and replacement strings
ORA-01679: database must
be mounted EXCLUSIVE and not open to activate
ORA-01680: unable to
extend LOB segment by in tablespace
ORA-01681: max # extents
() reached in LOB segment in tablespace
ORA-01682: read-only DB
cannot allocate temporary space in tablespace
ORA-01683: unable to
extend index . partition by in tablespace
ORA-01684: max # extents
() reached in table . partition
ORA-01685: max # extents
() reached in index . partition
ORA-01686: max # files
() reached for the tablespace
ORA-01687: specified
logging attribute for tablespace '' is same as the existing
ORA-01688: unable to
extend table . partition by in tablespace
ORA-01689: syntax error
in clause "" of
ORA-01690: sort area
size too small
ORA-01691: unable to
extend lob segment . by in tablespace
ORA-01692: unable to
extend lob segment . partition by in tablespace
ORA-01693: max # extents
() reached in lob segment .
ORA-01694: max # extents
() reached in lob segment . partition
ORA-01695: error
converting rollback segment to version 8.0.2
ORA-01696: control file
is not a clone control file
ORA-01697: control file
is for a clone database
ORA-01698: a clone
database may only have SYSTEM rollback segment online
ORA-01699: tablespace ''
is being imported for point in time recovery
ORA-01700: duplicate
username in list
ORA-01701: a cluster is
not appropriate here
ORA-01702: a view is not
appropriate here
ORA-01703: missing
SYNONYM keyword
ORA-01704: string
literal too long
ORA-01705: an outer join
cannot be specified on a correlation column
ORA-01706: user function
result value was too large
ORA-01707: missing LIST
keyword
ORA-01708: ACCESS or
SESSION expected
ORA-01709: program does
not exist
ORA-01710: missing OF
keyword
ORA-01711: duplicate
privilege listed
ORA-01712: you cannot
grant a privilege which you do not have
ORA-01713: GRANT OPTION
does not exist for that privilege
ORA-01714: error in
execution of user function
ORA-01715: UNIQUE may
not be used with a cluster index
ORA-01716: NOSORT may
not be used with a cluster index
ORA-01717: seccta:
invalid access mode token passed
ORA-01718: BY ACCESS |
SESSION clause not allowed for NOAUDIT
ORA-01719: outer join
operator (+) not allowed in operand of OR or IN
ORA-01720: grant option
does not exist for '.'
ORA-01721:
USERENV(COMMITSCN) invoked more than once in a transaction
ORA-01722: invalid
number
ORA-01723: zero-length
columns are not allowed
ORA-01724: floating
point precision is out of range (1 to 126)
ORA-01725:
USERENV('COMMITSCN') not allowed here
ORA-01726: a table is
not appropriate here
ORA-01727: numeric
precision specifier is out of range (1 to 38)
ORA-01728: numeric scale
specifier is out of range (-84 to 127)
ORA-01729: database link
name expected
ORA-01730: invalid
number of column names specified
ORA-01731: circular view
definition encountered
ORA-01732: data
manipulation operation not legal on this view
ORA-01733: virtual
column not allowed here
ORA-01734: illegal
parameters - EXTENT MIN higher than EXTENT MAX
ORA-01735: invalid ALTER
TABLE option
ORA-01736: [NOT]
SUCCESSFUL expected
ORA-01737: valid modes:
[ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE
ORA-01738: missing IN
keyword
ORA-01739: missing MODE
keyword
ORA-01740: missing
double quote in identifier
ORA-01741: illegal
zero-length identifier
ORA-01742: comment not
terminated properly
ORA-01743: only pure
functions can be indexed
ORA-01744: inappropriate
INTO
ORA-01745: invalid
host/bind variable name
ORA-01746: indicator
variable not permitted here
ORA-01747: invalid
user.table.column, table.column, or column specification
ORA-01748: only simple
column names allowed here
ORA-01749: you may not
GRANT/REVOKE privileges to/from yourself
ORA-01750:
UPDATE/REFERENCES may only be REVOKEd from the whole table, not by column
ORA-01751: Invalid dump
undo option
ORA-01752: cannot delete
from view without exactly one key-preserved table
ORA-01753: column
definition incompatible with clustered column definition
ORA-01754: a table may
contain only one column of type LONG
ORA-01755: Must specify
an extent number or block number
ORA-01756: quoted string
not properly terminated
ORA-01757: Must specify
an object number
ORA-01758: table must be
empty to add mandatory (NOT NULL) column
ORA-01759: user function
is incorrectly defined
ORA-01760: illegal
argument for function
ORA-01761: DML operation
does not map to a unique table in the join
ORA-01762: vopdrv: view
query block not in FROM
ORA-01763: update or
delete involves outer joined table
ORA-01764: new update
value of join is not guaranteed to be unique
ORA-01765: specifying
table's owner name is not allowed
ORA-01766: dictionary
table not allowed in this context
ORA-01767: UPDATE ...
SET expression must be a subquery
ORA-01768: number string
too long
ORA-01769: duplicate
CLUSTER option specifications
ORA-01770: CLUSTER
option not allowed in CREATE CLUSTER command
ORA-01771: illegal
option for a clustered table
ORA-01772: Must specify
a value for LEVEL
ORA-01773: may not
specify column datatypes in this CREATE TABLE
ORA-01774: Dump undo
option specified more than once
ORA-01775: looping chain
of synonyms
ORA-01776: cannot modify
more than one base table through a join view
ORA-01777: WITH GRANT
OPTION not allowed in this system
ORA-01778: maximum
subquery nesting level exceeded
ORA-00337: log file ''
does not exist and no size specified
ORA-00338: log of thread
is more recent than control file
ORA-00339: archived log
does not contain any redo
ORA-00340: IO error
processing online log of thread
ORA-00341: log of thread
, wrong log # in header
ORA-00342: archived log
does not have expected resetlogs SCN
ORA-00343: too many
errors, log member closed
ORA-00344: unable to
re-create online log ''
ORA-00345: redo log
write error block count
ORA-00346: log member
marked as STALE
ORA-00347: log of thread
, expected block size doesn't match
ORA-00348:
single-process redo failure. Must abort instance
ORA-00349: failure
obtaining block size for ''
ORA-00350: log of
instance (thread ) needs to be archived
ORA-00351: recover-to
time invalid
ORA-00352: all logs for
thread need to be archived - cannot enable
ORA-00353: log
corruption near block change time
ORA-00354: corrupt redo
log block header
ORA-00355: change
numbers out of order
ORA-00356: inconsistent
lengths in change description
ORA-00357: too many
members specified for log file, the maximum is
ORA-00358: Too many file
members specified, the maximum is
ORA-00359: logfile group
does not exist
ORA-00360: not a logfile
member:
ORA-00361: cannot remove
last log member for group
ORA-00362: member is required
to form a valid logfile in group
ORA-00363: log is not
the archived version
ORA-00364: cannot write
header to new log member
ORA-00365: the specified
log is not the correct next log
ORA-00366: log of thread
, checksum error in the file header
ORA-00367: checksum
error in log file header
ORA-00368: checksum
error in redo log block
ORA-00369: Current log
of thread not useable and other log being cleared
ORA-00370: potential
deadlock during kcbchange operation
ORA-00371: not enough
shared pool memory, should be atleast bytes
ORA-00372: file cannot
be modified at this time
ORA-00373: online log
version incompatible with ORACLE version
ORA-00374: parameter
db_block_size = invalid ; must be a multiple of in the range [..]
ORA-00375: unable to get
default db_block_size
ORA-00376: file cannot
be read at this time
ORA-00377: Frequent
backups of file causing write operation to stall
ORA-00378: buffer pools
cannot be created as specified
ORA-00379: no free
buffers available in buffer pool for block size K
ORA-00380: cannot
specify db_k_cache_size since K is the standard block size
ORA-00381: cannot use
both new and old parameters for buffer cache size specification
ORA-00382: not a valid block
size, valid range [..]
ORA-00383: DEFAULT cache
for blocksize cannot be reduced to zero
ORA-00384: Insufficient
memory to grow cache
ORA-00385: cannot enable
Very Large Memory with new buffer cache parameters
ORA-00386:
use_indirect_data_buffers not supported
ORA-00390: log of thread
is being cleared, cannot become current log
ORA-00391: All threads
must switch to new log format at the same time
ORA-00392: log of thread
is being cleared, operation not allowed
ORA-00393: log of thread
is needed for recovery of offline datafiles
ORA-00394: online log
reused while attempting to archive it
ORA-00395: online logs
for the clone database must be renamed
ORA-00396: error
required fallback to single-pass recovery
ORA-00397: instance
recovery process terminated with error
ORA-00398: abort thread
recovery due to reconfiguration
ORA-00399: corrupt
change description in redo log
ORA-00400: invalid
release value for parameter
ORA-00401: the value for
parameter is not supported by this release
ORA-00402: database
changes by release cannot be used by release
ORA-00403: () is not the
same as other instances ()
ORA-00404: Convert file
not found: ''
ORA-00405: compatibility
type ""
ORA-00406: COMPATIBLE
parameter needs to be or greater
ORA-00407: rolling
upgrade from release . to . is not allowed
ORA-00408: parameter is
set to TRUE
ORA-00409: COMPATIBLE
needs to be or higher to use AUTO SEGMENT SPACE MANAGEMENT
ORA-00436: ORACLE is not
licensed. Contact Oracle Corp. for assistance
ORA-00437: ORACLE feature
is not licensed. Contact Oracle Corp. for assistance
ORA-00438: Option not
installed
ORA-00439: feature not
enabled:
ORA-00443: background
process "" did not start
ORA-00444: background
process "" failed while starting
ORA-00445: background
process "" did not start after seconds
ORA-00446: background
process started when not expected
ORA-00447: fatal error
in background process
ORA-00448: normal
completion of background process
ORA-00449: background
process '' unexpectedly terminated with error
ORA-00450: background
process '' did not start
ORA-00451: foreground
process died unexpectedly
ORA-00452: foreground
process unexpectedly terminated with error
ORA-00453: backgroud
process '' is dead
ORA-00469: CKPT process
terminated with error
ORA-00470: LGWR process
terminated with error
ORA-00471: DBWR process
terminated with error
ORA-00472: PMON process
terminated with error
ORA-00473: ARCH process
terminated with error
ORA-00474: SMON process
terminated with error
ORA-00475: TRWR process
terminated with error
ORA-00476: RECO process
terminated with error
ORA-00477: SNP* process
terminated with error
ORA-00478: SMON process
terminated due to error
ORA-00479: RVWR process
terminated with error
ORA-00480: LCK* process
terminated with error
ORA-00481: LMON process
terminated with error
ORA-00482: LMD* process
terminated with error
ORA-00483: During
shutdown a process abnormally terminated
ORA-00484: LMS* process
terminated with error
ORA-00485: DIAG process
terminated with error
ORA-00486: ASMB process
terminated with error
ORA-00487: CTWR process
terminated with error
ORA-00488: RBAL process
terminated with error
ORA-00489: ARB* process
terminated with error
ORA-00490: PSP process
terminated with error
ORA-00494: enqueue held
for too long by ''
ORA-00566: cannot
request processor group - NUMA not enabled
ORA-00567: Requested
processor group is too large (maximum )
ORA-00568: Maximum
number of interrupt handlers exceeded
ORA-00569: Failed to
acquire global enqueue.
ORA-00574: osndnt:
$CANCEL failure (break)
ORA-00575: osndnt: $QIO
failure (send out-of-band break)
ORA-00576: in-band break
protocol error
ORA-00577: out-of-band
break protocol error
ORA-00578: reset
protocol error
ORA-00579: osndnt:
server received malformed connection request
ORA-00580: protocol
versions do not match
ORA-00581: osndnt:
cannot allocate context area
ORA-00582: osndnt:
cannot deallocate context area
ORA-00583: osndnt:
$TRNLOG failure
ORA-00584: cannot close
connection
ORA-00585: host name has
incorrect form
ORA-00586: osndnt:
LIB$ASN_WTH_MBX failure
ORA-00587: cannot
connect to remote host
ORA-00588: message from
host was too short
ORA-00589: message from
host had incorrect data length
ORA-00590: message from
host had incorrect message type
ORA-00591: incorrect
number of bytes written
ORA-00592: osndnt: $QIO
failure (mailbox queue)
ORA-00593: osndnt:
$DASSGN failure (network device)
ORA-00594: osndnt:
$DASSGN failure (mailbox)
ORA-00595: osndnt: $QIO
failure (receive)
ORA-00596: osndnt: $QIO
failure (send)
ORA-00597: osndnt: $QIO
failure (mailbox requeue)
ORA-00598: osndnt: $QIO
failure (mailbox read)
ORA-00600: internal
error code, arguments: [], [], [], [], [], [], [], []
ORA-00601: cleanup lock
conflict
ORA-00602: internal
programming exception
ORA-00603: ORACLE server
session terminated by fatal error
ORA-00604: error
occurred at recursive SQL level
ORA-00606: Internal
error code
ORA-00607: Internal
error occurred while making a change to a data block
ORA-00608: testing error
[] [] [] [] []
ORA-00609: could not
attach to incoming connection
ORA-00610: Internal
error code
ORA-00701: object
necessary for warmstarting database cannot be altered
ORA-00702: bootstrap
verison '' inconsistent with version ''
ORA-00703: maximum
number of row cache instance locks exceeded
ORA-00704: bootstrap
process failure
ORA-00705: inconsistent
state during start up; shut down the instance, then restart it
ORA-00706: error
changing format of file ''
ORA-00710: new
tablespace name is the same as the old tablespace name
ORA-00711: new
tablespace name is invalid
ORA-00712: cannot rename
system tablespace
ORA-00720: ALTER
DATABASE RESET COMPATIBILITY command has been de-supported
ORA-00721: changes by
release cannot be used by release
ORA-00722: Feature
""
ORA-00723:
Initialization parameter COMPATIBLE must be explicitly set
ORA-00724: ALTER
DATABASE CONVERT command has been de-supported
ORA-00740: datafile size
of () blocks exceeds maximum file size
ORA-00741: logfile size
of () blocks exceeds maximum logfile size
ORA-00750: database has
been previously mounted and dismounted
ORA-00816: error message
translation failed
ORA-00820: Specified
value of sga_max_size is too small, needs to be at least M
ORA-00821: Specified
value of sga_target M is too small, needs to be at least M
ORA-00822: MMAN process
terminated with error
ORA-00823: Specified
value of sga_target greater than sga_max_size
ORA-00824: cannot set sga_target
due to existing internal settings, see alert log for more information
ORA-00825: cannot set
db_block_buffers if sga_target set
ORA-00826: cannot set
sga_target for an ASM instance
ORA-00827: could not
shrink sga_target to specified value
ORA-00828: specified
value of shared_pool_reserved_size inconsistent with internal settings
ORA-00829: event to
stress test self tuning SGA feature by forcing partial granules transfers
ORA-00830: cannot set
statistics_level to BASIC with auto-tune SGA enabled
ORA-00831: event to
stress test self tuning SGA feature by doing random memory broker resizes
ORA-00832: no streams
pool created and cannot automatically create one
ORA-00833: event to test
cancellation and cache protection by pinning buffers for deferred mode requests
ORA-00900: invalid SQL
statement
ORA-00901: invalid
CREATE command
ORA-00902: invalid
datatype
ORA-00903: invalid table
name
ORA-00904: : invalid
identifier
ORA-00905: missing
keyword
ORA-00906: missing left
parenthesis
ORA-00907: missing right
parenthesis
ORA-00908: missing NULL
keyword
ORA-00909: invalid
number of arguments
ORA-00910: specified
length too long for its datatype
ORA-00911: invalid
character
ORA-00912: input
parameter too long
ORA-00913: too many
values
ORA-00914: missing ADD
keyword
ORA-00915: network
access of dictionary table not currently allowed
ORA-00917: missing comma
ORA-00918: column
ambiguously defined
ORA-00919: invalid
function
ORA-00920: invalid
relational operator
ORA-00921: unexpected
end of SQL command
ORA-00922: missing or
invalid option
ORA-00923: FROM keyword
not found where expected
ORA-00924: missing BY
keyword
ORA-00925: missing INTO
keyword
ORA-00926: missing
VALUES keyword
ORA-00927: missing equal
sign
ORA-00928: missing
SELECT keyword
ORA-00929: missing
period
ORA-00930: missing
asterisk
ORA-00931: missing
identifier
ORA-00932: inconsistent
datatypes: expected got
ORA-00933: SQL command
not properly ended
ORA-00934: group
function is not allowed here
ORA-00935: group
function is nested too deeply
ORA-00936: missing
expression
ORA-00937: not a
single-group group function
ORA-00938: not enough
arguments for function
ORA-00939: too many
arguments for function
ORA-00940: invalid ALTER
command
ORA-00941: missing
cluster name
ORA-00942: table or view
does not exist
ORA-00943: cluster does
not exist
ORA-00944: insufficient
number of clustered columns
ORA-00945: specified
clustered column does not exist
ORA-00946: missing TO
keyword
ORA-00947: not enough
values
ORA-00948: ALTER CLUSTER
statement no longer supported
ORA-00949: illegal
reference to remote database
ORA-00950: invalid DROP
option
ORA-00951: cluster not
empty
ORA-00952: missing GROUP
keyword
ORA-00953: missing or
invalid index name
ORA-00954: missing
IDENTIFIED keyword
ORA-00955: name is
already used by an existing object
ORA-00956: missing or
invalid auditing option
ORA-00957: duplicate
column name
ORA-00958: missing CHECK
keyword
ORA-00959: tablespace ''
does not exist
ORA-00960: ambiguous
column naming in select list
ORA-00961: bad
datetime/interval value
ORA-00962: too many
group-by / order-by expressions
ORA-00963: unsupported
interval type
ORA-00964: table name
not in FROM list
ORA-00965: column
aliases not allowed for '*'
ORA-00966: missing TABLE
keyword
ORA-00967: missing WHERE
keyword
ORA-00968: missing INDEX
keyword
ORA-00969: missing ON
keyword
ORA-00970: missing WITH
keyword
ORA-00971: missing SET
keyword
ORA-00972: identifier is
too long
ORA-00973: invalid row
count estimate
ORA-00974: invalid
PCTFREE value (percentage)
ORA-00975: date + date
not allowed
ORA-00976: LEVEL, PRIOR,
or ROWNUM not allowed here
ORA-00977: duplicate
auditing option
ORA-00978: nested group
function without GROUP BY
ORA-00979: not a GROUP
BY expression
ORA-00980: synonym
translation is no longer valid
ORA-00981: cannot mix
table and system auditing options
ORA-00982: missing plus
sign
ORA-00983: cannot audit
or noaudit SYS user actions
ORA-00984: column not
allowed here
ORA-00985: invalid
program name
ORA-00986: missing or
invalid group name(s)
ORA-00987: missing or
invalid username(s)
ORA-00988: missing or
invalid password(s)
ORA-00989: too many
passwords for usernames given
ORA-00990: missing or
invalid privilege
ORA-00991: only MAC
privileges may be granted to procedures
ORA-00992: invalid
format for REVOKE command
ORA-00993: missing GRANT
keyword
ORA-00994: missing
OPTION keyword
ORA-00995: missing or
invalid synonym identifier
ORA-00996: the
concatenate operator is ||, not |
ORA-00997: illegal use
of LONG datatype
ORA-00998: must name
this expression with a column alias
ORA-00999: invalid view
name
ORA-01000: maximum open
cursors exceeded
ORA-01001: invalid
cursor
ORA-01002: fetch out of
sequence
ORA-01003: no statement
parsed
ORA-01004: default
username feature not supported; logon denied
ORA-01005: null password
given; logon denied
ORA-01006: bind variable
does not exist
ORA-01007: variable not
in select list
ORA-01008: not all
variables bound
ORA-01009: missing
mandatory parameter
ORA-01010: invalid OCI
operation
ORA-01011: Cannot use v7
compatibility mode when talking to v6 server
ORA-01012: not logged on
ORA-01013: user
requested cancel of current operation
ORA-01014: ORACLE
shutdown in progress
ORA-01015: logon called
recursively
ORA-01016: This function
can be called only after a fetch
ORA-01017: invalid
username/password; logon denied
ORA-01018: column does
not have a LONG datatype
ORA-01019: unable to allocate
memory in the user side
ORA-01020: unknown
context state
ORA-01021: invalid
context size specified
ORA-01022: database
operation not supported in this configuration
ORA-01023: Cursor
context not found (Invalid cursor number)
ORA-01024: invalid
datatype in OCI call
ORA-01025: UPI parameter
out of range
ORA-01026: multiple
buffers of size > 4000 in the bind list
ORA-01027: bind
variables not allowed for data definition operations
ORA-01028: internal two
task error
ORA-01029: internal two
task error
ORA-01030: SELECT ...
INTO variable does not exist
ORA-01031: insufficient
privileges
ORA-01032: no such
userid
ORA-01033: ORACLE
initialization or shutdown in progress
ORA-01034: ORACLE not
available
ORA-01035: ORACLE only
available to users with RESTRICTED SESSION privilege
ORA-01036: illegal
variable name/number
ORA-01037: maximum
cursor memory exceeded
ORA-01038: cannot write
database file version with ORACLE version
ORA-01039: insufficient
privileges on underlying objects of the view
ORA-01040: invalid character
in password; logon denied
ORA-01041: internal
error. hostdef extension doesn't exist
ORA-01042: detaching a
session with open cursors not allowed
ORA-01043: user side
memory corruption [], [], [], []
ORA-01044: size of
buffer bound to variable exceeds maximum
ORA-01045: user lacks
CREATE SESSION privilege; logon denied
ORA-01046: cannot
acquire space to extend context area
ORA-01047: The above
error occurred in schema=, package=, procedure=
ORA-01048: Couldn't find
the specified procedure in the given context
ORA-01049: Bind by name
is not spupportted in streamed RPC
ORA-01050: cannot
acquire space to open context area
ORA-01051: deferred rpc
buffer format invalid
ORA-01052: required
destination LOG_ARCHIVE_DUPLEX_DEST is not specified
ORA-01053: user storage
address cannot be read
ORA-01054: user storage
address cannot be written
ORA-01057: invalid or
ambiguous block.field reference in user exit
ORA-01058: internal New
Upi interface error
ORA-01059: parse
expected before a bind or execute
ORA-01060: array binds
or executes not allowed
ORA-01061: cannot start
up a V8 server using a V7 client application
ORA-01062: unable to
allocate memory for define buffer
ORA-01070: Using an old
version of Oracle for the server
ORA-01071: cannot
perform operation without starting up ORACLE
ORA-01072: cannot stop
ORACLE; ORACLE not running
ORA-01073: fatal
connection error: unrecognized call type
ORA-01074: cannot shut
down ORACLE; inside a login session - log off first
ORA-01075: you are
currently logged on
ORA-01076: multiple
logons per process not yet supported
ORA-01077: background
process initialization failure
ORA-01078: failure in
processing system parameters
ORA-01079: ORACLE
database was not properly created, operation aborted
ORA-01080: error in
shutting down ORACLE
ORA-01081: cannot start
already-running ORACLE - shut it down first
ORA-01082: 'row_locking
= always' requires the transaction processing option
ORA-01083: value of
parameter "" is inconsistent with that of other instances
ORA-01084: invalid
argument in OCI call
ORA-01085: preceding
errors in deferred rpc to ".."
ORA-01086: savepoint ''
never established
ORA-01087: cannot start
up ORACLE - currently logged on
ORA-01088: cannot shut
down ORACLE while active processes exist
ORA-01089: immediate
shutdown in progress - no operations are permitted
ORA-01090: shutdown in
progress - connection is not permitted
ORA-01091: failure
during startup force
ORA-01092: ORACLE
instance terminated. Disconnection forced
ORA-01093: ALTER
DATABASE CLOSE only permitted with no sessions connected
ORA-01094: ALTER
DATABASE CLOSE in progress. Connections not permitted
ORA-01095: DML statement
processed zero rows
ORA-01096: program version
() incompatible with instance ()
ORA-01097: cannot
shutdown while in a transaction - commit or rollback first
ORA-01098: program
Interface error during Long Insert
ORA-01099: cannot mount
database in SHARED mode if started in single process mode
ORA-01100: database
already mounted
ORA-01101: database
being created currently mounted by some other instance
ORA-01102: cannot mount
database in EXCLUSIVE mode
ORA-01103: database name
'' in control file is not ''
ORA-01104: number of
control files () does not equal
ORA-01105: mount is
incompatible with mounts by other instances
ORA-01106: database must
be closed before dismounting
ORA-01107: database must
be mounted for media recovery
ORA-01108: file is in
backup or media recovery
ORA-01109: database not
open
ORA-01110: data file :
''
ORA-01111: name for data
file is unknown - rename to correct file
ORA-01112: media
recovery not started
ORA-01113: file needs
media recovery
ORA-01114: IO error
writing block to file (block # )
ORA-01115: IO error
reading block from file (block # )
ORA-01116: error in
opening database file
ORA-01117: adding file
'' with illegal block size: ; limit is
ORA-01118: cannot add
any more database files: limit of exceeded
ORA-01119: error in
creating database file ''
ORA-01120: cannot remove
online database file
ORA-01121: cannot rename
database file - file is in use or recovery
ORA-01122: database file
failed verification check
ORA-01123: cannot start
online backup; media recovery not enabled
ORA-01124: cannot
recover data file - file is in use or recovery
ORA-01125: cannot
disable media recovery - file has online backup set
ORA-01126: database must
be mounted in this instance and not open in any instance
ORA-01127: database name
'' exceeds size limit of characters
ORA-01128: cannot start
online backup - file is offline
ORA-01129: user's
default or temporary tablespace does not exist
ORA-01130: database file
version incompatible with ORACLE version
ORA-01131: DB_FILES
system parameter value exceeds limit of
ORA-01132: length of
database file name '' exceeds limit of characters
ORA-01133: length of log
file name '' exceeds limit of characters
ORA-01134: database
mounted exclusive by another instance
ORA-01135: file accessed
for DML/query is offline
ORA-01136: specified
size of file ( blocks) is less than original size of blocks
ORA-01137: data file is
still in the middle of going offline
ORA-01138: database must
either be open in this instance or not at all
ORA-01139: RESETLOGS
option only valid after an incomplete database recovery
ORA-01140: cannot end
online backup - all files are offline or readonly
ORA-01141: error
renaming data file - new file '' not found
ORA-01142: cannot end
online backup - none of the files are in backup
ORA-01143: cannot
disable media recovery - file needs media recovery
ORA-01144: File size (
blocks) exceeds maximum of blocks
ORA-01145: offline
immediate disallowed unless media recovery enabled
ORA-01146: cannot start
online backup - file is already in backup
ORA-01147: SYSTEM
tablespace file is offline
ORA-01148: cannot
refresh file size for datafile
ORA-01149: cannot
shutdown - file has online backup set
ORA-01150: cannot
prevent writes - file has online backup set
ORA-01151: use media
recovery to recover block, restore backup if needed
ORA-01152: file was not
restored from a sufficiently old backup
ORA-01153: an
incompatible media recovery is active
ORA-01154: database
busy. Open, close, mount, and dismount not allowed now
ORA-01155: the database
is being opened, closed, mounted or dismounted
ORA-01156: recovery in
progress may need access to files
ORA-01157: cannot
identify/lock data file - see DBWR trace file
ORA-01158: database
already mounted
ORA-01159: file is not
from same database as previous files - wrong database id
ORA-01160: file is not a
ORA-01161: database name
in file header does not match given name of
ORA-01162: block size in
file header does not match configured block sizes
ORA-01163: SIZE clause
indicates (blocks), but should match header
ORA-01164: MAXLOGFILES
may not exceed
ORA-01165: MAXDATAFILES
may not exceed
ORA-01166: file number
is larger than ()
ORA-01167: two files are
the same file/group number or the same file
ORA-01168: physical
block size does not match size of other members
ORA-01169: DATAFILE
number 1 not found. Must be present
ORA-01170: file not
found ''
ORA-01171: datafile
going offline due to error advancing checkpoint
ORA-01172: recovery of
thread stuck at block of file
ORA-01173: data
dictionary indicates missing data file from system tablespace
ORA-01174: DB_FILES is
buts needs to be to be compatible
ORA-01175: data
dictionary has more than the files allowed by the instance
ORA-01176: data
dictionary has more than the files allowed by the controlfie
ORA-01177: data file
does not match dictionary - probably old incarnation
ORA-01178: file created
before last CREATE CONTROLFILE, cannot recreate
ORA-01179: file does not
exist
ORA-01180: can not
create datafile 1
ORA-01181: file created before
last known RESETLOGS, cannot recreate
ORA-01182: cannot create
database file - file is in use or recovery
ORA-01183: cannot mount
database in SHARED mode
ORA-01184: logfile group
already exists
ORA-01185: logfile group
number is invalid
ORA-01186: file failed
verification tests
ORA-01187: cannot read
from file because it failed verification tests
ORA-01188: Block size in
header does not match physical block size
ORA-01189: file is from
a different RESETLOGS than previous files
ORA-01190: control file
or data file is from before the last RESETLOGS
ORA-01191: file is
already offline - cannot do a normal offline
ORA-01192: must have at
least one enabled thread
ORA-01193: file is not
the same file seen at start of recovery
ORA-01194: file needs
more recovery to be consistent
ORA-01195: online backup
of file needs more recovery to be consistent
ORA-01196: file is
inconsistent due to a failed media recovery session
ORA-01197: thread only
contains one log
ORA-01198: must specify
size for log file if RESETLOGS
ORA-01199: file is not
in online backup mode
ORA-01200: actual file
size of is smaller than correct size of blocks
ORA-01201: file header
failed to write correctly
ORA-01202: wrong
incarnation of this file - wrong creation time
ORA-01203: wrong
incarnation of this file - wrong creation SCN
ORA-01204: file number
is rather than - wrong file
ORA-01205: not a data
file - type number in header is
ORA-01206: file is not
part of this database - wrong database id
ORA-01207: file is more
recent than control file - old control file
ORA-01208: data file is
an old version - not accessing current version
ORA-01209: data file is
from before the last RESETLOGS
ORA-01210: data file
header is media corrupt
ORA-01211: Oracle7 data
file is not from migration to Oracle8
ORA-01212: MAXLOGMEMBERS
may not exceed
ORA-01213: MAXINSTANCES
may not exceed
ORA-01214: MAXLOGHISTORY
may not exceed
ORA-01215: enabled
thread is missing after CREATE CONTROLFILE
ORA-01216: thread is
expected to be disabled after CREATE CONTROLFILE
ORA-01217: logfile
member belongs to a different logfile group
ORA-01218: logfile
member is not from the same point-in-time
ORA-01219: database not
open: queries allowed on fixed tables/views only
ORA-01220: file based
sort illegal before database is open
ORA-01221: data file is
not the same file to a background process
ORA-01222: MAXINSTANCES
of requires MAXLOGFILES be at least , not
ORA-01223: RESETLOGS
must be specified to set a new database name
ORA-01224: group number
in header does not match GROUP
ORA-01225: thread number
is greater than MAXINSTANCES
ORA-01226: file header
of log member is inconsistent with other members
ORA-01227: log is
inconsistent with other logs
ORA-01228: SET DATABASE
option required to install seed database
ORA-01229: data file is
inconsistent with logs
ORA-01230: cannot make
read only - file is offline
ORA-01231: cannot make
read write - file is offline
ORA-01232: cannot start
online backup - file is being made read-only
ORA-01233: file is read
only - cannot recover using backup control file
ORA-01234: cannot end
backup of file - file is in use or recovery
ORA-01235: END BACKUP
failed for file(s) and succeeded for
ORA-01236: Error
occurred during initialization of file header access
ORA-01237: cannot extend
datafile
ORA-01238: cannot shrink
datafile
ORA-01239: database must
be in ARCHIVELOG mode to use external cache
ORA-01240: too many data
files to add in one command
ORA-01241: an external
cache has died
ORA-01242: data file
suffered media failure: database in NOARCHIVELOG mode
ORA-01243: system
tablespace file suffered media failure
ORA-01244: unnamed
datafile(s) added to control file by media recovery
ORA-01245: offline file
will be lost if RESETLOGS is done
ORA-01246: recovering
files through TSPITR of tablespace
ORA-01247: database
recovery through TSPITR of tablespace
ORA-01248: file was
created in the future of incomplete recovery
ORA-01249: archiving not
allowed in a clone database
ORA-01250: Error
occurred during termination of file header access
ORA-01251: Unknown File
Header Version read for file number
ORA-01252: cannot
prevent writes - file in recovery manager backup
ORA-01253: cannot start
online backup - file in recovery manager backup
ORA-01254: cannot end
online backup - file in recovery manager backup
ORA-01255: cannot
shutdown - file in recovery manager backup
ORA-01256: error in
locking database file
ORA-01257: cannot reuse
database file , unknown file size
ORA-01258: unable to
delete temporary file
ORA-01259: unable to
delete datafile
ORA-01260: warning: END
BACKUP succeeded but some files found not to be in backup mode
ORA-01261: Parameter
destination string cannot be translated
ORA-01262: Stat failed
on a file destination directory
ORA-01263: Name given
for file destination directory is invalid
ORA-01264: Unable to
create file name
ORA-01265: Unable to
delete
ORA-01266: Unable to
create unique file name
ORA-01267: Failure
getting date/time
ORA-01268: invalid
TEMPFILE clause for alter of permanent TABLESPACE
ORA-01269: Destination
parameter string is too long
ORA-01270: operation is
not allowed if STANDBY_PRESERVES_NAMES is true
ORA-01271: Unable to
create new file name for file
ORA-01272: REUSE only
allowed when a file name is provided.
ORA-01273:
STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = or higher
ORA-01274: cannot add
datafile '' - file could not be created
ORA-01275: Operation is
not allowed if standby file management is automatic.
ORA-01276: Cannot add
file . File has an Oracle Managed Files file name.
ORA-01277: file ''
already exists
ORA-01278: error
creating file ''
ORA-01279: db_files too
large
ORA-01280: Fatal
LogMiner Error.
ORA-01281: SCN range
specified is invalid
ORA-01282: date range
specified is invalid
ORA-01283: Options
specified is invalid
ORA-01284: file cannot
be opened
ORA-01285: error reading
file
ORA-01286: start
interval required
ORA-01287: file is from
a different database incarnation
ORA-01289: cannot add
duplicate logfile
ORA-01290: cannot remove
unlisted logfile
ORA-01291: missing
logfile
ORA-01292: no log file
has been specified for the current LogMiner session
ORA-01293: mounted
database required for specified LogMiner options
ORA-01294: error
occurred while processing information in dictionary file , possible corruption
ORA-01295: DB_ID
mismatch between dictionary and logfiles
ORA-01296: character set
mismatch between dictionary and logfiles
ORA-01297: redo version
mismatch between dictionary and logfiles
ORA-01298: conflicting
dictionary option
ORA-01299: dictionary
corresponds to a different database incarnation
ORA-01300: writable
database required for specified LogMiner options
ORA-01301: error writing
to file during flat file build
ORA-01302: dictionary
build options missing or incorrect
ORA-01303: subordinate
process error: %u. Check alert and trace logs
ORA-01304: subordinate
process error. Check alert and trace logs
ORA-01306: dbms_logmnr.start_logmnr()
must be invoked before selecting from v$logmnr_contents
ORA-01307: no LogMiner
session is currently active
ORA-01308:
initialization parameter utl_file_dir is not set
ORA-01309: invalid
session
ORA-01310: requested
return type not supported by the lcr_mine function
ORA-01311: Illegal
invocation of the mine_value function
ORA-01312: Specified
table/column does not exist
ORA-01313: LogMiner
dictionary column type different from specified type
ORA-01314: Name of the
column to be mined should be a string literal
ORA-01315: Log file has
been added or removed during select
ORA-01316: Already
attached to a Logminer session
ORA-01317: Not attached
to a Logminer session
ORA-01319: Invalid
Logminer session attribute
ORA-01320: Invalid
Logminer dictionar attribute
ORA-01322: No such table
ORA-01323: Invalid state
ORA-01324: cannot add
file due to DB_ID mismatch
ORA-01325: archive log
mode must be enabled to build into the logstream
ORA-01326: compatability
of 9.0 or greater required to build into the logstream
ORA-01327: failed to
exclusively lock system dictionary as required by build
ORA-01328: only one
build operation may occur at one time
ORA-01329: unable to
truncate required build table
ORA-01330: problem
loading a required build table
ORA-01331: general error
while running build
ORA-01332: internal
Logminer Dictionary error
ORA-01333: failed to
establish Logminer Dictionary
ORA-01334: invalid or
missing logminer dictionary processes context
ORA-01335: feature not
yet implemented
ORA-01336: specified
dictionary file cannot be opened
ORA-01337: log file has
a different compatibility version
ORA-01338: Other process
is attached to LogMiner session
ORA-01339: LogMiner
BUILD: Error copying system catalog metadata to LogMiner dictionary
ORA-01340: NLS error
ORA-01341: LogMiner
out-of-memory
ORA-01342: LogMiner can
not resume session due to inability of staging checkpointed data
ORA-01343: LogMiner
encountered corruption in the logstream
ORA-01344: LogMiner
coordinator already attached
ORA-01345: must be a
LogMiner coordinator process
ORA-01346: LogMiner
processed redo beyond specified reset log scn
ORA-01347: Supplemental
log data no longer found
ORA-01348: LogMiner
testing event
ORA-01349: LogMiner
tracing event
ORA-01350: must specify
a tablespace name
No comments:
Post a Comment