Question on view
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Question on view

  1. #1
    Join Date
    Dec 1999
    Posts
    217

    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)
    AS
    SELECT COMPANY, FREEQTY, ACTUALSTARTDATE
    FROM TIM.ABCDETAILS@PROD_B;

    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.

    Chintz

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    Connections to the production instances should be made via virtual IP.

    See below:


    Primary Standby
    db1.domain.tld db2.domain.tld


    \ /
    db.domain.tld (interface db.domain.tld brought up on primary)
    |
    |
    |
    |
    |
    connections made via db.domain.tld
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width