Re: Which data-dictionary store the 'AUTOEXTEND' size?

I just figure out:

To determine if a datafile and thus, a tablespace, has AUTOEXTEND capabilities, query the SYS table "FILEXT$".

Here is a description of the table:

 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE#                           NOT NULL NUMBER
 MAXEXTEND                       NOT NULL NUMBER
 INC                             NOT NULL NUMBER

where:

      FILE# : the datafile number as it appears in "V$DATAFILE".   MAXEXTEND : the maximum size the file can grow to, expressed in multiples

              of "DB_BLOCK_SIZE", not in bytes.
        INC : the size of each increase in the datafile, also in
multiples
              of "DB_BLOCK_SIZE".

NOTE: To get the values in bytes, multiply each number by the "init.ora"

      parameter "DB_BLOCK_SIZE".

SQL> desc filext$;

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 FILE#                                              NUMBER
 MAXEXTEND                                          NUMBER
 INC                                                NUMBER

SQL> select * from filext$ where file# = 6;

     FILE# MAXEXTEND INC
---------- ---------- ----------

         6 4194302 64

64 * 8192 *1024 = my 512K Received on Mon Sep 26 2005 - 21:02:08 CDT