Actually autoextend datafiles were available in Oracle 7.3.4. I just checked in the Oracle 7 Server SQL Reference Manual (HTML) that we have here. I do remember though that you wouldn't see the autoextend column unless you applied the right patch or something? My memory is failing me, but it's something to do with a data dictionary table called SYS.FILEXT$. Does table SYS.FILEXT$ have a column in it called INC? If it does then you should be able to create an autoextend datafile.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> That feature is not available until 8.0 or 8i, forget which.
>
> "Sam Bootsma" <[EMAIL PROTECTED]
>
> 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?
