Oracle DB Error ORA-23370 table string and table string are not shape equivalent (string)

The following is the cause of this error:

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 you can take to resolve this issue: Make sure the two tables being compared have the same number of columns, same column names, and same datatypes.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related