When LOB_DATA/LOB_INDEX is created
Hi,
under which circumstances does oracle create LOB_DATA and LOB_INDEX segments in temporary tablespace? In my case it happens if a select is issued through a jdbc interface. The view (object view) which is selected has no LOB column at all. The problem is now that this LOB_DATA and LOB_INDEX segment stays in the tablespace until the session gets disconnected.
I know LOBs need to get freed explicitly when you select them, but why are there LOB segments when not even selecting a LOB column?
regards,
Mathias