Re: TRUNCATE ???

From: REIP Jean-Claude <jacari.consultant.noospaamm_at_skynet.be>
Date: 1997/11/06
Message-ID: <63sv6o$o16$1@news0.skynet.be>#1/1

Just more questions :
Which are your default storage for this tablespace ? You storage parameters are perhaps reverted to default ?

Note that maxextents > 121 is available only if you have big Oracle Blocks !

Regards

--
REIP Jean-Claude
Enlevez ".remove.this" de l'adresse (anti-spam)
jacari.consultant.remove.this_at_skynet.be
Andreas Hess wrote in message <01bcea85$294a0cc0$300610ac_at_trahe>...


>Hi All

>

>2.  No problem - I changed the MAXEXTENTS storage parameter to 150 for

>table X

>     and changed the NEXT value to 500K (from 20k - the default) to avoid

>too many

>     extents...

>     I queried DBA_SEGMENTS and the NEXT storage parameter for the table

>had

>     reverted to 20K !

Received on Thu Nov 06 1997 - 00:00:00 CST