Menu
I've been trying to access the dba_data_files table to see whether the autoextend is turned on for my data files. However, even though I'm using Oracle 10g, this table seems to not exist:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-00942: table or view does not exist
Is there some other way to check and even change whether a data file for a particular tablespace has the autoextend option turned on?
428
DBA_DATA_FILES describes database files. Note: When you query the DBA_DATA_FILES data dictionary view, Oracle must have access to all tablespaces and their data files if the requested information is not already available in the dictionary.
NUMBER. Maximum file size in blocks. INCREMENT_BY. NUMBER. Number of tablespace blocks used as autoextension increment.
If you have autoextensible datafiles then you will have MAXBYTES set to the maximum file size you specify when creating the datafile. If you do not use all of that file then you will have MAXBYTES bigger than BYTES. Thats the case when the MAXBYTES will be 0 and logically, yes, the BYTES will be greater than MAXBYTES.
You should make sure you're connecting with an account that has privileges to see this view - try the SYSTEM account if you have that password, otherwise have your DBA grant the SELECT_CATALOG_ROLE to the account you are using.
68
You should be able to do this through the oracle enterprise manager under Administration
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
