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, you can't reply to this topic. It has been closed.

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.