DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Database Character set ?

  1. #1
    Join Date
    Oct 2002

    Database Character set ?

    Hello all..

    PArdon me if this question is answered before...

    But i have a 901 DB. How do we find out the character set of the database ?...also what is the default ?


  2. #2
    Join Date
    Dec 2001
    Edmonton, Canada
    For NLS_CHARACTER SET you can see the query v$NLS_PARAMETERS dynamic view.

    For database character set run this command.

    alter database backup controlfile to trace;

    The trace file generated will have the command to recreate controlfile and also information about the DATABASE CHARACTER SET.
    An elephant is a mouse with an operating system.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width