Title: I am initializing a r8.2 Mart and I got the error ORA-00942 table or view does not exist. I reviewed the Oracle tracing file, but the selected table does exist. Why am I getting the error?
I initialized a r8.2 mart and I got the error: ORA-00942 table or view does not exist. I then turned on the Oracle database trace. The trace file showed that the error occured when running the following statement:
Select tablespace_name "name", TO_CHAR(sum(bytes)/(1024*1024)) "db_size"
from sys.dba_free_space group by tablespace_name
However, the table sys.dba_free_space does exist in that Oracle database. Why am I getting the ORA-00942 error?
On first look, it appears like sys.dba_free_space is a missing table. However, that is actually a privileges issue. If you run the above SQL statement directly in your Oracle database while logged in as the same user who is initializing the mart, you will get the same error, even though you see table sys.dba_free_space does exist in the database.
The ORA-00942 can occur when the user does not have select privileges (and possibly more) on the table.
For further information on this topic, please see your Oracle DBA.