Oracle 12.2支持创建的表名长度大于30，最大128个字符

最新推荐文章于 2024-07-03 09:16:04 发布

原创最新推荐文章于 2024-07-03 09:16:04 发布 · 1.3w 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#oracle 12c 30 128 表名长度

Oracle 专栏收录该内容

120 篇文章

订阅专栏

12.2支持创建的表名长度大于30，最大128个字符
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 13 17:18:17 2018
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 TBL_TST_END_POINT_LOG_ESB_TENANT_BACKUP(id int);
create table TBL_TST_END_POINT_LOG_ESB_TENANT_BACKUP(id int)
*
ERROR at line 1:
ORA-00972: identifier is too long

[oracle@ora12c1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Apr 13 17:18:39 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> create table TBL_TST_END_POINT_LOG_ESB_TENANT_BACKUP(id int);
Table created.

当12.2中有超过30个字符长度的表名，使用低版本客户端导出时会报错ORA-39373，建议使用同版本客户端导出或将表名的长度改为30个字符以内
12.2 DataPump Export (EXPDP) Using a Lower Export Client Fails Due To ORA-39373 (文档 ID 2369249.1)
SYMPTOMS
Exporting a 12.2 database using a lower export client version, the following error is hit:
ORA-39373: cannot export TABLE_DATA:"ORACLE"."TBL_TST_END_POINT_LOG_ESB_TENANT_BACKUP" to version 11.2.0.4 due to long identifiers

CAUSE
In 12.2 Oracle database, the maximum length of identifiers is increased to 128 bytes for most identifiers, up from 30 bytes in previous releases.
Providing longer identifiers gives customers greater flexibility in defining their naming schemes, such as longer and more expressive table names. Having longer identifiers also enables object name migration between databases with different character sets, such as Thai to Unicode.
Reference Oracle Database 12c Release 2 (12.2) New Features

SOLUTION
To avoid the error, there are two options available:
1/ Start the export using 12.2 expdp client.
- or -
2/ If an old expdp client version must be used to export a 12.2 database, rename the objects with a long identifier to a maximum 30 bytes length (30 characters) and restart the export.

REFERENCES
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-ACC0E96C-8D2D-468F-92E0-2013C7F13455
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-E82CA1F1-09C0-47DC-BC78-C984EC62BAF2