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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

NZE-28890: Entrust Login Failed

1416


ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2323


ORA-26079: file "string" is not part of table string.string

1528


How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2321


ORA-26032: index string.string loading aborted after string keys

1663






NZE-28868: Peer certificate chain check failed.

2276


IMG-02003: 2FF03 - incorrect color histogram feature specification

1214


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2337


IMP-00070: Lob definitions in dump file are inconsistent with database.

1297


ORA-26084: direct path context already finished

1492


ORA-26027: unique index string.string partition string initially in unusable state

6169


ORA-16627: No standby databases support the overall protection mode.

3566


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2312


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

2869


ORA-26030: index string.string had string partitions made unusable due to:

1568