Oracle-L: Re: Autoextend on Oracle 7.3.4.5.0

From: <Charlie_Mengler_at_HomeDepot.com>
Date: Fri, 21 Feb 2003 10:39:40 -0800
Message-ID: <F001.00554E4C.20030221103940@fatcity.com>

select * from filext$;

AFAIK an entry here means this file is now in auto-extend mode.

HTH & YMMV HAND!

                                                                                                                                       
                      "Sam Bootsma"                                                                                                    
                      <sbootsma_at_gbrownc        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                   
                      .on.ca>                  cc:                                                                                     
                      Sent by:                 Subject:  Autoextend on Oracle 7.3.4.5.0                                                
                      root_at_fatcity.com                                                                                                 
                                                                                                                                       
                                                                                                                                       
                      02/21/2003 07:44                                                                                                 
                      AM                                                                                                               
                      Please respond to                                                                                                
                      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,

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Charlie_Mengler_at_HomeDepot.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). Received on Fri Feb 21 2003 - 12:39:40 CST