469,349 Members | 1,485 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,349 developers. It's quick & easy.

Oracle 8.0 Copy long from 1 table to another

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
Jul 19 '05 #1
3 11941
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

Jul 19 '05 #2
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
Jul 19 '05 #3
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

Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

133 posts views Thread by jonathan | last post: by
13 posts views Thread by BigDaDDY | last post: by
1 post views Thread by Andrew Arace | last post: by
7 posts views Thread by peter.morin | last post: by
56 posts views Thread by Ashish Patankar | last post: by
reply views Thread by Chris Leonard | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.