As far as I know (mainly 9.2) the direct answer is 'No'.

However, you can take the tablespace out of logging mode, which would
not generate redo logs, which would not generate archive logs.

Of course, you can not PIT restore/recover that tablespace either...



Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


From: Faris Michael
[mailto:oracledba-ezmlmshield-x9887677.[Email address protected]
Sent: Thursday, September 06, 2007 09:26
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

Oracle LazyDBA home page