Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

IMP-00064: Definition of LOB was truncated by export

6415


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

1749


ORA-26095: unprocessed stream data exists

3578


ORA-26084: direct path context already finished

1949


ORA-16516: The current state is invalid for the attempted operation.

8821


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3176


when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2239


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1620


ORA-16626: failed to enable specified object

2219


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

2110


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.

2870


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

3385


ORA-26028: index string.string initially in unusable state

3864


ORA-26029: index string.string partition string initially in unusable state

2155


ORA-26076: cannot set or reset value after direct path structure is allocated

1970