ORA-23370: table string and table string are not shape equivalent (string)

ORA-23370: table string and table string are not shape equivalent (string)
Cause: The tables specified are not shape equivalent, which means intuitively that the number of columns, the names, their datatypes and lengths are not the same. Specifically, problem is in the parentheses and is one of the following: the number of columns are not equal, datatypes of columns with same name in different tables are different, lengths of varchar2 and char columns are not equal, precision and scale of number datatypes are not equal.
Action: Make sure the two tables being compared have the same number of columns, same column names, and same datatypes.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-23370：表字符串和表字符串不是等价形式（字符串）,
.原因：指定的表不是等价的形式，这意味着直观地，列的数量，名称，其数据类型和长度不一样。具体来说，问题在括号中，并且是以下之一：列数不相等，不同表中具有相同名称的列的数据类型不同，varchar2和char列的长度不相等，数字数据类型的精度和标度不相等。,
.操作：确保正在比较的两个表具有相同的列数，相同的列名称和相同的数据类型。,
.

aiaiDBA

13718043309

010-86462881

ORA-23370: table string and table string are not shape equivalent (string)

1 个回答

相似问题