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

QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility

1 Answers  


ORA-28101: policy already exists

1 Answers  


ORA-12925: tablespace string is not in force logging mode

1 Answers  


IMG-00515: incorrect number of input channels

1 Answers  


ORA-14608: Tablespace was specified for the previous lob segments of column string in template but is not specified for string

1 Answers  






ORA-12058: materialized view cannot use prebuilt table

1 Answers  


PLS-00499: coercion into collection of records not supported

1 Answers  


ORA-00201: controlfile version string incompatible with ORACLE version string

1 Answers  


ORA-29291: file remove operation failed

1 Answers  


ORA-02352: file truncated error

1 Answers  


ORA-37007: (AWLISTALL05) number writer

1 Answers  


ORA-13403: invalid rasterDataTable specification

1 Answers  


Categories