In this post, we will be listing all the Oracle error messages or error codes from ORA-01301 to ORA-001500.
Oracle Error Messages ORA-01301 to ORA-001500
ORA-01301 |
error writing to file during flat file build |
ORA-01302 |
dictionary build options missing or incorrect |
ORA-01303 |
subordinate process error: number. 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-01321 |
No Logminer Dictionary for requested start SCN |
ORA-01322 |
No such table |
ORA-01323 |
Invalid state |
ORA-01324 |
cannot add file string 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-01332 |
internal Logminer Dictionary error |
ORA-01333 |
failed to establish Logminer Dictionary |
ORA-01334 |
invalid or missing logminer dictionary processes context |
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-01350 |
must specify a tablespace name |
ORA-01351 |
tablespace given for Logminer dictionary does not exist |
ORA-01352 |
tablespace given for Logminer spill does not exist |
ORA-01353 |
existing Logminer session |
ORA-01354 |
Supplemental log data must be added to run this command |
ORA-01355 |
logminer tablespace change in progress |
ORA-01356 |
active logminer sessions found |
ORA-01358 |
LogMiner version is less than mined dictionary version |
ORA-01361 |
global name mismatch |
ORA-01362 |
Specified SQL_REDO_UNDO parameter is invalid |
ORA-01363 |
Specified COLUMN_NAME parameter is NULL |
ORA-01364 |
waiting for branch at SCN string |
ORA-01365 |
waiting for new branch registration |
ORA-01366 |
failed to find redo logs required for terminal apply |
ORA-01370 |
Specified restart SCN is too old |
ORA-01371 |
Complete LogMiner dictionary not found |
ORA-01372 |
Insufficient processes for specified LogMiner operation |
ORA-01373 |
insufficient memory for staging persistent LogMiner session |
ORA-01374 |
_log_parallelism_max greater than 1 not supported in this release |
ORA-01375 |
Corrupt logfile string recovered |
ORA-01377 |
Invalid log file block size |
ORA-01378 |
The logical block size (string) of file string is not compatible with the disk sector size (media sector size is string and host sector size is string) |
ORA-01380 |
Instance string (thread string) has less than two string block size log files |
ORA-01381 |
Dropping log string would leave less than two log files with block size string for instance string (thread string) |
ORA-01382 |
Thread string failed to open log file string. The log file’s block size (string) is larger than the disk sector size (string) |
ORA-01383 |
Thread string failed to open string block size log file ‘string’ on string sector native-mode disks |
ORA-01400 |
cannot insert NULL into (string) |
ORA-01401 |
inserted value too large for column |
ORA-01403 |
no data found |
ORA-01406 |
fetched column value was truncated |
ORA-01409 |
NOSORT option may not be used; rows are not in ascending order |
ORA-01411 |
cannot store the length of column in the indicator |
ORA-01412 |
zero length not allowed for this datatype |
ORA-01413 |
illegal value in packed decimal number buffer |
ORA-01414 |
invalid array length when trying to bind array |
ORA-01415 |
too many distinct aggregate functions |
ORA-01417 |
a table may be outer joined to at most one other table |
ORA-01422 |
exact fetch returns more than requested number of rows |
ORA-01424 |
missing or illegal character following the escape character |
ORA-01425 |
escape character must be character string of length 1 |
ORA-01426 |
numeric overflow |
ORA-01429 |
Index-Organized Table: no data segment to store overflow row-pieces |
ORA-01438 |
value larger than specified precision allowed for this column |
ORA-01451 |
column to be modified to NULL cannot be modified to NULL |
ORA-01453 |
SET TRANSACTION must be first statement of transaction |
ORA-01456 |
may not perform insert/delete/update operation inside a READ ONLY transaction |
ORA-01463 |
cannot modify column datatype with current constraint(s) |
ORA-01466 |
unable to read data – table definition has changed |
ORA-01469 |
PRIOR can only be followed by a column name |
ORA-01470 |
In-list iteration does not support mixed operators |
ORA-01478 |
array bind may not include any LONG columns |
ORA-01479 |
last character in the buffer is not Null |
ORA-01480 |
trailing null missing from STR bind value |
ORA-01481 |
invalid number format model |
ORA-01482 |
unsupported character set |
ORA-01483 |
invalid length for DATE or NUMBER bind variable |
ORA-01484 |
arrays can only be bound to PL/SQL statements |
ORA-01485 |
compile bind length different from execute bind length |
ORA-01486 |
size of array element is too large |
ORA-01487 |
packed decimal number too large for supplied buffer |
ORA-01488 |
invalid nibble or byte in the input data |
ORA-01489 |
result of string concatenation is too long |
ORA-01490 |
invalid ANALYZE command |
ORA-01491 |
CASCADE option not valid |
ORA-01492 |
LIST option not valid |
ORA-01493 |
invalid SAMPLE size specified |
ORA-01494 |
invalid SIZE specified |
ORA-01495 |
specified chain row table not found |
ORA-01496 |
specified chain row table form incorrect |
ORA-01497 |
illegal option for ANALYZE CLUSTER |
ORA-01500 |
failure in getting date/time |