11G之前的表名,只支持30个以内:
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 4 17:11:54 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> create table whs_012345678901234567890123456789 (id number);
create table whs_012345678901234567890123456789 (id number)
*
ERROR at line 1:
ORA-00972: identifier is too long
以19C为例,可以创建30个字符以上的表名。
[oracle@cat1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Dec 4 17:10:51 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2818568848 bytes
Fixed Size 9138832 bytes
Variable Size 939524096 bytes
Database Buffers 1862270976 bytes
Redo Buffers 7634944 bytes
Database mounted.
Database opened.
SQL> create table whs_012345678901234567890123456789 (id number);
Table created.