Oracle dba_data_files table doesn't exist

Question

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?

score 17 · Accepted Answer · answered Sep 14 '09 at 18:33

17

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.

answered Sep 14 '09 at 18:33

dpbradley

11,645
31
34

1

Thanks - it never occurred to me that it would say "table or view does not exist" if it did actually exist and I merely didn't have permission to view it. – Eli Courtwright Sep 14 '09 at 18:53

score 1 · Answer 2 · answered Sep 14 '09 at 18:35

1

You should be able to do this through the oracle enterprise manager under Administration

answered Sep 14 '09 at 18:35

moleboy

884
1
10
17

Oracle dba_data_files table doesn't exist

2 Answers2