Jerry - I did a quick survey of some of my databases and only found a single table that had a null MAX_EXTENTS and it was not partitioned. Its name was ATEMPTAB$ owned by SYS.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, May 28, 2003 11:15 AM To: Multiple recipients of list ORACLE-L Hi all, I have a database where all tables and indexes have maxextents set to unlimited. Why, in dba_tables, do some tables have a null value for maxetents and some have a value of 2147483645? An index I just modified (previous value of maxextents was 249) now has a null value for maxextents: SQL> alter index app_owner.index1 storage (maxextents unlimited); Index altered. SQL> select owner, index_name, max_extents from dba_indexes 2 where owner = 'APP_OWNER' and index_name = 'INDEX1'; OWNER INDEX_NAME MAX_EXTENTS ------------------------------ ------------------------------ ----------- APP_OWNER INDEX1 It seems that some of the objects that have maxextents = null are partitioned, but not all. Anybody have an explanation?? Thanks! - Jerry Jerry Cunningham Principal Database Engineer Enterprise Applications USi [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Office 410.897.3084 Cell 443.994.7359 SMS [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> AIM cunninghamjerryc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
