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
IMP-00064: Definition of LOB was truncated by export
IMP-00070: Lob definitions in dump file are inconsistent with database.
ORA-26095: unprocessed stream data exists
ORA-26084: direct path context already finished
ORA-16516: The current state is invalid for the attempted operation.
IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier
when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
ORA-16626: failed to enable specified object
ORA-26032: index string.string loading aborted after string keys
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.
invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity
ORA-26028: index string.string initially in unusable state
ORA-26029: index string.string partition string initially in unusable state
ORA-26076: cannot set or reset value after direct path structure is allocated