Re: Is Autoextend ON??

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 14 Dec 1998 18:36:18 GMT
Message-ID: <367859e8.2294108@192.86.155.100>

A copy of this was sent to "Igor " <espiaui_at_hotmail.com> (if that email address didn't require changing) On 14 Dec 1998 17:37:51 GMT, you wrote:

>
>Is there a way of checking if the option AUTOEXTEND
>is ON for a particular tablespace??
>
>
>Thanks
>Igor

In O8, its in dba_data_files:

SQL> desc sys.dba_data_files;

 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE_NAME                                VARCHAR2(513)
 FILE_ID                         NOT NULL NUMBER
 TABLESPACE_NAME                 NOT NULL VARCHAR2(30)
 BYTES                                    NUMBER
 BLOCKS                          NOT NULL NUMBER
 STATUS                                   VARCHAR2(9)
 RELATIVE_FNO                             NUMBER
 AUTOEXTENSIBLE                           VARCHAR2(3)
 MAXBYTES                                 NUMBER
 MAXBLOCKS                                NUMBER
 INCREMENT_BY                             NUMBER

In 7.3 it can be found by joining sys.filext$ with dba_data_files:

SQL> desc sys.filext$

 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE#                           NOT NULL NUMBER
 MAXEXTEND                       NOT NULL NUMBER
 INC                             NOT NULL NUMBER

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> NOTE: if autoextend has NEVER been used in your database, then the table filext$ will *NOT* exist. filext$ is dynamically created the first time you autoextend a table -- if it does not exist, no files are using autoextend.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Dec 14 1998 - 12:36:18 CST