Re: Autoextend on Oracle 7.3.4.5.0

I think they were introduced in 7.2?

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 :)
>
>
>--- Jared.Still_at_radisys.com wrote:
>
>
>>Had no idea they were available in 7.3.4.
>>
>>
>>
>>
>>
>>Rachel Carmichael <wisernet100_at_yahoo.com>
>>Sent by: root_at_fatcity.com
>> 02/21/2003 10:55 AM
>> Please respond to ORACLE-L
>>
>>
>> To: Multiple recipients of list ORACLE-L
>><ORACLE-L_at_fatcity.com>
>> 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 <sbootsma_at_gbrownc.on.ca> 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: wisernet100_at_yahoo.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).
>>
>>
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author:
>> INET: Jared.Still_at_radisys.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).
>>
>>
>>
>
>
>__________________________________________________
>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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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