I have one problem , and I can't find the solution.
I built manually database, that has 2 tablespaces (system and user01).
I can start it up, and connect as internal.
When I use SELECT with V$ dynamic requests, it's working.
select * from v$tablespace;
But, when I try to run SELECT DBA_something, it returns error:
select * from dba_data_files;
ERROR at line 1
ORA 00942: table or view does not exist.
And request that consist of SELECT * from dba_somethink return same error?!!!
Perhaps it looks silly, but I can't find the explanations (I just begin to study Oracle).
Can somebody help me?
06-23-2002, 08:24 AM
you have to run catalog.sql to generate these views
06-23-2002, 09:11 AM
Hope you are not connecting as a different user while viewing from DBA_VIEWS !!
06-23-2002, 09:16 AM
well if the user you are using can see v$ views you should be able to see DBA_XXX, if you cannot then most probably is you have not run catalog.sql
06-24-2002, 04:25 AM
Spesial thanks to Pando!
Thank you very much!
You are right. When I executed the catalog.sql, all dba_XXX view began to work.