well I was using them in 7.3.4 so ... either I was delusional or they
existed :)
and I do remember writing about them in some book or other :)
- Jared.Still_at_radisys.com wrote:
> Had no idea they were available in 7.3.4.
>
>
>
>
>
> Rachel Carmichael <wisernet100_at_yahoo.com>
> Sent by: root_at_fatcity.com
> 02/21/2003 10:55 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: Re: Autoextend on Oracle 7.3.4.5.0
>
>
> 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).
>
>
>
>
> --
> 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).
>
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:53:56 CST
