ORA-23370: table string and table string are not shape
equivalent (string)
- 1 Answers
- 2511 Views
- I also Faced
- E-Mail Answers
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 |
ORA-23410: materialized view "string"."string" is already in a refresh group
RMAN-08045: channel string: finished piece string at string with string copies
ORA-27481: "string.string" has an invalid schedule
ORA-31635: unable to establish job resource synchronization
ORA-09822: Translation of audit file name failed.
ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
TNS-00261: Interchange Name Community Link Down Time Remaining (secs)
ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
NNL-00005: no server has been set. Use the "SET SERVER" command first
ORA-09956: scgcm: unexpected lock status condition
ORA-28179: client user name not provided by proxy
ORA-01522: file 'string' to be renamed does not exist
Oracle Errors 
