4 Replies Latest reply on Sep 24, 2009 3:09 PM by Ram Yelamanchilli

    problem with importing views from a different schema

    Ram Yelamanchilli Newbie

      I'm logging in using schema "XYZ" to Oracle and importing a view from "XYZ1" schema which XYZ has access to. I did this using designer. I get an error while querying the view saying "Table or View does not exist.".

      However I saw the indexe files are populated correctly with all column information. If it is a TABLE object instead of a VIEW, it's working fine.

      Regards

      Ram