RE: Autoextend on Oracle 7.3.4.5.0

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-----
Bootsma
Sent: Friday, February 21, 2003 7:44 AM
To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: peter.sharman_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).