Home » SQL & PL/SQL » SQL & PL/SQL » Create View won't work
Create View won't work [message #18964] Fri, 22 February 2002 20:16 Go to next message
diaz
Messages: 58
Registered: October 2001
Member
i build a view like this :

create view viewme as

select a.msisdn, eop, jumtag, tgllunas, jumbyr, tglbayar, region
from tagihan01 t, regional, cdra.activation a, pembayaran01 p
where kode_reg='01' and rtrim(a.msisdn)=rtrim(t.msisdn)
and rtrim(a.msisdn)=rtrim(p.msisdn)
and to_char(tglbayar,'YYYYMM')=eop

but it said that :

ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 13

i've checked that all the tables are exist..
then why the message appear ??

i tried to put this on pl/sql code.. doesn't work either..

please help.
Re: Create View won't work [message #18966 is a reply to message #18964] Fri, 22 February 2002 21:21 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
did u get select privilege on cdra.activation table directly (not thorugh role)?.

connect to cdra schema

Sql> grant select on cdra.activation to yourviewowner
Re: Create View won't work [message #18968 is a reply to message #18964] Fri, 22 February 2002 22:01 Go to previous messageGo to next message
diaz
Messages: 58
Registered: October 2001
Member
thanks for the reply,
the cdra.activation is the synonim to the table activations in cdra .. and when i do selection is ok, the result is returned
so, what should i do ?
Re: Create View won't work [message #18973 is a reply to message #18968] Sat, 23 February 2002 16:21 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
you need to get privilege directly from activation table or synonym owner to use in any stored objects (views,procedures,functions).

i think you got SELECT privilege on that synonym through role assigned to your user account.

HTH
Suresh
Previous Topic: sqlldr error : please help
Next Topic: group function
Goto Forum:
  


Current Time: Thu Mar 28 18:31:44 CDT 2024