Re: how to corrupt rollback segment and add control file in database

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: 8 Sep 2006 19:33:46 -0700
Message-ID: <1157769226.332013.325280@p79g2000cwp.googlegroups.com>

sybrandb wrote:
> aman.oracle.dba wrote:
> > Is it possible that I can corrupt any rollback segment on my test
> > machine.
> > If it is then how.......
> > And is it possible to do multiplexing of controlfile without shutdown
> > database.
> > If it is then how........
>
> 1 on Unix you could easily use the dd command to do so.
> 2 Please answer the question (possibly reading the manual( whether the
> control_files parameter is a *static* or a *dynamic* parameter.
> This should answer your question.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thank you your answer.
control_files is static but in one interview, interviewer forcefully said that control file can be changed dynamically also but he was asking how from me. Received on Fri Sep 08 2006 - 21:33:46 CDT