It’s a relational database, so it’s only a matter of time before you stumble across an object that’s dependent on another object, right?
If you are looking at a table in the browser, be sure to check out the ‘Dependencies’ page. This page displays the database objects that will be upset if the selected table were to ‘go away.’ You’re probably familiar with these related objects, but if not, then there’s a quick ‘trick’ to investigate further.
Let’s take a look at SH.SALES as an example:
This takes me to SH.CAL_MONTH_SALES_MV, a materialized view.
When I’m done poking around, I might want to go back to my SALES table.
The ‘Back’ and ‘Forward’ buttons on the main toolbar serve as my Most-Recently-Used tree navigation buttons.