-
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
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
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|