Create View won't work [message #18964] |
Fri, 22 February 2002 20:16 |
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 #18968 is a reply to message #18964] |
Fri, 22 February 2002 22:01 |
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 |
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
|
|
|