ORA-00972

SQL> select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') as 日期时间 from dual;
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') as 日期时间 from dual
*
ERROR at line 1:
ORA-00972: identifier is too long

[oracle@prod-oracle-master ~]$ oerr ora 00972
00972, 00000, "identifier is too long"
// *Cause: An identifier with more than 30 characters was specified.
// *Action: Specify at most 30 characters.
[oracle@prod-oracle-master ~]$ echo $NLS_LANG

[oracle@prod-oracle-master ~]$ cd
[oracle@prod-oracle-master ~]$ vi .bash_profile
export NLS_LANG=american_america.AL32UTF8

[oracle@prod-oracle-master ~]$ source .bash_profile
[oracle@prod-oracle-master ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 14 14:13:23 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP" - rest of line ignored.Real Application Testing options

SQL> select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') as 日期时间 from dual;

日期时间
-------------------
2018-08-14 14:13:34

SQL>

转载于:https://www.cnblogs.com/elontian/p/9475264.html