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


Oracle LazyDBA home page