Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Autoextend on Oracle 7.3.4.5.0

Autoextend on Oracle 7.3.4.5.0

From: Sam Bootsma <sbootsma_at_gbrownc.on.ca>
Date: Fri, 21 Feb 2003 07:44:22 -0800
Message-ID: <F001.00554693.20030221074422@fatcity.com>


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: Sam Bootsma
  INET: sbootsma_at_gbrownc.on.ca

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 - 09:44:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US