Re: P.S.

well, what you can do, depending on the size of your long data, if you have data which is <32k cant you use the sqlplus copy command ? it does not support long raws but I thought it supported longs. haven't got any doc on me so I cannot verify.

anyways, another way to do this, would be to write a small plsql block or procedure.

you declare a plsql variable,
and then write the logic to do a full select into :var and then insert into the table. that works well. I haev done that before to recover some data from a database when they had corrupted blocks and we had to select by rowid and all that stuff.. anyways they had I think a long raw column... but luckily enough it was data less than 32 k.

hope this helps
cheers
wim Received on Sat Jan 17 1998 - 00:00:00 CST