0

I want to delete a table from the database, which I know is not being used anywhere in our Java code-base. I was able to also delete it from our DB, but I'm not sure that this may not still pose some kind of problem. Maybe it can still be referenced from a Stored Procedure, or something of the like?

Or does the database actually guarantee that under any circumstance this will not be the case when deleting a table? In case it may be a problem, what would be the best way to search for this specific string in the db such as to find its possible usages?

Unfortunately I don't have dba access to this db.

Thanks

Improve this question

2 Answers 2

Reset to default
1

no such guarantee

but you can run this to find any reference to the table in a stored procedure, package or function

select * from dba_source where lower(text) like '%<tablename>%'
Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Unfortunately I don't have DBA access to the DB :-(
Query user_source instead, doesn't need DBA access.
0

I think there are 2 reference of table you need to care about.

  1. Dependencies (in table browser, sql navigator/toad has, not sure about others)

  2. Dynamic sql call that table in procedure/function/package. Refer here

But those're not all, because some dynamic sql may use string concatenate 

execute immediate 'select max(name) from customer_' || provinceCode into testName;
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.