Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-1933 on create view

ORA-1933 on create view

From: Olivier Bercovitz <oberco_at_club-internet.fr>
Date: 1998/03/19
Message-ID: <35118703.4317B428@club-internet.fr>#1/1

Hello everybody,

on a database (V7.1.6) , connected as system, I try to do this :

create or replace view temprpt_free as select tablespace_name,sum(bytes) free
from sys.dba_Free_space
group by tablespace_name;

and I have the error : ORA-1933 : cannot create a stored object using privileges from a role

What can I do ? which grant ? (I have dba role granted)

Thank for your help (please don't send me the explanation of the error from the Messages Manual ! I read it :-) )

Olivier Received on Thu Mar 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US