Yes, Walter is correct, you can set "nologging" at either the tablespace
or the individual table or index level.

However, this "nologging" only applies to the restricted types of
inserts that I described in my earlier message.

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

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


---------------------------------------------------------------------
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