If you explicitly define storage for your CLOB columns, make sure that initial_extent is the same as next_extent (I have pctincrease of 0), otherwise you'll find a HUGE index for the CLOB will be created. Don't know if this is addressed in 8.1.6.
PS. Anybody got any tips on improving the performance of writing to a CLOB using 'INSERT ... VALUES'?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.