problem with COPY FROM command

From: Anand <ashrivastava_at_auriga-insys.com>
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

Original text of this message