dependencies- confused.. [message #10053] |
Mon, 29 December 2003 02:14 |
resy
Messages: 86 Registered: December 2003
|
Member |
|
|
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?
|
|
|
Re: dependencies- confused.. [message #10054 is a reply to message #10053] |
Mon, 29 December 2003 02:52 |
Frank Naude
Messages: 4579 Registered: April 1998
|
Senior Member |
|
|
Hi,
DBA_DEPENDENCIES shows all dependencies in the database between procedures, packages, functions, package bodies, and triggers, including dependencies on views created without any database links.
You need to connect to a DBA account before you can describe it.
The "utldtree.sql" file is in your ?/rdbms/admin directroy. Try:
ed ?/rdbms/admin/utldtree.sql
Best regards.
Frank
|
|
|
Re: dependencies- confused.. [message #10055 is a reply to message #10053] |
Mon, 29 December 2003 03:10 |
|
Barbara Boehmer
Messages: 9090 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
DBA_DEPENDENCIES describes all dependencies in the database between procedures, packages, functions, package bodies, and triggers, including dependencies on views created without any database links. Its columns are the same as those in "ALL_DEPENDENCIES".
You need to have select privileges on dba_dependencies in order to view it, so:
CONNECT SYS/sys_password AS SYSDBA
GRANT SELECT ON dba_dependencies TO your_username;
Then you can:
scott@ORA92> desc dba_dependencies
Name Null? Type
----------------------------------------------------- -------- -----------------
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
TYPE VARCHAR2(17)
REFERENCED_OWNER VARCHAR2(30)
REFERENCED_NAME VARCHAR2(64)
REFERENCED_TYPE VARCHAR2(17)
REFERENCED_LINK_NAME VARCHAR2(128)
DEPENDENCY_TYPE VARCHAR2(4)
The utldtree.sql file should be in a sub-directory of your Oracle home. You can search your system for the file. For example, my Oracle home is d:OracleOra92 and my utldtree.sql file is in d:OracleOra92rdbmsadminutldtree.sql. So I would:
@d:OracleOra92rdbmsadminutldtree.sql
You can also edit that file, being careful not to save any changes, in order to read exactly what it does and how to use it:
EDIT d:OracleOra92rdbmsadminutldtree.sql
For more information, you can search the Oracle on-line documentation for dba_dependencies and utldtree and so forth. Here is a link to a handy menu for searching the on-line documentation:
|
|
|
Re: dependencies- confused.. [message #10057 is a reply to message #10055] |
Mon, 29 December 2003 19:36 |
resy
Messages: 86 Registered: December 2003
|
Member |
|
|
hi,
when i give the following, i got that error.
SQL> conn sys as sysdba
Enter password: ******
ERROR:
ORA-12560: TNS:protocol adapter error
here my password is 'sysdba'.
whatz this problem?
|
|
|
Re: dependencies- confused.. [message #10060 is a reply to message #10057] |
Tue, 30 December 2003 03:29 |
|
Barbara Boehmer
Messages: 9090 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
It works for me:
scott@ORA92> conn sys as sysdba
Enter password: ************
Connected.
scott@ORA92> @login
sys@ORA92>
You may need to include your connect string, like:
conn sys@ora92 as sysdba
Check your tnsnames.ora file to see what connect string your system is expecting.
|
|
|