Lookup Oracle Error Code
ORA-
All Oracle Error Numbers
Home
Products
DbaBar
Oracle administration made easy
OraSpy
Simple Oracle monitoring
Oracle Locator Express
The Oracle Home Selector Replacement
Oracle Password Changer
Change (expired) passwords
Oracle Listener Remover
Remove obsolete Listeners on Windows
Actions
Download
Download Free Products and Trials
Buy Licenses
Buy an official license
Support
Get support for our products
Oracle Error Codes
Oracle Error Messages Explained
DbMotive
About Us
Everything you want to know about us
News
Jan 27th: New Oracle Locator Express Release
Sitemap
Browse our website
Oracle error codes from ORA-1 until ORA-100
ORA-101..ORA-200 >>
ORA-00001: unique constraint (%s.%s) violated
EXP-00001: buffer size=%lu actual size=%lu
IMP-00001: RETURN or '.' to quit
LDR-00001: SQL*Loader-%03d:
DBV-00001: Illegal command line syntax - parse error = (%d)
EXP-00002: error in writing to export file
IMP-00002: failed to open %s for read
LDR-00002: SQL*Loader-%03d:
DBV-00002: Illegal START (%d) or END (%d) value
EXP-00003: %lu)
IMP-00003: ORACLE error %lu encountered
DBV-00003: Illegal BLOCKSIZE (%d) value
EXP-00004: invalid username or password
IMP-00004: invalid username or password\\n
DBV-00004: FILE must be specified
EXP-00005: all allowable logon attempts failed
IMP-00005: all allowable logon attempts failed
DBV-00005: FILE must not be specified
EXP-00006: internal inconsistency error
IMP-00006: failed to allocate memory of size %lu
DBV-00006: or BLOCKSIZE must not be specified
EXP-00007: dictionary shows no columns for %s.%s
IMP-00007: must be a DBA to import objects to another user's account
DBV-00007: SEGMENT_ID must be specified
EXP-00008: ORACLE error %lu encountered
IMP-00008: unrecognized statement in the export file: \\n %s
DBV-00008: USERID must be specified for OSM files
EXP-00009: no privilege to export %s's table %s
IMP-00009: abnormal end of export file
DBV-00009: Illegal highest block scn number specified
EXP-00010: %s is not a valid username
IMP-00010: header failed verification
EXP-00011: %s.%s does not exist
IMP-00011: formatted table data not currently supported
EXP-00012: %s is not a valid export mode
IMP-00012: invalid export mode (%c) in header
EXP-00013: RETURN or '.' to quit
IMP-00013: only a DBA can import a file exported by another DBA
EXP-00014: error on row %lu of table %s\\n
IMP-00014: but not present in database
EXP-00015: datatype %lu
IMP-00015: following statement failed because the object already exists:
EXP-00016: ORACLE error encountered while reading default auditing options
IMP-00016: required character set conversion (type %lu to %lu) not supported
ORA-00017: session requested to set trace event
EXP-00017: but not present in database
IMP-00017: following statement failed with ORACLE error %lu:
ORA-00018: maximum number of sessions exceeded
EXP-00018: table %s.%s is not supported
IMP-00018: partial import of previous table completed: %lu rows imported
ORA-00019: maximum number of session licenses exceeded
EXP-00019: type 'EXP HELP=Y' for help
IMP-00019: row rejected due to ORACLE error %lu
ORA-00020: maximum number of processes (%s) exceeded
EXP-00020: failed to allocate memory of size %lu
IMP-00020: long column too large for column buffer size (%lu)
ORA-00021: session attached to some other process; cannot switch session
EXP-00021: can only perform incremental export in Full Database mode
IMP-00021: INCTYPE parameter is obsolete
ORA-00022: invalid session ID; access denied
EXP-00022: must be SYS or SYSTEM to do incremental export
IMP-00022: type 'IMP HELP=Y' for help
ORA-00023: session references process private memory; cannot detach session
EXP-00023: must be a DBA to do Full Database or Tablespace export
IMP-00023: please notify your DBA
ORA-00024: logins from more than one process not allowed in single-process mode
EXP-00024: please notify your DBA
IMP-00024: or FULL) can be specified
ORA-00025: failed to allocate %s
EXP-00025: dictionary shows no column for constraint %s.%lu
IMP-00025: FROMUSER must be specified with TOUSER option
ORA-00026: missing or invalid session ID
EXP-00026: conflicting modes specified
ORA-00027: cannot kill current session
EXP-00027: failed to calculate ORACLE block size
IMP-00027: failed to rollback partial import of previous table
ORA-00028: your session has been killed
EXP-00028: failed to open %s for write
IMP-00028: partial import of previous table rolled back: %lu rows rolled back
ORA-00029: session is not a user session
EXP-00029: Incremental export mode and consistent mode are not compatible
IMP-00029: use FROMUSER parameter
ORA-00030: User session ID does not exist.
EXP-00030: Unexpected End-Of-File encountered while reading input
IMP-00030: failed to create file %s for write
ORA-00031: session marked for kill
EXP-00031: Arraysize not in valid range. Using arraysize=%u
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
ORA-00032: invalid session migration password
EXP-00032: Non-DBAs may not export other users
IMP-00032: SQL statement exceeded buffer length
ORA-00033: current session has empty migration password
EXP-00033: Could not find environment character set
IMP-00033: Warning: Table \\"%s\\" not found in export file
ORA-00034: cannot %s in current PL/SQL session
EXP-00034: error on rowid: file# %lu block# %lu slot# %lu
IMP-00034: Warning: FromUser \\"%s\\" not found in export file
ORA-00035: LICENSE_MAX_USERS cannot be less than current number of users
EXP-00035: QUERY parameter valid only for table mode exports
IMP-00035: input file %s must be on a disk
ORA-00036: maximum number of recursive SQL levels (%s) exceeded
EXP-00036: Object %lu non-existent in dictionary
IMP-00036: Could not find environment character set
ORA-00037: cannot switch to a session belonging to a different server group
EXP-00037: Export views not compatible with database version
IMP-00037: Character set marker unknown
ORA-00038: Cannot create session: server group belongs to another user
EXP-00038: Bad Hash cluster id in clu$
IMP-00038: Could not convert to environment character set's handle
EXP-00039: export file %s must be on a disk
IMP-00039: VOLSIZE does not match the value used for export: %s
ORA-00039: error during periodic action
ORA-00040: active time limit exceeded - call aborted
EXP-00040: Dump file and log file must be different
IMP-00040: FILESIZE does not match the value used for export: %s
ORA-00041: active time limit exceeded - session terminated
EXP-00041: INCTYPE parameter is obsolete
IMP-00041: Warning: object created with compilation warnings
ORA-00042: Unknown Service name %s
EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$
IMP-00042: but the export file has specific character set
EXP-00043: Invalid data dictionary information in the row where column \\"%s\\" is \\"%s\\" in table %s
IMP-00043: export file character set inconsistent
ORA-00043: remote operation failed
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
IMP-00044: unable to allocate enough memory for statement
EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace
IMP-00045: using VOLSIZE value from export file of %s
EXP-00046: Tablespace named %s does not exist
IMP-00046: using FILESIZE value from export file of %s
EXP-00047: Missing tablespace name(s)
IMP-00047: unexpected file sequence number; expected %u but found %u
EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace
IMP-00048: mismatched file header
EXP-00049: %s option is not compatible with Point-in-time Recovery or Transportable Tablespace Export
IMP-00049: Unknown language specified in CHARSET
ORA-00050: operating system error occurred while obtaining an enqueue
IMP-00050: Dump file and log file cannot be identical
EXP-00050: Cannot perform Partition Export "%s" on non-partitioned table "%s
ORA-00051: timeout occurred while waiting for a resource
IMP-00051: Direct path exported dump file contains illegal column length
EXP-00051: \\"%s\\" - given partition or subpartition name is not part of \\"%s\\" table
IMP-00052: Warning: Unable to set event for freelist communication with server
ORA-00052: maximum number of enqueue resources (%s) exceeded
EXP-00052: error on row %lu of partition %s\\n
IMP-00053: Import mode incompatible with Export dump file
ORA-00053: maximum number of enqueues exceeded
EXP-00053: unable to execute QUERY on table %s because the table has inner nested tables
IMP-00054: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
EXP-00054: error on row %lu of subpartition %s\\n
ORA-00054: resource busy and acquire with NOWAIT specified
IMP-00055: Warning: partition or subpartition \\"%s\\":\\"%s\\" not found in export file
ORA-00055: maximum number of DML locks exceeded
EXP-00055: %s.%s is marked not exportable
ORA-00056: DDL lock on object '%s.%s' is already held in an incompatible mode
IMP-00056: multiple devices specified for tape input
EXP-00056: placeholder for OCI error
IMP-00057: Warning: Dump file may not contain data of all partitions of this table
ORA-00057: maximum number of temporary table locks exceeded
EXP-00057: Failure to initialize parameter manager
EXP-00058: Password Verify Function for %s profile does not exist
IMP-00058: placeholder for OCI error
ORA-00058: DB_BLOCK_SIZE must be %s to mount this database (not %s)
EXP-00059: error converting an object type's identifier to characters
ORA-00059: maximum number of DB_FILES exceeded
IMP-00059: Failure to initialize parameter manager
IMP-00060: Warning: Skipping table \\"%s\\".\\"%s\\" because object type \\"%s\\".\\"%s\\" does not exist or has different identifier
EXP-00060: an object type had multiple TYPE BODYs
ORA-00060: deadlock detected while waiting for resource
EXP-00061: unable to find the outer table name of a nested table
IMP-00061: Warning: Object type \\"%s\\".\\"%s\\" already exists with a different identifier
ORA-00061: another instance has a different DML_LOCKS setting
EXP-00062: invalid source statements for an object type
IMP-00062: Warning: The identifier on the dump file for object type \\"%s\\".\\"%s\\" is invalid
ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0
IMP-00063: Warning: Skipping table \\"%s\\".\\"%s\\" because object type \\"%s\\".\\"%s\\" cannot be created or has different identifier
ORA-00063: maximum number of log files exceeded %s
EXP-00063: error in changing language handle
EXP-00064: %s is an inner nested table and cannot be exported.
IMP-00064: Definition of LOB was truncated by export
ORA-00064: object is too large to allocate on this O/S (%s,%s)
IMP-00065: Import is unable to recreate lobs within objects.
EXP-00065: Error writing lob to the dump file.
ORA-00065: initialization of FIXED_DATE failed
IMP-00066: Missing NLS_CHARACTERSET in props$
EXP-00066: Object table %s is missing its object identifier index
ORA-00067: invalid value %s for parameter %s; must be at least %s
IMP-00067: Could not convert to server character set's handle
EXP-00068: tablespace %s is offline
IMP-00068: Could not find environment national character set
ORA-00068: invalid value %s for parameter %s, must be between %s and %s
IMP-00069: Could not convert to environment national character set's handle
ORA-00069: cannot acquire lock -- table locks disabled for %s
EXP-00069: placeholder for column level ORA error
IMP-00070: Lob definitions in dump file are inconsistent with database.
EXP-00070: attempt to free unallocated memory
ORA-00070: command %s is not valid
IMP-00071: Object identifier of imported table mismatches object identifier of existing table
EXP-00071: QUERY parameter not compatible with Direct Path export
ORA-00071: process number must be between 1 and %s
IMP-00072: Warning: The object table's object identifier is invalid.
EXP-00072: error closing export file %s
ORA-00072: process \\"%s\\" is not active
IMP-00073: FILE locator \\"%.*s\\" \\"%.*s\\" is truncated to \\"%.*s\\" \\"%.*s\\" in server character set
EXP-00073: dump file size too small
ORA-00073: command %s takes between %s and %s argument(s)
IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.
EXP-00074: new value is %s
ORA-00074: no process has been specified
IMP-00075: Warning: The nested table may contain partial rows or duplicate rows
EXP-00075: new value is %s
ORA-00075: process \\"%s\\" not found in this instance
IMP-00076: Missing NLS_NCHAR_CHARACTERSET in props$
EXP-00076: multiple devices specified for tape output
ORA-00076: dump %s not found
IMP-00077: Could not convert to server national character set's handle
EXP-00077: multiple output files specified for unbounded export file
ORA-00077: dump %s is not valid
IMP-00078: Cannot translate FILE locator to \\"%.*s\\" \\"%.*s\\" in server character set
EXP-00078: Error exporting metadata for index %s. Index creation will be skipped
ORA-00078: cannot dump variables by name
IMP-00079: Warning: National character set data in this table may be incorrect
EXP-00079: Data in table \\"%s\\" is protected. Conventional path may only be exporting partial table.
ORA-00079: variable %s not found
IMP-00080: Error during character conversion of long column or long command
EXP-00080: Data in table \\"%s\\" is protected. Using conventional mode.
ORA-00080: invalid global area specified by level %s
IMP-00081: attempt to free unallocated memory
EXP-00081: Exporting access control for table/view \\"%s\\" as non-DBA.
ORA-00081: address range [%s, %s) is not readable
IMP-00082: Error during conversion ROWID from string format to internal
EXP-00082: Invalid function name passed to procedural object support: %s
ORA-00082: memory size of %s is not in valid set of [1], [2], [4]%s%s%s%s%s
IMP-00083: dump file does not contain an incremental export
EXP-00083: The previous problem occurred when calling %s.%s.%s
ORA-00083: warning: possibly corrupt SGA mapped
IMP-00084: attempt to mix incremental import with user or table import
EXP-00084: Unexpected DbmsJava error %d at step %u
ORA-00084: global area must be PGA, SGA, or UGA
IMP-00085: multiple input files specified for unbounded export file
EXP-00085: The previous problem occurred when calling %s.%s.%s for object %lu
ORA-00085: current call does not exist
IMP-00086: TOID \\"%s\\" not found in export file
EXP-00086: Primary key REFs in table \\"%s\\"may not be valid on import
ORA-00086: user call does not exist
IMP-00087: Problem with internal hash table of schema/table names
EXP-00087: Problem with internal hash table of schema/table names
ORA-00087: command cannot be executed on remote instance
EXP-00088: just signal error
ORA-00088: command cannot be executed by shared server
IMP-00088: Problem importing metadata for index %s. Index creation will be skipped
EXP-00089: invalid FILE_FORMAT specification
ORA-00089: invalid instance number in ORADEBUG command
IMP-00089: Fine grain policy \\"%s\\" not recreated on table/view \\"%s\\"
EXP-00090: cannot pin type "%s"."%s
ORA-00090: failed to allocate memory for cluster database ORADEBUG command
IMP-00090: Unexpected DbmsJava error %d at step %u while creating %s
EXP-00091: Exporting questionable statistics.
ORA-00091: LARGE_POOL_SIZE must be at least %s
IMP-00091: Above error occurred on the following function and object: %s. Remaining PL/SQL blocks for this object will be skipped.
EXP-00092: Unable to set NLS_NUMERIC_CHARACTERS to required defaults.
ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
IMP-00092: cannot be created
EXP-00093: Could not convert to server character set's handle
ORA-00093: %s must be between %s and %s
IMP-00093: Inconsistency between dumpfile constraint definition for table %s with columns (%s)
EXP-00094: Could not convert to server national character set's handle
ORA-00094: %s requires an integer value
IMP-00094: Warning: The identifier on the dump file for object type \\"%s\\".\\"%s\\" is invalid
IMP-00095: Resumable parameters ignored -- current session not resumable
EXP-00095: Flashback_time and Flashback_scn are not compatible
EXP-00096: The template name specified can not be found.
ORA-00096: invalid value %s for parameter %s, must be from among %s
IMP-00096: Warning: Skipping table \\"%s\\".\\"%s\\" because type synonym \\"%s\\".\\"%s\\" cannot be created
EXP-00097: type will not be exported
ORA-00097: use of Oracle SQL feature not in SQL92 %s Level
IMP-00097: only valid with FULL=Y
EXP-00098: table will not be exported
IMP-00098: INTERNAL ERROR: %s
ORA-00098: creating or mounting the database requires a parameter file
EXP-00099: table will not be exported
IMP-00099: Warning: The typeid in the dump file for object type \\"%s\\".\\"%s\\" is invalid
ORA-00099: warning: no parameter file was specified
ORA-00100: no data found
IMP-00100: Import
DBV-00100: Specified FILE (%s) not accessible
LDR-00100: Syntax error on command-line\\n
EXP-00100: error converting an object type's hashcode to characters