not a patch, just that sys.filext$ isn't created until at least one
datafile has been made autoextensible. Once you do that, it stays
around and you can check that table to find out which datafiles can
extend. If it's there, it can.
sys.filext$ still exists in 9i, I just checked :)
- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com> wrote:
> Actually autoextend datafiles were available in Oracle 7.3.4. I just
> checked
> in the Oracle 7 Server SQL Reference Manual (HTML) that we have here.
> I do
> remember though that you wouldn't see the autoextend column unless
> you
> applied the right patch or something? My memory is failing me, but
> it's
> something to do with a data dictionary table called SYS.FILEXT$. Does
> table
> SYS.FILEXT$ have a column in it called INC? If it does then you
> should be
> able to create an autoextend datafile.
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> >
> > That feature is not available until 8.0 or 8i, forget which.
> >
> > "Sam Bootsma" <sbootsma_at_gbrownc.on.ca
> >
> > 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?
>
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 - 19:43:42 CST
