Re: 9i dba_data_files

I believe you can use the following:

Log in to sys as sysdba

SQL> connect sys/<password> as sysdba
SQL> select name, bytes, status from v$datafile;

It will list all db datafiles in the database.

"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 - 22:24:23 CST