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 LazyDBA home page