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