| error in copying form one db to another [message #72979] |
Wed, 07 January 2004 18:06  |
rammohan
Messages: 13
Registered: March 2002
|
Junior Member |
|
|
i having a problem in copying from one database to another. i am giving below the error encountered by me. can anyone please solve my problem.
SQL> @C:WINDOWSDESKTOPCOPYFROM
Input truncated to 214 characters
Array fetch/bind size is 15. (arraysize is 15)
Will commit after every 50 array binds. (copycommit is 50)
Maximum long size is 80. (long is 80)
CPY0007: Select list has fewer columns than destination tab
SQL> desc crecomp
Name Null? Type
------------------------------- -------- ----
FASTYPE NOT NULL VARCHAR2(4)
VOUCHNO NOT NULL VARCHAR2(5)
VOUCHDATE NOT NULL DATE
ACCNO NOT NULL VARCHAR2(7)
VOUAMOUNT NUMBER(13,2)
VOUID VARCHAR2(1)
ADVFLAG VARCHAR2(1)
CHEQUENO NUMBER(8)
CHEQUEDATE DATE
AMTSETOFF NUMBER(13,2)
CHTRNO NUMBER(5)
BILLNO VARCHAR2(20)
BILLDATE DATE
DUEDAYS NUMBER(6)
STATUS VARCHAR2(1)
OLDSTAT VARCHAR2(1)
SQL> connect fas/saf@evlazn
Connected.
SQL> desc crecomp
Name Null? Type
------------------------------- -------- ----
FASTYPE NOT NULL VARCHAR2(4)
VOUCHNO NOT NULL VARCHAR2(5)
VOUCHDATE NOT NULL DATE
ACCNO NOT NULL VARCHAR2(7)
VOUAMOUNT NUMBER(13,2)
VOUID VARCHAR2(1)
ADVFLAG VARCHAR2(1)
CHEQUENO NUMBER(8)
CHEQUEDATE DATE
AMTSETOFF NUMBER(13,2)
CHTRNO NUMBER(5)
BILLNO VARCHAR2(20)
BILLDATE DATE
DUEDAYS NUMBER(6)
STATUS VARCHAR2(1)
OLDSTAT VARCHAR2(1)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
