Re: drop table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Dec 2004 05:15:53 -0800
Message-ID: <1103289353.787704.100040@f14g2000cwb.googlegroups.com>

Why would you want to undo a drop table? Either the table is no longer needed or it is still needed and should not be dropped.

If you are unsure of the request to drop a table has been properly researched then make an export of the table prior to dropping it. In the event some process or user wants the table back then you can use import to restore the table and all its associated objects: indexes, constraints, triggers, and grants.

The 10g recycle bin feature has significant space costs associated with it.

No production applications, jobs, or users should be logging on as object owners so the ability to drop a table should be limited to very few priviled users (DBA's).

HTH -- Mark D Powell -- Received on Fri Dec 17 2004 - 07:15:53 CST