Re: Need help

Krishna.Bussu_at_gmail.com wrote:
> Hi all,
>
> Could somebody pls answer my queries given below?
>
>
> 1.Is it possible to multiplex control file without shuttig down the
> database?

Are you asking about adding an additional control file to those that already exist? As in dynamically altering the SPFILE?

> 2.I read lot of articles about SCN and CHECK POINTS and their
> functioning. But still has some confusion.
> Could somebody please explain when & By whoom these( SCN and
> CHECKPOINT) will be genereated?

SCNs are generated by the database for each transaction. Checkpoints may be generated for a number of different reasons.

For more about both of these hit the docs at http://tahiti.oracle.com.

> 3.Can we change the NLS Character set after Creating the Database?

Yes but, to quote the docs, "Depending on the character sets involved this may result in data loss. Try this in test environments before proceeding in production."

The method for doing this is documented at: http://www.psoug.org/reference/character_sets.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org