Re: Turn LOG on

---- you wrote: > Hi, > > is it possible to turn [buffered] logging on, after the database has > been created. > > Normally, logging is turned on, when the database is CREATEd: > > CREATE DATABASE foobar WITH BUFFERED LOG;> > But I created the database, I forgot the "WITH BUFFERED LOG" clause. > > Any ideas? You can do it Dude, but you must create a level 0 archive. So you can use ontape: ontape -s -B foobar Or if you use onbar, then first do: ondblog buf foobar Then do a level 0 archive with onbar. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com