Disable archive logging in Oracle

sqlplus “/as sysdba”
SQL> SHUTDOWN;
SQL> STARTUP MOUNT EXCLUSIVE;
SQL> ALTER DATABASE NOARCHIVELOG;
SQL> ALTER DATABASE OPEN;
SQL> ALTER SYSTEM SET “_disable_logging”=TRUE;
SQL> EXIT;

Posted January 8, 2007 | Filed under Oracle Scripts General [permalink]

Leave a Reply

You must be logged in to post a comment.


News Categories

Tutorials and Docs

Sponsors

Syndicate DBA Place

Search

Archives

September 2010
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
27282930  

Sponsors

27 queries. 0.143 seconds