Oracle 11gR2: NLS_CHARACTERSET accidentally removed with an UPDATE-Query
- by Marco Nätlitz
Hi folks,
I have a fresh installation of Oracle 11gr2_x64 on CentOS. After the installation I wanted to get productive and started to import my dumps. One of the dumps caused characterset error so I tried to change the systems character-set to the one specified in the dump.
I ran a statement like this:
UPDATE nls_database_parameters SET parameter='WS....' WHERE parameter=’NLS_CHARACTERSET’;
As you can see: I have written the value of the character-set in the parameter column instead of the value column. I guess I was just too much thinking about the problem instead of checking what I am typing there. After the query the parameter "NLS_CHARACTERSET" is gone and the server reports that the characterset is "(null)".
I want to put the "NLS_CHARACTERSET" paramater back in the table but don't know how. If I try to do something like this
INSERT INTO nls_database_parameters (PARAMETERS, VALUE) VALUES ("NLS_CHARACTERSET", "AL32UTF8");
I get the error:
Fehler bei Befehlszeile:1 Spalte:84
Fehlerbericht:
*Cause: SQL-Fehler: ORA-00984: Spalte hier nicht zulässig
*Action: 00984. 00000 - "column not allowed here"
Sorry that the error message is in German but it contains the Oracle error code.
Do you have any idea how I can fix that?
Thanks and best regards
Marco
