Archive Logs Filling Drive Up

From: Chris Forbis <chrisforbis_at_yahoo.com>
Date: 30 May 2001 17:57:09 -0700
Message-ID: <f2dc430d.0105301657.4dd8c63a@posting.google.com>

I have Archive Logging on on a 8.1.7 database. I have many users on this. Each user has tables in USERS tablespace. All is good. Archive logs are kept for backup recovery. All seems work work well.

I added a new TableSpace (NAME=NOLOGSPACE) When I created this TABLESPACE I added the NO LOGGING option. When I look at it in DBAStudio or any table in it it says LOGGING is off. This tablespace is a Locally Managed TableSpace. Also in DBA Studio it says next to the No Logging that this will keep inserts/updates/and deletes from beging logged.

The problem: I went from 2 meg a day of Archive Logs :) Not much besides selects being done. To the now 1.2 gig a day. (I don't have the space for this) I need the User TABLESPACE and system to be logged, but the NOLOGSPACE is also being logged. It gets 100,000's of inserts a day, and also just as many deletes The whole TableSpace is only 75meg. Any idea how to fix this issue?

Thank you
Chris Received on Wed May 30 2001 - 19:57:09 CDT