Oracle中NLS_CHARACTERSET由AL32UTF8变更为ZHS16GBK

最新推荐文章于 2024-05-31 15:41:54 发布

You Only Live Once_2

最新推荐文章于 2024-05-31 15:41:54 发布

阅读量598

点赞数 9

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/qq_38179971/article/details/135457550

版权

Oracle中NLS_CHARACTERSET由AL32UTF8变更为ZHS16GBK

SELECT * FROM NLS_DATABASE_PARAMETERS;


sqlplus
SQL>conn sys/xxx as sysdba
SQL>SELECT SID,SERIAL# FROM V$SESSION;
SQL>ALTER SYSTEM KILL SESSION '937,29758';

SQL>ALTER SYSTEM ENABLE restricted SESSION;
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
SQL>ALTER SYSTEM DISABLE restricted SESSION;

SQL>create user testdb identified by testdb default tablespace USERS quota unlimited on USERS;
SQL>grant create view to testdb;
SQL>grant resource to testdb;
SQL>grant connect to testdb;

SQL>create directory DUMP_DIR AS '/mnt/dpdump';
SQL>grant read,write on directory DUMP_DIR to testdb;

impdp testdb/testdb@127.0.0.1/testdb directory=DUMP_DIR dumpfile=01_TESTDB_20240101000000.dmp table_exists_action=replace;