Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    87

    Question Unanswered: dependencies- confused..

    hi,

    please check the follo.

    SQL> desc dba_dependencies;
    ERROR:
    ORA-04043: object "SYS"."DBA_DEPENDENCIES" does not exist

    similarly

    SQL> @utldtree.sql
    SP2-0310: unable to open file "utldtree.sql"

    can anybody explain me briefly about what is this
    DEPENDENCIES all about?

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Are you logged on as SYS when looking at dba_dependencies ???

    As far as utldtree.sql ... ensure you use the full directory path ...
    usually .... \rdbms\admin\utldtree.sql


    HTH
    Gregg

  3. #3
    Join Date
    Nov 2003
    Posts
    87
    hi can u tell me whats this error?

    SQL> conn sys as sysdba
    Enter password: ******
    ERROR:
    ORA-12560: TNSrotocol adapter error


    thanx

  4. #4
    Join Date
    Aug 2003
    Location
    Guwahati, India
    Posts
    33
    hi,

    Your connect string is not mentioned if I am correct.
    please create connect string if you are into windows clients.

    SQL> connect sys/{passwd}@{connect string}

    Please reply if you are successful !
    G J Shankar Nath
    IT Consultant, Vedswasti Services Pvt. Ltd
    Guwahati-781007
    India

Posting Permissions

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