Re: 9i dba_data_files

The query is fine and should work in 9i if you are logged on as sysdba or have the appropriate privileges. Maybe try to prefix it with sys, although this normally wouldn't be needed as sysdba.

select * from sys.dba_data_files;

to see if that makes any difference.

You have obviously run the following scripts:

@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

"Ginger Mall" <bocgco_at_hongkong.com> wrote in message news:3e5448b5_at_shknews01...
> I am exec the following in sqlplus for Oracle 9i :
>
> select * from dba_data_files
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> Am I missed sth or it's not supported in 9i ?
>
>
Received on Wed Feb 19 2003 - 21:54:16 CST