Puneet:

You can set AUTOEXTEND ON for the data file.And you can create procedure
which will check regularly the number of extents created for each segment to
the maxextent value of each segment.So any of the objects reaching
MAXEXTENTS it should increase the MAXEXTENT dynamically.

Joe.

----- Original Message -----
From: "Puneet Sharma" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, May 30, 2003 6:45 PM
Subject: How to avoid extents error?


> Hi All,
>
> I need suggestions. I do have a tablespace with Max extents 505 (Oracle
> 8.1.7.4, Solaris 2.8). To avoid any max extents error in tables and
indexes
> I made their extents unlimited.
>
> Now tables and indexes have unlimited extents but tablespace has limited
> (505) extents. I am not sure if this will cause a error if tablespace
> reaches it limit. (I think it would)
>
> Should I calculate it from next extent size? Is there any other best way
to
> avoid extents errors?
>
> Please advice.
>
> Thank you so much for your help.
>
> Regards,
> Puneet
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page