38149 views
Registered: 2009-04-15
Update:
Problems: 1
Solutions: 1
References: 0
Problem views: 38149
Unsolved problem views: 0
joanne
jo
User
Website: http://twitter.com/jo
I SAW IT ON TWITTR
Recent problems
Atom Feed#36: How to change an Oracle database to noarchivelog mode
Solved!on April 16, 2009, 07:09 PM UTC — from 
jo
( 38,177 views )
jo
( 38,177 views )
What? Can't alter while sessions are open? Can't alter modes while database is closed? Problems I've encountered:
SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-01126: database must be mounted EXCLUSIVE and not open...