viewing which character set was used at creation time 
Author Message
 viewing which character set was used at creation time
Hello,

how can the character set the database was created with be deterimined
later, if the early alertlog is lost?
Backup control file to trace works, but does there exist an entry in
the data dictionary, and if so, in which view?

thanx,
Andreas Boehm



Sun, 23 May 2004 19:36:08 GMT
 viewing which character set was used at creation time

Look at SYS.PROPS$

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.


Quote:
>Hello,

>how can the character set the database was created with be deterimined
>later, if the early alertlog is lost?
>Backup control file to trace works, but does there exist an entry in
>the data dictionary, and if so, in which view?

>thanx,
>Andreas Boehm



Sun, 23 May 2004 22:37:58 GMT
 viewing which character set was used at creation time

Quote:

> Hello,

> how can the character set the database was created with be deterimined
> later, if the early alertlog is lost?
> Backup control file to trace works, but does there exist an entry in
> the data dictionary, and if so, in which view?

> thanx,
> Andreas Boehm

select * from nls_database_parameters

Hth

Sybrand Bakker,

Senior Oracle DBA



Sun, 23 May 2004 23:31:55 GMT
 viewing which character set was used at creation time

Hi Andreas,

use:

select * from nls_database_parameters;

Regards,

Uwe

Quote:

> Hello,

> how can the character set the database was created with be deterimined
> later, if the early alertlog is lost?
> Backup control file to trace works, but does there exist an entry in
> the data dictionary, and if so, in which view?

> thanx,
> Andreas Boehm

  uwe.kirchhoff.vcf
< 1K Download


Thu, 27 May 2004 00:10:34 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Non supported character set: oracle-character-set-96

2. db character set & N character set

3. View Creation Using Access Data Project

4. 24 hour time switches to incorrect am/pm time

5. I am getting this message when i am tring to export or import anything using

6. Getting AM/PM Time formatting in a field with two Times

7. Character set woes using JDBC

8. How to find character set the database is using

9. Using ADO to access a national character set=Unicode Oracle 8 database

10. Anyone using UNICODE or character set AL24UTFFSS

11. HELP! Using SQL loader with special character set

12. Using two different character sets in one database


 
Powered by phpBB® Forum Software