-
Hi!
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.
Example:
select * from v$tablespace;
it returne:
TS# NAME
--------------
0 System
1 User01
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?
Thank you.
Best regards.
Yan.
-
you have to run catalog.sql to generate these views
-
Hope you are not connecting as a different user while viewing from DBA_VIEWS !!
-
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
-
Spesial thanks to Pando!
Thank you very much!
You are right. When I executed the catalog.sql, all dba_XXX view began to work.
Thank you for advice.
Yan.