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

RMAN-06576: platform 'string' (number) found in header of datafile string does not mmatch specified platform name 'string' (number)

1 Answers  


ORA-02051: another session in same transaction failed

1 Answers   Axede,


TNS-02022: show rules: Show rules that are currently in effect

1 Answers  


RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTORE

1 Answers  


TNS-00011: INTCTL: error while starting the Connection Manager

1 Answers  






ORA-39119: worker process interrupt for delete worker processes call by master process

1 Answers  


ORA-15122: ASM file name 'string' contains an invalid file number

1 Answers  


NID-00137: All datafiles that are not dropped should be readable

1 Answers  


ORA-01039: insufficient privileges on underlying objects of the view

1 Answers  


ORA-12494: cannot insert or delete a level, category, or release category

1 Answers  


TNS-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


SQL-02131: Runtime context in use

2 Answers  


Categories