Re: how to find unused table /columns in a database

Same answer as in the other group... but I will make it more sincere:

DO NOT DO IT YOU WILL GET FIRED, TERMINATED, SACKED, CANNED, REMOVED FROM EMPLOYMENT, You will be become the "You won't BELIEVE what the guy you replaced did" comment for everybody that is interviewed for your job.

You will appear on http://oracle-wtf.blogspot.com/

You will become the laughing stock of all of the people in your company. You will be forced to leave the country and move someplace else where your family will not be happy and you will not be able to practice your religion in peace and tranquility like you should be able to do.

Leave the table,columns,data there.

If it is a developer leaving stuff behind, go and find the developer(s), light a fire under its butt and tell it to remove the extra stuff from your database.
Then when THEY remove something in production, THEY get fired, YOU get to restore it and YOU are the hero instead of the zero.

:)

http://yaodba.blogspot.com/ Received on Fri Mar 17 2006 - 08:29:57 CST