Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    14

    Unanswered: data dictionary views using datalink

    Is it possible to access user_views of remote database

    when i m trying e.g.
    desc dlrkel.user_views@kmcl_dlrkel

    it gives message object does not exist.

    wether it is possible or not?

    thanks
    abhijit.

  2. #2
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    user_views is a system view, it's not owned by schema dlrkel

    Try looking at all_views:
    select owner, count(*) from all_views@kmcl_dlrkel group by owner;

    It depends on how your db link is defined, as to what user you are on the remote database - and so what user user_views is giving you

  3. #3
    Join Date
    May 2006
    Posts
    14
    thanks.
    abhijit.

Posting Permissions

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