DBA Tools

Drop 4TB table on dictionary managed tablespace

    I got a chance to drop a 4TB size table on dictionary managed tablespace (DMT), this table comes from a very old design, and the partition design is not good for data purge, and delete cannot catch up...

Posted on December 22, 2007 5:30 PM

Use MyLOG to fasten the recovery of drop operation

    I got some requests of data recovery by drop operation, including drop tables and drop tablespaces and drop schema. For this kind of recovery, the most complex step is to map the table with the data object id...

Posted on September 21, 2007 2:25 PM

Operation through Oracle Enterprise Manager (OEM) is dangerous

    I heard a bad news from someone that one of his colleagues dropped an Oracle schema by mistake in Oracle Enterprise Manager (OEM), because the OEM seems in hang status, so they did some random mouse clicks or...

Posted on September 20, 2007 9:02 PM