Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table does not exist when creating a view
Message
From
03/11/2000 04:28:49
 
 
To
02/11/2000 14:43:39
General information
Forum:
Oracle
Category:
Other
Miscellaneous
Thread ID:
00437291
Message ID:
00437527
Views:
19
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform