505 is the default for the tablespace. your table and index parameters will override it if you state it.

you can alter the tablespace and set its extents to unlimited.

alter tablespace storage(maxextents unlimited);

syntax may be off slightly.
>
> From: "Puneet Sharma" <[Email Address Removed] Date: 2003/05/30 Fri AM 09:15:40 EDT
> To: "LazyDBA.com Discussion" <[Email Address Removed] 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