Originally posted by TimHall
Hi.

Couple of questions:

1) What method did you use (extract & load or TO_LOB)?
2) What's the average size of the LONG?

See: http://download-west.oracle.com/docs...9a.htm#1189967

Cheers
I ran:

ALTER TABLE emp MODIFY (text_info CLOB);

I do not know the average size.