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

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/lk_db/article/details/79932078
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
阅读更多
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页