jeremy.henty wrote:
> I've been enforcing a uniform extent policy on a legacy database, so I've
> been doing lots of "ALTER TABLE MOVE STORAGE ( ... )". I'm mostly done
> but there's one nagging exception: I can't set the next_extent property
> on LOB indexes. I've tried both of:
>
> alter table FOO modify lob(BAR) (index (storage (next 256K)));
> alter table FOO move lob(BAR) store as (index (storage (next 256K)));
>
> ... but neither has any effect. This surprises me because the second
> method *did* successfully modify the initial extent of the LOB indexes!
> Am I missing something or is there really no way to do this? (Any attempt
> to alter the index directly gets an Oracle error.)
>
> The database is version 8.1.6 on Solaris 7 .
>
> Regards,
>
> Jeremy Henty
A database version that is totally unsupported by Oracle on an operating
system version that even Sun choked on. Why not spend your time and
energy moving to something that, if in your resume, will get you your
next job?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Sep 07 2005 - 17:33:31 CDT
