It's possible they were, I never worked in 7.2. However, I have a real,
honest-to-goodness hard-bound book of the Oracle7 SQL Reference manual
(7.0) and the clause "autoexend" is not in there. So we've narrowed
down the time when autoextend was introduced.
Rachel
--- Mogens_Nørgaard <mln_at_miracleas.dk> wrote:
> I think they were introduced in 7.2?
>
> Mogens
>
> Rachel Carmichael wrote:
>
> >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/
> >
> >
>
>
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 Sat Feb 22 2003 - 09:43:54 CST
