elmerfud wrote:
> Originally posted by elmerfud
>
>>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?
>
>
> I should have added that we are using 8.1.7.2.
>
> --
> Posted via http://dbforums.com
1. disable table constraints
2. truncate table xxx;
3. drop table xxx;
Frank
Received on Tue Jan 14 2003 - 14:47:09 CST