Advertisement
brianleepasc

Change Character Set Oracle

Sep 24th, 2022
1,529
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.43 KB | Source Code | 0 0
  1. SQL> shutdown IMMEDIATE;
  2. SQL> startup restrict    /ALTER SYSTEM ENTABLE RESTRICTED SESSION;
  3. SQL> SELECT name FROM v$database;
  4. SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
  5. SQL> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE parameter=’NLS_CHARACTERSET’;
  6. SQL> shutdown IMMEDIATE;
  7. SQL> startup
  8. SQL> SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE parameter=’NLS_CHARACTERSET’;
  9. AL32UTF8
  10. AMERICAN_AMERICA.WE8MSWIN1252
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement