Find the Impact for Procedure Change

How do you find the impact for the change and how to find the tables which are connected to this procedure or package?
  • Interview Candidate
  • 6
  • 5538

Showing Answers 1 - 6 of 6 Answers

Arundhati

  • Apr 20th, 2017
 

You can check ALL_DEPENDENCIES, DBA_DEPENDENCIES, user_DEPENDENCIES

  Was this answer useful?  Yes

Nand Kumar Sahu

  • Jul 13th, 2017
 

You can check any object which is going to referred by any other objects using dba_dependency data dictionary.
SELECT * FROM dba_dependencies WHERE refereced_name = OBJECT_NAME;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions