Oracle 8.0 Copy long from 1 table to another

[jcwhui]

Hello all,

Yes, it is another Oracle 8.0 question. We are just too small to force our
customer to migrate to newer Oracle.

My problem is I need to copy the value of the long column in table A to
another table B's long column.

Unfortunately, "insert into table_a select long_column from table_b"
doesn't work. I also thought of changing table_a's long column to clob,
and convert table_b.long_column to clob before inserting into table_a, but
to_lob() doesn't exist in Oracle 8.0.

So is this my only option: dumping table_b.long_column to a file and
loading it back to table_a.long_column?

Thanks in advance!!!
- Will

[Dale Edgar]

On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui
<j_c_w_h_u_i@hot_mail.company> wrote:

My problem is I need to copy the value of the long column in table A to
another table B's long column.

Unfortunately, "insert into table_a select long_column from table_b"
doesn't work. I also thought of changing table_a's long column to clob,
and convert table_b.long_column to clob before inserting into table_a, but
to_lob() doesn't exist in Oracle 8.0.

So is this my only option: dumping table_b.long_column to a file and
loading it back to table_a.long_column?

Investigate the use of the SQLPlus COPY command. This can transfer
longs.

Here's a link to the FAQ: http://www.orafaq.com/faqplus.htm#COPYLONG

Kind regards
Dale

Need to get the DDL out of a schema (or database)? Check out our
freeware DBATool. http://www.DataBee.com/dt_home.htm

[jcwhui]

Dale Edgar <Da**@DataBee.com> wrote in
news:tc********************************@4ax.com:

On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui
<j_c_w_h_u_i@hot_mail.company> wrote:

My problem is I need to copy the value of the long column in table A to
another table B's long column.

Unfortunately, "insert into table_a select long_column from table_b"
doesn't work. I also thought of changing table_a's long column to clob,
and convert table_b.long_column to clob before inserting into table_a,
but to_lob() doesn't exist in Oracle 8.0.

So is this my only option: dumping table_b.long_column to a file and
loading it back to table_a.long_column?

Investigate the use of the SQLPlus COPY command. This can transfer
longs.

Here's a link to the FAQ: http://www.orafaq.com/faqplus.htm#COPYLONG

Kind regards
Dale

I doubt this will work for me. My code is inside a stored procedure. And
in fact I meant to copy 1 particular row from table_b to table_a, i.e.
"insert into table_a select long_column from table_b where id=123"

I guess external file access is my only option now. Thanks anyway!

- Will

[Frank]

jcwhui wrote:

Dale Edgar <Da**@DataBee.com> wrote in
news:tc********************************@4ax.com:

On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui
<j_c_w_h_u_i@hot_mail.company> wrote:

My problem is I need to copy the value of the long column in table A to
another table B's long column.

Unfortunately, "insert into table_a select long_column from table_b"
doesn't work. I also thought of changing table_a's long column to clob,
and convert table_b.long_column to clob before inserting into table_a,
but to_lob() doesn't exist in Oracle 8.0.

So is this my only option: dumping table_b.long_column to a file and
loading it back to table_a.long_column?

Investigate the use of the SQLPlus COPY command. This can transfer
longs.

Here's a link to the FAQ: http://www.orafaq.com/faqplus.htm#COPYLONG

Kind regards
Dale

I doubt this will work for me. My code is inside a stored procedure. And
in fact I meant to copy 1 particular row from table_b to table_a, i.e.
"insert into table_a select long_column from table_b where id=123"

I guess external file access is my only option now. Thanks anyway!

- Will

Insert all data, except the long, then update the long.
Didn't try, but works for LOB across dblinks...

--
Regards, Frank van Bortel