Oracle Database Errors or Warnings from Error ORA-26000 to ORA-26010


ORA-26000: partition load specified but table string is not partitioned
Cause: The Loader control file contains a PARTITION clause but the table being loaded is not partitioned.
Action: Remove the partition specification from the SQL*Loader control file and retry the load.
ORA-26001: Index string specified in SORTED INDEXES does not exist on table string
Cause: A nonexistent index was specified in the SORTED INDEXES clause.
Action: Do not specify as a SORTED INDEX.
ORA-26002: Table string has index defined upon it.
Cause: Parallel load was specified into a table which has index defined upon it.
Action: Drop index(es) defined upon table, or don’t use parallel load, or use SKIP_INDEX_MAINTENANCE option.

ORA-26003: parallel load not supported for index-organized table string.
Cause: Parallel load is not supported for index-organized tables.
Action: load the index-organized table without the PARALLEL option.
ORA-26004: Tables loaded through the direct path may not be clustered
Cause: User attempted to load a clustered table via the direct path.
Action: Use the conventional path.
ORA-26005: Invalid handle for direct path load
Cause: In direct path load, the handle passed in does not match the type listed.
Action: Verify the handle and type are correct.

ORA-26006: Incorrect bind variable in column string’s sql expression – string
Cause: In direct path load, the bind variables listed in the sql expression do not match the input argument column names.
Action: Verify all the input arguments are listed in the expression as bind variables, and all the bind variables are listed as input arguments to the expression. Or verify that there were no errors in executing the OCI statements when getting the bind variable list.
ORA-26007: invalid value for SETID or OID column
Cause: The value passed in a Direct Path API stream for a column containing a SETID or OID has an invalid value. SETIDs and Object IDs must be either 16 bytes of RAW data or 32 bytes of hexidecimal characters.
Action: Regenerate the Direct Path API stream with a valid value for the SETID column.
ORA-26008: Invalid syntax or bind variable in SQL string for column string. string
Cause: See following error message for more information. A SQL string cannot have quoted strings improperly terminated. A bind variable in a SQL string cannot have a length of 0, cannot exceed maximum length of 30 characters, and cannot be missing a double quote.
Action: Fix the SQL string. See following error for more information.
ORA-26010: Column string in table string is NOT NULL and is not being loaded
Cause: A column which is NOT NULL in the database is not being loaded and will cause every row to be rejected.
Action: Load the column by specifying the NOT NULL column in the INTO TABLE clause in the SQL*Loader control file.

Above are list of Oracle Database Errors or Warnings from Error ORA-26000 to ORA-26010 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *