Re: extremely long

The correct syntax is:
set transaction use rollback segment <rbs name> <transaction: dropping>
commit;

Put the commit at the end because the word "commit" will stop the current transaction and commit all the changes! When the transaction ended, Oracle will release the rollback segment that you specify to use. So, never commit before you run your drop.

Winnie

Chris Kempster wrote in message <6q6jk5$r3h$1_at_news.cowan.edu.au>...
>Create a massive rollback segment, then in SQL*Plus, do a:
>
>set transaction <???> <specify rollback seg to use>;
>commit;
>
>(sorry, I cant quite remember the syntax)
>
>then start the drops.
>
>This will force the session to use the large rollback seg.
>
>Make sure you dont have archive logging ON, if your archive_dest becomes
>full the DB will hang.
>
>Apart from that, kill all jobs on server, clear out the rollback segs and
>temp seg, startup DB in restricted mode and start the drops again.
>
>
>howard lee wrote in message <6q6i7i$f5t2_at_news.hk.linkage.net>...
>>hi
>>
>>where a try to drop packages from my oracle server, it hangs up after i
>>deleted several packages. all i can do is to shutdown the instance and
>>start it up again. then i can survive for serveral more deletions before
>>hanging up again. i have already increased temp segment and rbs to 100M
>>each. but nothing improved.
>>
>>could anyone give me some advice?
>>
>>thanks
>>howard
>>
>>
>
>
Received on Tue Aug 04 1998 - 22:15:33 CDT