Urgent Help in Creating View..

[Oracledba8]

Can any one please let me know why I can't view, even I have the Dba Priviliges, RECOVERY_CATALOG_OWNER Priviliges and Imp_Full_Database

and all of thses Roles have Create any View.

Here is the Query.
create or replace view tbv
as select TABLESPACE_NAME,
sum( BYTES) allocated_space
from dba_data_files
group by TABLESPACE_NAME;

Gives that Object Does not exits
But if I Issue this select statement, that works fine.

Thanks in Advance.

[rcaballe]

You can't create "fixed" object with privileges granted by a role.
That's because roles can be enabled/disabled and if you could create a fixed object that feature would be meaninless.
So, if you want the view, connect as sys and grant yourself privileges on the v_$ views
I hope I'm clear

[Oracledba8]

Thanks Ramon,

What do you mean give the Priviliges on V$... Is there some specific View that I need to have privilege on to create any other view on those.

Thanks ..

[rcaballe]

Never mind.
I was confused because long time ago I was able to create a procedure select v$session only when I granted select on v_$session.
Anyway, enter as sys and grant to the user select on dba_data_files, I tested it and it worked.