Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Unanswered: Cannot see new columns to linked database

    I have a link in a Oracle database to a SQL 2005. The link works fine, I can perform DML commands without a problem. However, if I add a new column to a table in SQL, Oracle does not recognized it, it only reads columns that I read in the first query that I executed from Oracle. What could be the problem? I recreated the database link, but it does not fix the problem.

    Any advice will be appreciated.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >What could be the problem?
    CaSeSenSitivity or lack thereof

    If you used CUT & PASTE so we could actually see what you see, perhaps we'd have a better idea.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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