nmanser_at_progis.de (Manser) wrote in message news:<2178d61f.0305161036.952ae84_at_posting.google.com>...
> Hi oracle folks,
>
> I am running oracle 8.1.7 on an alphaserver 1000 with OpenVMS 7.3
>
> SQL> select tablespace_name,bytes from dba_data_files;
>
> TABLESPACE_NAME BYTES
> ------------------------------ ----------
> SYSTEM 209715200
> RMAN_TS 20971520
> RBS01 5242880
> USERS01 2097152
> TEMP01 2097152
> KLIMA 7340032
> KONTO 2097152
>
> 7 rows selected.
>
> SQL>
> SQL> create view tablespace_alloc
> 2 as select tablespace_name,bytes from dba_data_files;
> as select tablespace_name,bytes from dba_data_files
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
>
> i don't understand ora-00942 , the table exists, see the query on top.
> can anyone tell me what's going on
>
> thanks for any help.
Your access to the view dba_data_files is granted through a role, like
BDA, yes?
You can not create a view on top of a table whose select privilege is
granted to you through a role. If you do a direct grant, it would
work.
Received on Fri May 16 2003 - 18:09:41 CDT
