Re: How to copy tables
Date: Mon, 30 Oct 2000 03:12:06 GMT
Message-ID: <aG5L5.14033$NP.1017072_at_news.flash.net>
Can you create the table using a "CREATE TABLE" command?
ie.
Create table xxx
as select * from othertable_at_remotelink
"Alan Wilson" <awilson_at_accessus.net> wrote in message
news:39EE1329.BAC0111B_at_accessus.net...
> I have successfully used the 'copy' command to copy tables from one
> server to another, but it fails for a table with 30 columns. The error
> is ORA-01458 (an invalid length inside variable character string.
> Additional info: an attempt was made to bind or define a variable
> character string with a buffer less than the minimum requirment. Action:
> increase the buffer size or use a different type.) All the columns table
> are either varchar2, number, or date. I have no idea how to correc the
> problem. I don't know how to increase the buffer size (which buffers?).
> Any help would be most appreciated as I really need to be able to copy
> tables between the servers. (Oracle8i on Netware5.1 - servers at
> different physical locations)
>
> Thanks
> Alan
>
>
Received on Mon Oct 30 2000 - 04:12:06 CET