Re: Archive Logs Filling Drive Up

Chris Forbis wrote:

> 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

Check if DB objects in that tablespace have NOLOGGING attribute as well. Tablespace attribute is used as a default for DB objects only if you don't set it explicitly. Can you use temp tables? They don't create log records at all. If not, try to use direct load when inserting (append hint). Received on Wed May 30 2001 - 22:43:40 CDT