Re: Autoextend on Oracle 7.3.4.5.0

Sam,

SQL> select *
  2 from sys.filext$;

     FILE# MAXEXTEND INC
---------- ---------- ----------

         9     256000      64000
        17     256000      64000

The result must be oracle blocks

Chaim

Jared.Still_at_radisys.com_at_fatcity.com on 02/21/2003 02:09:39 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

That feature is not available until 8.0 or 8i, forget which.

Jared

"Sam Bootsma" <sbootsma_at_gbrownc.on.ca>
Sent by: root_at_fatcity.com
 02/21/2003 07:44 AM
 Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc:
        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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: Jared.Still_at_radisys.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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Chaim.Katz_at_Completions.Bombardier.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).