Monday, October 9, 2017

Change Characterset to UTF8 in Oracle Database

Change Characterset to UTF8 in oracle
======================================

SQL> startup mount;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;


SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET UTF8;


SQL> shutdown immediate;
SQL> startup;

No comments:

Post a Comment

step‑by‑step guide to check CPU sockets, cores, threads, and multithreading (Hyper‑Threading/SMT)

Step‑by‑step guide to check CPU sockets, cores, threads, and multithreading (Hyper‑Threading/SMT) ✅ 1. BASIC UNDERSTANDING (IMPORTANT) Term...