Chapter 31. 80000 ~ 80999

80001: Syntax error occurred in command line.

CauseA syntax error occurred in a parameter in the command line.
ActionSpecify the parameter correctly.

80002: Syntax error occurred at control parameter.

CauseA syntax error occurred in a control parameter.
ActionSpecify the parameter correctly.

80003: Column end offset must be larger than the start offset at line %1$d in control parameter.

CauseThe start offset references a location after the end offset.
ActionFix the start and end column offsets.

80004: Standard input stream failed.

CauseCannot read data entered in the standard input.
ActionEnter the correct information in the standard input.

80005: Column information is not specified.

CauseInformation about columns in the table is not specified.
ActionSpecify column information.

80006: Character set not supported by Loader utility.

CauseThe specified character set is not supported in the Loader utility.
ActionSpecify a character set supported by the Loader utility.

80007: Unable to initialize handle.

CauseCannot initialize the handle.
ActionSpecify the handle correctly.

80008: Unable to open control file.

CauseCannot open the control file.
ActionVerify the control file exists at the specified path.

80009: Control file is too large.

CauseThe control file is too large.
ActionEnsure the controls file is less than 10KB.

80010: Unable to close control file.

CauseCannot close the control file.
ActionVerify the control file exists at the specified path.

80011: Unable to open data file.

CauseCannot open the data file.
ActionVerify the data file exists at the specified path.

80012: Unable to close data file.

CauseCannot close the data file.
ActionVerify the data file exists at the specified path.

80013: Unable to open log file.

CauseCannot open the log file.
ActionVerify the log file exists at the specified path.

80014: Unable to close log file.

CauseCannot close the log file.
ActionVerify the log file exists at the specified path.

80015: Unable to open error file.

CauseCannot open the error file.
ActionVerify the error file exists at the specified path.

80016: Unable to close error file.

CauseCannot close the error file.
ActionVerify the error file exists at the specified path.

80017: Unable to open binary data file.

CauseCannot open a binary data file.
ActionVerify the binary data file exists at the specified path.

80018: Unable to close binary data file.

CauseCannot close a binary data file.
ActionVerify the binary data file exists at the specified path.

80019: Unable to load binary data larger than raw column size.

CauseThe binary data file is too large.
ActionUse a large data type like BLOB or LONG RAW.

80020: Data file name required.

CauseNo data file name was specified.
ActionSpecify a data file name.

80021: Table was not found.

CauseThe table does not exist.
ActionCheck the table name.

80022: Table name required.

CauseNo table name was specified.
ActionEnter a table name in the control file.

80023: Invalid column name \"%1$s\".

CauseThe column name is invalid.
ActionVerify that the column name exists in the table.

80024: Unsupported data type in Loader utility.

CauseThe data type is not supported by the Loader utility.
ActionCheck the data type.

80025: Column data exceeds data buffer size.

CauseThe column data is larger than the buffer.
ActionIncrease the buffer size.

80026: Data file indicator was not found.

CauseCannot find the data file at the specified location.
ActionVerify that the path of the data file is valid.

80027: Unable to locate first column in data file.

CauseCannot find the first column in the data file.
ActionVerify that the path of the data file is valid.

80028: Unable to close external LOB or LONG data file.

CauseCannot close a LONG or LOB file.
ActionVerify the path of the file is valid.

80029: Unable to copy data to stream buffer in direct path load.

CauseCannot copy data to the DPL stream buffer.
ActionCheck the size and availability of the data.

80030: Datafile has fewer lines than the number specified to skip.

CauseThe data file is smaller than the number of lines to skip.
ActionCheck the data file.

80031: Error occurred while reading data file.

CauseAn error occurred while reading a data file.
ActionCheck the path and modification of the data file.

80032: Invalid enclosed string was used.

CauseAn invalid enclosed string was used.
ActionUse a valid enclosed string.

80033: Data file has more errors than the maximum allowed (default: 50).

CauseThe data file has more record errors than allowed.
ActionModify the ERRORS parameter on the command line, or modify data.

80034: Failed to load DPL stream.

CauseCannot connect the DPL stream to server.
ActionCheck the CLI error context.

80035: Field terminator was not found.

CauseThe field delimiter does not exist.
ActionSpecify a field delimiter.

80036: Failed to fetch additional rows: End of file was reached.

CauseReached the end of the data file.
ActionCheck the current offset of the data file.

80048: Unable to jump to specific offset in datafile.

CauseCannot find a particular offset of the data file.
ActionVerify that the data file in the specified path is valid.

80049: Failed to insert data to database system.

CauseCannot load the data to DB.
ActionCheck the CLI error context.

80050: Failed to assign outfile.

CauseThe data type cannot be read from an external file.
ActionData types that can be read from an external file are BLOB, CLOB, LONG, LONG RAW and BINARY.

80051: Failed to alter DPL INDEX creation method.

CauseAn error occurred while changing the method to create a DPL INDEX.
ActionContact the system administrator.

80052: Failed to convert from Loader utility data type to database data type.

CauseCannot convert the specified Loader utility data type to DB server data type.
ActionContact the system administrator.

80053: Some relatively positioned columns are not present in the record.

CauseSome column values do not exist in the record.
ActionTo bind the non-existing columns with NULL, use the TRAILING NULLCOLS option.

80054: Error occurred while writing data file.

CauseFailed to write the data file.
ActionVerify the data file path are modifications are correct.

80055: Unable to copy data to the connection information buffer.

CauseAn attempt was made to copy data that is larger than the (MAXLENGTH: 62).
ActionCheck the buffer length and data.

80056: Column buffer size must be larger than the difference between start offset and end offset.

CauseThe buffer size of the column is smaller than the start and end offset difference.
ActionSpecify a larger buffer size, or set the location information database.

80057: LOB file field delimiter was not found.

CauseThe LOB file field delimiter does not exist.
ActionSpecify a field delimiter.

80058: The LOB file field delimiter is the same as the field terminator.

CauseThe LOB file field delimiter must be different from the field terminator.
ActionSpecify a different LOB file field delimiter.

80059: The LOB file field delimiter was not found in data file.

CauseThe LOB file field delimiter does not exist in the data file.
ActionSpecify a field delimiter found in the data file.

80060: The LOB file delimiter is the same as the field terminator.

CauseThe LOB file delimiter must be different from the field terminator.
ActionSpecify a different LOB file field delimiter.

80061: The LOB file delimiter was not found in data file.

CauseThe LOB file delimiter does not exist in the data file.
ActionSpecify a delimiter found in the data file.

80062: Invalid date/time format.

CauseInvalid date/time format.
ActionUse the format supported by the DBMS server.

80063: Bind parameter was not found.

CauseThe bind parameter name does not exist in the columns.
ActionUse a string found among the column names.

80064: Duplicate filename in Loader utility.

CauseAmong control file, Infile, badfile, and logfile, two or more files have the same name.
ActionCheck the file names and rename the duplicate(s).

80065: NOT NULL constraint violated.

CauseAn attempt was made to insert the NULL value into a column where the NOT NULL constraint is specified.
ActionRemove the NOT NULL constraint, or insert a value that is not NULL.

80066: Not yet implemented.

CauseThis function has not been implemented.
ActionThis function will be supported in the next version.

80067: Cannot recognize the wallet file.

CauseInput file name is incorrect or empty.
ActionCheck the environment variable or input the file correctly.

80068: Unknown SQL function or function parameter.

CauseCheck SQL function or function parameter.
ActionCheck SQL function or function parameter.

80069: Data save error in direct path loading mode.

CauseCheck bad file and log file.
ActionCheck bad file and log file.

80070: Too many table names exist.

CauseSet specific table names.
ActionVerify more than one SYNONYM are binded to different tables.

80071: Unable to use column with expression in DPL mode (DIRECT=Y).

CauseThis function is not supported.
ActionUse column with expression in CPL mode (DIRECT=N).

80072: DIRECT=Y option should be specified when DPL_LOG=Y or DPL_PARALLEL=Y.

CauseIf DPL_LOG=Y or DPL_PARALLEL=Y, DIRECT=Y should be also specified.
ActionSpecify the DIRECT=Y option.

80073: Filename is too long.

CauseThe file name must be less than or equal to 256 characters.
ActionChoose a new filename.

80074: Invalid column index.

CauseThe column index is invalid.
ActionVerify that the column index is consistent with the column list.