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 laterversionsof Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information. However, this column does notexiston 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/