SQL*Plus User's Guide and Reference Release 8.1.6 A75664-01 |
|
This appendix lists error messages generated by the COPY command. For error messages generated by Oracle, refer to the Oracle8i Error 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 Worldwide Customer Support Services 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 Worldwide Customer Support Services 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 name 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 name 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.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|