| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Check if autoextend is on (Oracle 7.3.4)
on. However i do not see that much info on an Oracle 7.3.4 database.
>1. Is autoextend possible?
yes, absolutely
>2. How to check if autoextend is enabled or not?
>
look for the table sys.filext$ it will exist if and only if autoextend has been turned on at least once. Entries in there relate back to dba_data_files. If you turn autoextend off everywhere, the table does not disappear.
>From: nlzanen1_at_EY.NL
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Check if autoextend is on (Oracle 7.3.4)
>Date: Thu, 28 Jun 2001 05:26:24 -0800
>
>Hi All,
>
>
>As of oracle 8.0 you can check the dba_data_files to see if auto extend is
>on. However i do not see that much info on an Oracle 7.3.4 database.
>1. Is autoextend possible?
>2. How to check if autoextend is enabled or not?
>
>TIA
>
>
>Jack
>
>=====================================================================
>De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
>uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
>vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
>derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
>Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
>volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
>voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
>verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
>worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
>Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
>vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
>en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
>Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
>voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
>algemene voorwaarden worden u op verzoek kosteloos toegezonden.
>=====================================================================
>The information contained in this communication is confidential and is
>intended solely for the use of the individual or entity to whom it is
>addressed. You should not copy, disclose or distribute this communication
>without the authority of Ernst & Young. Ernst & Young is neither liable for
>the proper and complete transmission of the information contained in this
>communication nor for any delay in its receipt. Ernst & Young does not
>guarantee that the integrity of this communication has been maintained nor
>that the communication is free of viruses, interceptions or interference.
>
>If you are not the intended recipient of this communication please return
>the communication to the sender and delete and destroy all copies.
>
>In carrying out its engagements, Ernst & Young applies general terms and
>conditions, which contain a clause that limits its liability. A copy of
>these terms and conditions is available on request free of charge.
>=====================================================================
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: nlzanen1_at_EY.NL
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Thu Jun 28 2001 - 09:10:04 CDT
 |
 |