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 <[EMAIL PROTECTED]> 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 :) > > > > > >--- [EMAIL PROTECTED] wrote: > > > > > >>Had no idea they were available in 7.3.4. > >> > >> > >> > >> > >> > >>Rachel Carmichael <[EMAIL PROTECTED]> > >>Sent by: [EMAIL PROTECTED] > >> 02/21/2003 10:55 AM > >> Please respond to ORACLE-L > >> > >> > >> To: Multiple recipients of list ORACLE-L > >><[EMAIL PROTECTED]> > >> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > >> > >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >> > >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
