not a patch, just that sys.filext$ isn't created until at least one datafile has been made autoextensible. Once you do that, it stays around and you can check that table to find out which datafiles can extend. If it's there, it can.
sys.filext$ still exists in 9i, I just checked :) --- Jacques Kilchoer <[EMAIL PROTECTED]> wrote: > Actually autoextend datafiles were available in Oracle 7.3.4. I just > checked > in the Oracle 7 Server SQL Reference Manual (HTML) that we have here. > I do > remember though that you wouldn't see the autoextend column unless > you > applied the right patch or something? My memory is failing me, but > it's > something to do with a data dictionary table called SYS.FILEXT$. Does > table > SYS.FILEXT$ have a column in it called INC? If it does then you > should be > able to create an autoextend datafile. > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > That feature is not available until 8.0 or 8i, forget which. > > > > "Sam Bootsma" <[EMAIL PROTECTED] > > > > 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? > __________________________________________________ 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).
