Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Tables drop slowly
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.comReceived on Tue Jan 14 2003 - 06:55:52 CST