Re: Temporary tablespace usage

From: Raju Angani <angani_at_gmail.com>
Date: Fri, 16 Dec 2011 15:23:05 -0800
Message-ID: <CAJ-04Or=sreDZLaZQWYB+8_TEgNsP-h7O6iqdzsBvXEFQM=Bkw_at_mail.gmail.com>

I see selects/insert/update/delete statements which have blob datatype on those tables.
e.g
update table_name set blob_col1 =:2 where id = :16 insert into table_name(blob_col1) values(:1); delete from table_name where blob_id = :1;

So it ok to select/DML(select/update/insert/delete) operations on blob columned tables without using the dbms_lob package?

Thank you
RA

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 16 2011 - 17:23:05 CST