Re: Autoextend on Oracle 7.3.4.5.0

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Fri, 21 Feb 2003 10:55:05 -0800
Message-ID: <F001.00554F25.20030221105505@fatcity.com>

sys.filext$ has to be joined to to the dba_data_files view.

however, if no tablespace has ever been put into autoextend mode, filext$ won't exist.

what I've done in the past to ensure the queries will work is to put a datafile into autoextend mode (this creates filext$), then take it out. filext$ is not dropped once created, even if there are no rows in it.

then you can do the join. If a datafile is IN filext$, it is set for autoextend

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

  ---

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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:55:05 CST