Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop table

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US