Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disabling Archiving in Oracle 9i

603447Dec 13 2010 — edited Dec 14 2010
Have checked google and found out how can I see if archiving is enabled on Oracle 9i:

Select NAME,
CREATED,
LOG_MODE,
CHECKPOINT_CHANGE#,
ARCHIVE_CHANGE#
from V$DATABASE;

NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#
ORCLDB *11/21/2007 4:17:56 PM ARCHIVELOG 8762540610649 *8762539839755


Need help on how to disable archiving. Hope someone can provide me the detailed steps. Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2011
Added on Dec 13 2010
#9i, #database, #general-database-discussions, #windows
2 comments
328 views