|  |  |  | Library |  | Product |  | Contents |  | Index |

# COPY Command Messages and Codes

This appendix lists error messages generated by the COPY command. For error messages generated by Oracle, refer to the Oracle8 Server Messages Manual.

CPY0002:

Illegal or missing APPEND, CREATE, INSERT, or REPLACE option

Cause:

An internal COPY function has invoked COPY with a create option (flag) value that is out of range.

Action:

Please contact your Oracle Customer Support representative.

CPY0003:

Internal Error: logical host number out of range

Cause:

An internal COPY function has been invoked with a logical host number value that is out of range.

Action:

Please contact your Oracle Customer Support representative.

CPY0004:

Source and destination table and column names don't match

Cause:

On an APPEND operation or an INSERT (when the table exists), at least one column name in the destination table does not match the corresponding column name in the optional column name list or in the SELECT command.

Action:

Re-specify the COPY command, making sure that the column names and their respective order in the destination table match the column names and column order in the optional column list or in the SELECT command.

CPY0005:

Source and destination column attributes don't match

Cause:

On an APPEND operation or an INSERT (when the table exists), at least one column in the destination table does not have the same datatype as the corresponding column in the SELECT command.

Action:

Re-specify the COPY command, making sure that the datatypes for items being selected agree with the destination. You can use TO_DATE, TO_CHAR, and TO_NUMBER to make conversions.

CPY0006:

Select list has more columns than destination table

Cause:

On an APPEND operation or an INSERT (when the table exists), the number of columns in the SELECT command is greater than the number of columns in the destination table.

Action:

Re-specify the COPY command, making sure that the number of columns being selected agrees with the number in the destination table.

CPY0007:

Select list has fewer columns than destination table

Cause:

On an APPEND operation or INSERT (when the table exists), the number of columns in the SELECT command is less than the number of columns in the destination table.

Action:

Re-specify the COPY command, making sure that the number of columns being selected agrees with the number in the destination table.

CPY0008:

More column list names than columns in the destination table

Cause:

On an APPEND operation or an INSERT (when the table exists), the number of columns in the column name list is greater than the number of columns in the destination table.

Action:

Re-specify the COPY command, making sure that the number of columns in the column list agrees with the number in the destination table.

CPY0009:

Fewer column list names than columns in the destination table

Cause:

On an APPEND operation or an INSERT (when the table exists), the number of columns in the column name list is less than the number of columns in the destination table.

Action:

Re-specify the COPY command, making sure that the number of columns in the column list agrees with the number in the destination table.

Prev Next |  |  |  |  |  |  |  |  | Copyright © 1997 Oracle Corporation. All Rights Reserved. |  |  |  |  |  |  |  | Library |  |  | Product |  |  | Contents |  |  | Index |