ORA-01409: NOSORT option may not be used; rows are not in ascending order
Cause: Creation of index with NOSORT option when rows were not ascending. For non-unique indexes the rowid is considered part of the index key. Therefore, if you create an index nosort and two of the rows in the table have the same key and are stored in ascending order, but get split accross two extents where the dba of the first block in the second extent is less than the dba of the last block in the first extent, then the create index nosort may fail.
Action: Create the index without the NOSORT option, or ensure table is stored in one extent.
ORA-01412
Custom Search


More Oracle errors
LFI-00117Unable to rename file.
PGU-35008failure to close cursor string for statement string: rc string
ORA-14025PARTITION may not be specified for a materialized view or a materialized view log
ORA-25150ALTERING of extent parameters not permitted
ORA-12823default degree of parallelism may not be specified here
RMAN-07526Reason: File is not an Oracle Managed File
ORA-19581no files have been named
UDI-00007attempt to free unallocated memory
LCD-00209missing value for keyword at end of string [string]
OCI-30152File does not exist
DGM-16902Unable to allocate handle
RMAN-06115changed backup piece available
ORA-55206Tag data translation field not found
ORA-39726unsupported add/drop column operation on compressed tables
NNL-00258Server-generated requests currently do not require authoritative answers
ORA-29813non-supported object type with associate statement
ORA-36667(XSDPART05) string is not a legal CONCAT partition.
ORA-38457The attribute "string" is not a valid XMLType attribute.
PGU-41094call name string or specified version (number) of call name string does not exist
ORA-32632incorrect subquery in MODEL FOR cell index




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-01409NOSORT option may not be used; rows are not in ascending order