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

Home -> Community -> Usenet -> c.d.o.misc -> Tables drop slowly

Tables drop slowly

From: elmerfud <member22539_at_dbforums.com>
Date: Tue, 14 Jan 2003 12:55:52 +0000
Message-ID: <2385791.1042548952@dbforums.com>

We are attempting to run a 5 gig script alter script which creates a temp table and populates the temp table with data from another table. The script will then drop the old table and rename the temp table to the old table name. The issue we have is Oracle seems to hang on this statement:
SELECT c.owner#, c.name, c.con#
  FROM con$ c, cdef$ d
 WHERE d.obj# = :1
   AND d.con# = c.con#

The command being executed at the time is the 'drop table XXXX' statement. This occurs on all tables in the script, including zero row tables. Any ideas on how to improve the performance of dropping a table?

--
Posted via http://dbforums.com
Received on Tue Jan 14 2003 - 06:55:52 CST

Original text of this message

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