Sorry, I didn't notice in the end of your post,
that you don't want to recreate your table.
Then try this one:
add a new clob type column to your table using
alter table add.
make an update statement:
update tableA set col1=null,
newcol=to_lob(col1);
use alter table drop column col1 afterwards and if
needed, rename newcol to col1 using alter table rename column (or whatever the
syntax was).
You might want to do this in batches and commit
meanwhile if your table is big.
Also, if your table is big, then you should test
which mode lob segments are faster for your update - nocache nologging or cache
logging. Oracle might be able to optimize serial new chunk write requests to
batches, but I don't know whether it's true. It depends on the size of
your current LONGs as well..
Tanel.
|
- converting long to lob - the easiest and fastest way ? Siddharth Haldankar
- Re: converting long to lob - the easiest and fast... Tanel Poder
- RE: converting long to lob - the easiest and fast... Tanel Poder
- RE: converting long to lob - the easiest and fast... Siddharth Haldankar
- RE: converting long to lob - the easiest and fast... Siddharth Haldankar
- RE: converting long to lob - the easiest and fast... Govindan K