Redo/Transaction Log
From: bjh <bjhhbj_at_yahoo.com>
Date: 18 Jan 2002 11:57:03 -0800
Message-ID: <92e42823.0201181157.bee9036_at_posting.google.com>
Date: 18 Jan 2002 11:57:03 -0800
Message-ID: <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.