Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Balaji .

Asked: February 19, 2025 - 12:23 pm UTC

Last updated: February 24, 2025 - 11:11 am UTC

Version: Version 22.2.0.173

Viewed 100+ times

You Asked

Hi
We are looking to take a schema(abc) from our database to to a different server with a new schema name.
I am looking to find what are the dependencies on the abc schema in our packages/procedure/functions
and is there anything else i should be looking at.


regards,
Balaji

and Connor said...

I would start with DBA_DEPENDENCIES, ie

select *
from dba_dependencies
where referenced_owner = 'ABC';


which will cover more things (views etc).

And also, a good trawl your source code control system as well.

Rating

  (2 ratings)

Comments

Artificially intelligent spam?

Stew Ashton, February 24, 2025 - 7:39 am UTC

So this is new: use AI to generate a plausible answer to the question, then use that "answer" as a hook to get clicks. What next?
Chris Saxon
February 24, 2025 - 11:11 am UTC

Indeed; I've removed the spam answer.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library