Re: How to see if tablespace is autoextend?

u didn't really look:

SQL> desc dba_data_files

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

On Wed, 30 Apr 2003 21:49:16 GMT, Peter <peter_at_nomorenewsspammin.ca> wrote:

>Which table should I query if I want to see if a tablespace is set to
>autoextend? I could not find relevant information in v$datafiles or
>dba_data_files.
>Thanks
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Apr 30 2003 - 17:11:28 CDT