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_at_radisys.com [mailto:Jared.Still_at_radisys.com]
>
> That feature is not available until 8.0 or 8i, forget which.
>
> "Sam Bootsma" <sbootsma_at_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 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?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_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_at_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).
Received on Fri Feb 21 2003 - 14:17:19 CST
