Oracle 7.3.4 & file autoextend

Hi,

In Oracle 8.x.x, we can see if the tablespace could auto-increase using the view : DBA_DATA_FILES (AUTOEXTENSIBLE column). What about Oracle 7.3.4 (I am working on some Oracle 7.3.4 BDs and I would like to now if FILE AUTO ENTEND is ON or OFF...).

Thanks

Sofiane

Check the sys.filext$ table

HTH,
David.

Hi,

I tried with sys.filext$ :

SQL> desc sys.filext$
Object does not exist.


Any idea...

Thanks

Sofiane

Quote from the Managing Data Files section of the 7.3.4 Server Administrators Guide:

Setting your datafiles to extend automatically results in the following:


reduces the need for immediate intervention when a tablespace runs out of space

ensures applications will not halt because of failures to allocate extents

creates FILEXT$, which contains information about the autoextend characteristics of a datafile

Note: FILEXT$ is not created with the data dictionary scripts, so there is no easy way to create database views on it. Thus, catalog scripts will be unsuccessful if you attempt to create a database view on FILEXT$. FILEXT$ is the only place you can query where datafiles have autoextend turned on, and the current settings of their parameter values.

--End

My guess is that the files are not set to autoextend - assuming that you described the table from a user with access to objects in the SYS schema.

Thanks Dave_A

Sofiane