Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

KUP-00554: error encountered while parsing access parameters

1 Answers  


ORA-29704: cannot specify ACTIVE_INSTANCE_COUNT in 8.1.5 or earlier release

1 Answers  


ORA-08463: overflow converting decimal number to Oracle number

1 Answers  


LSX-00018: invalid schema context

1 Answers  


QSM-02181: a SPREADSHEET clause is present

1 Answers  






ORA-06314: IPA: Event set up failure

1 Answers  


ORA-14071: invalid option for an index used to enforce a constraint

1 Answers  


ORA-14191: ALLOCATE STORAGE may not be specified for Composite Range partitioned object

1 Answers  


ORA-35276: (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]

1 Answers  


ORA-26040: Data block was loaded using the NOLOGGING option

1 Answers  


ORA-01615: instance string (thread string) is mounted - cannot disable

1 Answers  


PLS-00732: Illegal overload of ellipsis in formal parameter list

1 Answers  


Categories