In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
First, view the character set
SQL > select * from v$version BANNER CON_ID -Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit Production 0PL/SQL Release 12.1.0.2.0-Production 0CORE 12.1.0.2.0 Production 0TNS for Linux: Version 12.1.0.2.0-Production 0NLSRTL Version 12.1.0.2.0-Production 0SQL > select userenv ('language') from dual USERENV ('LANGUAGE')-AMERICAN_AMERICA.ZHS16GBKSQL > SQL > select * from v$nls_parameters PARAMETER VALUE CON_ID-- NLS_LANGUAGE AMERICAN 0NLS_TERRITORY AMERICA 0NLS_CURRENCY $0NLS_ISO_CURRENCY AMERICA 0NLS_NUMERIC_CHARACTERS. 0NLS_CALENDAR GREGORIAN 0NLS_DATE_FORMAT DD-MON-YYYY HH24:MI:SS 0NLS_DATE_LANGUAGE AMERICAN 0NLS_CHARACTERSET ZHS16GBK 0NLS_SORT BINARY 0NLS_TIME_FORMAT HH.MI.SSXFF AM 0PARAMETER VALUE CON_ID- -NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM 0NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR 0NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR 0NLS_DUAL_CURRENCY $0NLS_NCHAR_CHARACTERSET AL16UTF16 0NLS_COMP BINARY 0NLS_LENGTH_SEMANTICS BYTE 0NLS_NCHAR_CONV_EXCP FALSE 019 rows selected.SQL > SQL > select * from nls_database_parameters PARAMETER VALUE---NLS_RDBMS_VERSION 12.1.0.2.0NLS_NCHAR_CONV_EXCP FALSENLS_LENGTH_SEMANTICS BYTENLS_COMP BINARYNLS_DUAL_CURRENCY $NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_SORT BINARYNLS_DATE_LANGUAGE AMERICANPARAMETER VALUE-- NLS_DATE_FORMAT DD-MON-RRNLS_CALENDAR GREGORIANNLS_NUMERIC_CHARACTERS. NLS_NCHAR_CHARACTERSET AL16UTF16NLS_CHARACTERSET ZHS16GBKNLS_ISO_CURRENCY AMERICANLS_CURRENCY $NLS_TERRITORY AMERICANLS_LANGUAGE AMERICAN20 rows selected.
Second, modify the character set
SQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > startup mount;ORACLE instance started.Total System Global Area 1778384896 bytesFixed Size 2925408 bytesVariable Size 1627393184 bytesDatabase Buffers 134217728 bytesRedo Buffers 13848576 bytesDatabase mounted.SQL > alter session set sql_trace=true; Session altered.SQL > alter system enable restricted session; System altered.SQL > alter system set job_queue_processes=0; System altered.SQL > alter system set aq_tm_processes=0; System altered.SQL > alter database open; Database altered.SQL > ALTER DATABASE character set INTERNAL_USE AL32UTF8 Database altered.SQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > startup ORACLE instance started.Total System Global Area 1778384896 bytesFixed Size 2925408 bytesVariable Size 1627393184 bytesDatabase Buffers 134217728 bytesRedo Buffers 13848576 bytesDatabase mounted.Database opened.SQL > select * from nls_database_parameters PARAMETER VALUE---NLS_RDBMS_VERSION 12.1.0.2.0NLS_NCHAR_CONV_EXCP FALSENLS_LENGTH_SEMANTICS BYTENLS_COMP BINARYNLS_DUAL_CURRENCY $NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZRNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZRNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_SORT BINARYNLS_DATE_LANGUAGE AMERICANPARAMETER VALUE-- NLS_DATE_FORMAT DD-MON-RRNLS_CALENDAR GREGORIANNLS_NUMERIC_CHARACTERS. NLS_NCHAR_CHARACTERSET AL16UTF16NLS_CHARACTERSET AL32UTF8NLS_ISO_CURRENCY AMERICANLS_CURRENCY $NLS_TERRITORY AMERICANLS_LANGUAGE AMERICAN20 rows selected.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.