No, Oracle does not support taking an entire tablespace out of
archivelog mode when the database is in archivelog mode.

What is possible though is to do some table inserts in a "nologging"
mode, so they do not generate redo log (and ultimately) archive log
activity.

You first have to do "alter table [table_name] nogging" and you can also
do:
"alter index [index_name] nologging" commands for each index on the
table.

Then if the inserts are based on a select from another table or view,
you can use this syntax:
"insert /*+APPEND */ into [table_name] select ... from ..."

Or, you can use SQL*Loader in direct-path mode to avoid generating redo.

You cannot avoid redo generation though for insert statements that come
from an application, or for updates.

-----Original Message-----
From: Faris Michael
[mailto:oracledba-ezmlmshield-x9887677.[Email address protected]
Sent: Thursday, September 06, 2007 10:26 AM
To: LazyDBA Discussion
Subject: Can you take a tablespace out of archive mode?

Hello,

I've got a database running in archive mode that we
eventually use to build a reporting database. We now have a few
tablespaces in the original database that are being updated enough to
create lot's of archive logs. The number of archive logs is starting to
delay the 'recovery'/building of the report database. I'd like to remove
these tablespaces from the archiving process so the number and size of
the logs is much less, there by allowing the report database to be built
quicker. Is it possible to remove a tablespace from the archive mode
process? Do I have to take the tablespace out of archive mode from the
get go or is it something I need to do with in the 'recovery'/build
process of the report database?



Thanks, any and all help is appreciated.



Michael Faris



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page