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
group by TABLESPACE_NAME;
Gives that Object Does not exits
But if I Issue this select statement, that works fine.
Thanks in Advance.