Re: newbie : Rollback tablespaces
From: Paul Smart <psmart_at_aus.sig.net>
Date: Tue, 28 Apr 1998 18:39:18 -0500
Message-ID: <6i5p9r$221$1_at_news13.ispnews.com>
Date: Tue, 28 Apr 1998 18:39:18 -0500
Message-ID: <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 Wed Apr 29 1998 - 01:39:18 CEST