RE: Autoextend on Oracle 7.3.4.5.0

[Pete Sharman]

Title: Message

IIRC, you needed FILE$ or FILEXT$ - something like that anyway (those brain cells are long gone, I'm afraid!) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not.  It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sam Bootsma Sent: Friday, February 21, 2003 7:44 AM To: Multiple recipients of list ORACLE-L Subject: Autoextend on Oracle 7.3.4.5.0 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