RE: storing lobs as secure files - any gotchas?
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Wed, 27 Feb 2013 17:39:17 +0400
Message-ID: <OF05C74D66.BC5CBEBA-ON44257B1F.00484FCF-44257B1F.004B325D_at_psbank.ru>
Hi, Bob!
Date: Wed, 27 Feb 2013 17:39:17 +0400
Message-ID: <OF05C74D66.BC5CBEBA-ON44257B1F.00484FCF-44257B1F.004B325D_at_psbank.ru>
Hi, Bob!
Since you want to use securefile, i'm not sure that you need partitioning
on 80k rows(except case when with "store in row" and you have a lot of
short clobs)
Also, afaik, you cannot use direct path insert of "Out-of-Line" clobs (
because of lob id, lob index, etc...).
Best regards,
Sayan Malakshinov
http://orasql.org
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 27 2013 - 14:39:17 CET