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

dominica_at_gmail.com wrote:
> I just figure out:
>
> To determine if a datafile and thus, a tablespace, has AUTOEXTEND
> capabilities, query the SYS table "FILEXT$".
>

...
> SQL> select * from filext$ where file# = 6;
>
>
> FILE# MAXEXTEND INC
> ---------- ---------- ----------
> 6 4194302 64
>
>
> 64 * 8192 *1024 = my 512K

Hi, Dominica,

64 * 8192 = your 512K. Since Oracle recommends you use dba_data_files instead of filext$, consider getting this value from dba_data_files.increment_by.

Yong Huang Received on Mon Sep 26 2005 - 21:52:59 CDT