Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table does not exist when creating a view
Message
De
03/11/2000 04:28:49
 
 
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00437291
Message ID:
00437527
Vues:
21
Hi Lorne, How's it going in Comox.
I'm a UVIC grad. My gramma lives in Comox...
Ski much at washington?


I think it's either...

a) A permissions problem..

I had a similar problem with a Stored procedure.
It had something like

select xyz from sysadm.styles where ....

in it and I was creating it under user lingerie.

I had to login as sysadm
and do...
grant select,insert,update,delete on styles to lingerie;

What I noticed is that if I grant to the role instead it did not work..

Anyways try granting select on the Master table to the user..

b)Maybe the table itself is named in lower or upper case.
This happened once when I used the VFP upsizer...

Usually on oracle all names are upper case in the data dictionary...
But some tables were lower case you can see it if you query
select table_name from user_tables;

It's either called "master" or "MASTER".

Then either:
create "MASTER" as select * from "master";
and then drop "master"

HTH
Get the point?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform