Release 8.0.4
A58312-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Error Messages Release 8.0.4 A58312-01 |
|
Cause: SQL/DS FORMAT clause is not supported.
Action: Remove the FORMAT command from the control file or Comment it out.
Cause: The control file contains a WRKDDN statement. SQL*Loader ignores this clause.
Action: No action required. This is an informational message.
Cause: The control file contains a SORTDEVT statement. SQL*Loader ignores this clause.
Action: No action required. This is an informational message.
Cause: The control file contains a SORTNUM statement. SQL*Loader ignores this clause.
Action: No action required. This is an informational message.
Cause: The control file contains a PART statement. SQL*Loader ignores this clause.
Action: No action required. This is an informational message.
Cause: The control file contained multiple INFILE statements and a DISCARDFILE statement was found below the RESUME clause.
Action: Move the DISCARDFILE statement above the RESUME clause, so it is adjacent to one of the INFILE statements.
Cause: The control file contains a LOG statement. SQL*Loader ignores this clause.
Action: No action required. This is an informational message.
Cause: The control file contains a SORTED INDEXES statement, but it was not used in a direct path load.
Action: Specify a direct path load with DIRECT=TRUE on the command line, remove the statement from the control file, or Comment it out.
Cause: There are too many indexes in the SORTED INDEX clause. The message displays the maximum number that are permitted.
Action: Reduce the number of indexes specified in the SORTED INDEX clause or use the conventional path load instead of the direct path load.
Cause: This error occurs when another user has a parse lock on the table, for example, when another user is doing a select on the table. The parse lock should clear momentarily.
Action: Give the parse lock a chance to clear and then retry or else use the conventional path load.
Cause: The PIECED keyword cannot be used in a conventional path load.
Action: Remove the PIECED keyword or use the direct path load.
Cause: A column that is not the last column was specified as PIECED.
Action: Remove the PIECED keyword or place the column last.
Cause: An obsolete file mode token was used in the control file. As of Release 1.1 of SQL*Loader, the file-processing options string is used to control file processing, rather than keywords like STREAM, RECORD, FIXED, and VARIABLE.
Action: No action required. This message is informational. Removing the obsolete keywords will eliminate the message without changing the way in which the datafile is processed.
Cause: SQL*Loader was unable to locate the default character set name for the environment.
Action: Supply a character set name with the CHARACTERSET keyword.
Cause: SQL*Loader could not find the character set handle for the named character set.
Action: Correct the character set name.
Cause: The control file is specified as containing data using the INFILE "*" clause, but other datafiles were named first.
Action: Move the INFILE "*" clause so that it is the first datafile declared in the control file.
Cause: The UNRECOVERABLE keyword can only be specified in the direct path load.
Action: Use the direct path load or remove the keyword. (Conventional path loads are always recoverable).
Cause: A clause is being compared to a null string.
Action: Modify the clause to compare to at least one character.
Cause: A table-level OPTIONS statement was specified for a non-parallel load.
Action: Remove the OPTIONS statement from the control file.
Cause: In the parallel load option, the file specified on the command line overrides the file specified in the control file.
Action: Remove the OPTIONS statement from the control file.
Cause: The READBUFFERS specification was not entered as part of a direct path.
Action: Use the direct path or remove the READBUFFERS specification from the control file.
Cause: Fewer than 2 read buffers have been specified.
Action: Specify at least 2 read buffers in the READBUFFERS statement, in the control file.
Cause: The INFILE specification was not entered in the control file.
Action: If data in the control file is to be read, specify INFILE * in the control file.
Cause: A storage clause has been specified in the table level options statement and also in the global options statement.
Action: This is only a warning message. Table level options take precedence over global options. Drop the table level options statement if this is not the intent.
Cause: A filename has been specified in the table level options statement and also in the global options statement.
Action: This is only a warning message. Table level options take precedence over global options. Drop the table level options statement if this is not the intent.
Cause: The filename used to perform the parallel load was entered incorrectly.
Action: Correct the filename and re-invoke parallel loader.
Cause: INSERT, REPLACE, or TRUNCATE mode was used in a parallel load specification.
Action: Change the control file to use the APPEND keyword and re-invoke the parallel loader.
Cause: Specifying save points using the ROWS parameter is not supported for parallel loads.
Action: Remove the ROWS parameter from the command-line arguments or specify a non-parallel direct load to have save points performed.
Cause: SQL*Loader could not find the character set handle for the given character set ID.
Action: The character set ID was obtained from the database server, the SQL*Loader client does not have knowledge of the given character set ID. Possible mismatch of NLS data on the client and server side.
