problem with COPY FROM command
Date: 20 Aug 2002 23:01:11 -0700
Message-ID: <396cc940.0208202201.47f677d0_at_posting.google.com>
Hi,
I've been trying to copy one table along with its contents from my
local
database onto the server using following copy command:
COPY FROM SCOTT/TIGER_at_localDB.localDomain TO remoteUSER/remotePWD_at_remoteDB.remoteDomain CREATE tableTEMP USING SELECT * FROM table_TEMP
In turn, I receive following error message:
ORA-01458: invalid length inside variable character string
After searching I found following information:
Cause of error: An attempt was made to bind or define a variable
character
string with a buffer length less than the two-byte minimum
requirement.
Action: Increase the buffer size or use a different type.
Please tell how can this be done and I dont have admin rights.
Thanks
Anand
Received on Wed Aug 21 2002 - 08:01:11 CEST