Need help - problem with array storage

From: Jason Filby <jason.filby_at_orafocus.com>
Date: 8 Oct 2001 19:56:18 GMT
Message-ID: <1002570513.429010@proxy.storm.co.za>

Hi all

I have several objects which contain variables of type varray. I need to write these objects into a table for persistence. Oracle creates several LOBs and LOB indexes to store the varray data. There doesn't seem to be any way to specificy the size of these LOBs so I'm stuck with huge segments.

I tried making the arrays of type table. So then they are stored as nested tables. But I have the same problem -- you can't specify storage for nested tables.

Please help!

Thanks
- Jason

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Mon Oct 08 2001 - 14:56:18 CDT