Re: newbie : Rollback tablespaces
From: joachim Carlsson <IKEA-joachim.carlsson_at_neurope.ikea.com>
Date: Mon, 4 May 1998 14:13:09 +0200
Message-ID: <6ikbjt$bci$1_at_mailgate.ikea.com>
Date: Mon, 4 May 1998 14:13:09 +0200
Message-ID: <6ikbjt$bci$1_at_mailgate.ikea.com>
Truncate is good if you want to delete the whole table.
If you don't want to delete everything write a cursor. and commit after having deleted 1000-10000 rows.
Regards
/Joachim
Paul Smart wrote in message <6i5p9r$221$1_at_news13.ispnews.com>...
>
>>There are two ways to go:
>>
>> Make your transactions smaller by committing more often.
>
>I'm commiting after every transaction at the moment. Its just deleting a
>lot of records from several tables and the segments and extents just keep
on
>growing .... until ... boom!
>
>>
>> Use the SQL TRUNCATE TABLE to get rid of everything without rollback.
>
>I'll give this a go. I haven't heard of this before, thanks
>
>Paul
>
>
>
Received on Mon May 04 1998 - 14:13:09 CEST