Re: I can't accessing existing view !
Posted by: Peter Brawley
Date: June 22, 2022 10:38AM

One possibility: privileges. Run the remote query ...

show tables;

Is the view there?

Run ...

show grants;

... to see what privs you have there.

Another possibility: case sensitivity ... is your local db on Windows, and does the view name have capital letters in it?



Edited 1 time(s). Last edit at 06/25/2022 10:47AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: I can't accessing existing view !
June 22, 2022 10:38AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.