sqlplus / as sysdba select * from dba_data_files not exists

Oct 23, 2018 4:55PM

restored a database from another host, after open, it queries ok with user tables views, but for dba_data_files view, does not exist, thought exists dba_users;

SQL> alter database open resetlogs;

SQL> exit

> sqlplus / as sysdba

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 23 16:41:45 2018

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production

With the Partitioning and Data Mining options

SQL> select name from v$database;

NAME

---------

xxxxxxx

SQL> select USERNAME from dba_users;

........

33 rows selected.

SQL> select * from dba_data_files;

select * from dba_data_files

*

ERROR at line 1:

Database Administration (MOSC)

sqlplus / as sysdba select * from dba_data_files not exists

Howdy, Stranger!

Category Leaderboard

Top contributors this month