Re: COPYing data from a table in one DB to a table in another DB

Tim,

    You can use the export and import utilities to export the data from the one database and import it into the other. Regards,
Paul

In article <L2jq4.16925$_d.903004_at_news1.gvcl1.bc.home.com>,   "Tim McClelland" <cst97042_at_camosun.bc.ca> wrote:
> Does anybody know if you can change the buffer size in SQL-PLUS?
 I've been
> using the COPY command to copy data from tables in a test database to
 tables
> in a production database. This seems to work for tables with small
 datatype
> column definitions (eg. INT, VARCHAR2(50)), but when I try copying
 tables
> with larger datatypes (eg. VARCHAR2(4000), LONG) it gives me this
 error:
>
> ORA-01458: invalid length inside variable character string.
>
> Any help is much appreciated.
>
> Tim
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 16 2000 - 00:00:00 CET