Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1M01Zn02074 for ; Fri, 21 Feb 2003 18:01:35 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1M01ZQ02068 for ; Fri, 21 Feb 2003 18:01:35 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA32811; Fri, 21 Feb 2003 12:45:12 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0055531B; Fri, 21 Feb 2003 12:17:19 -0800 Message-ID: Date: Fri, 21 Feb 2003 12:17:19 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Jacques Kilchoer Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Jacques Kilchoer Subject: RE: Autoextend on Oracle 7.3.4.5.0 Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2D9E6.A5A318B0" ------_=_NextPart_001_01C2D9E6.A5A318B0 Content-Type: text/plain 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: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com] > > That feature is not available until 8.0 or 8i, forget which. > > "Sam Bootsma" > 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? ------_=_NextPart_001_01C2D9E6.A5A318B0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Autoextend on Oracle 7.3.4.5.0

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: Jared.Still@radisys.com [mailto:Jared.Still@radisys.com]
>
> That feature is not available until 8.0 or 8i, = forget which.
>
> "Sam Bootsma" = <sbootsma@gbrownc.on.ca
>
> 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           &n= bsp;           &n= bsp;    Null?    Type
>  ------------------------------- -------- = ----
>  = FILE_NAME          &nb= sp;           &nb= sp;         = VARCHAR2(257)
>  = FILE_ID           = ;            = ;           = NUMBER
>  = TABLESPACE_NAME         &nb= sp;           &nb= sp;    VARCHAR2(30)
>  = BYTES           &= nbsp;           &= nbsp;            = 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?

------_=_NextPart_001_01C2D9E6.A5A318B0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: Jacques.Kilchoer@quest.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@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).