Re: Redo/Transaction Log
Date: Sat, 19 Jan 2002 05:12:52 GMT
Message-ID: <of728.6025$5Z6.91782_at_rwcrnsc54>
No. If you add data to a table and then delete it the space has been
allocated to the table and hence looks used. If you then add data to the
table it will use the already allocated space until you need more.
Jim
"bjh" <bjhhbj_at_yahoo.com> wrote in message
news:92e42823.0201181157.bee9036_at_posting.google.com...
> I'm asking this question from a SQL Server perspective, so I apologize
> if I don't have the Oracle terminology correct.
>
> In SQL Server, you can truncate the transaction log periodically to
> preserve space when you run very large update statements.
>
> In Oracle, is there a way to truncate the Redo logs? I have run a
> series of update statements and delete statements against an Oracle
> database. I noticed that the space availabe has decreased even though
> the number of records in the database is drastically lower. I assume
> this is due to a large Transaction/Redo log created by the updates.
>
> I would like to recover this space before proceeding.
Received on Sat Jan 19 2002 - 06:12:52 CET