We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. 

 

I know there is SQL that allows setting a data file to auto extend.  I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not.  In later versions of Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information.  However, this column does not exist on Oracle 7.3.4:

 

SQL> desc dba_data_files

 Name                            Null?    Type

 ------------------------------- -------- ----

 FILE_NAME                                VARCHAR2(257)

 FILE_ID                                  NUMBER

 TABLESPACE_NAME                          VARCHAR2(30)

 BYTES                                    NUMBER

 BLOCKS                                   NUMBER

 STATUS                                   VARCHAR2(9)

 

SQL>

 

Can anybody tell me how I can determine (from the data dictionary, not by experimenting) whether an Oracle 7.3.4 data file is set to auto-extend?

 

Thank-you,

 

SB

Reply via email to