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/ -- 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).
