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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable

1 Answers  


ORA-32509: watchpoint was already deleted

1 Answers  


ORA-37082: Invalid percent

1 Answers  


PLS-00173: SPACE, TAB or RETURN are disallowed as alternative quote delimiters

1 Answers  


ORA-31205: DBMS_LDAP: PL/SQL - Invalid LDAP Auth method.

1 Answers  






ORA-07800: slbtpd: invalid number

1 Answers  


PLS-00640: a pipelined function cannot be called from PL/SQL context

1 Answers  


DRG-11850: Transformation Applied

1 Answers  


ORA-30656: column type not supported on external organized table

1 Answers  


IMG-00854: internal image data free failed

1 Answers  


DRG-11709: too many terms in thesaurus

1 Answers  


NCR-02006: NCRF: Invalid floating point representation received

1 Answers  


Categories