SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to know about the system table

9876564May 20 2015 — edited May 21 2015

Dear All,

Could anyone please let me know , if i have a table say X , now i need to search where-all this table is being used ( i mean all the procedures,Function) which system table can be used?

I am using V$SQLTEXT but i think it has information about the objects that are there in Shared memory.

Absheikh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2015

Added on May 20 2015

8 comments

1,174 views