I am trying to access the dba_data_files table to find out if autoextendmy data files are included . However, although I am using Oracle 10g, this table does not seem to 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 another way to check and even change if the data file for a specific table space has an auto-extension option?
source
share