Drop selected objects (demo tables) from user_tables as sys
Posted on 2011-03-08
Dear experts and dbas,
I discovered that there is a vast number of users in our Oracle instance, that have the oracle demo tables (demo_customers, emp, salgrade etc) installed.
Since it takes a while to delete them all manually for each user, I'd like to know how I can drop these tables and correlated objects such as triggers, indizes and views at once.
Do you have a script to select a number of tables and delete all associated objects for these tables?
Please be so kind and share your knowledge with me!