Question on view
I have 2 instances on the production server "PROD_A" & "PROD_B". I have a view on my PROD_A instance:
CREATE OR REPLACE VIEW SCOTT.ABC_DETAILS
(COMPANY, FREEQTY, ACTUALSTARTDATE)
SELECT COMPANY, FREEQTY, ACTUALSTARTDATE
So, realistically this view resides on PROD_A and gets populated with data from PROD_B.
At the same time I have another server that has the standby databases for both these environments.
The problem I am having is that instead of pulling the data from the primary PROD_B database it is pulling it from the standby PROD_B database.
I checked the tnsnames file on the server it is pointing to the correct server.
WHere else should I look?
Any input will be greatly appreciated.
Connections to the production instances should be made via virtual IP.
db.domain.tld (interface db.domain.tld brought up on primary)
connections made via db.domain.tld
Fast, Cheap, Reliable... Pick Two(2)
Click Here to Expand Forum to Full Width