12C新特性:支持128个以下字符的表名

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.

Related Posts