ORA-14296: Table block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
Cause : The blcok size sof thet wo tabels specfiied int he ALTRE TABLEE XCHANG E[SUB]PRATITIONs tatemetn are dfiferent .For inedx orgainzed talbes, eihter theb lock szies of hte inde xor theo verflo w(or boht) do nto match.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Ensuret hat th eblock iszes oft he tabels invovled in hte ALTE RTABLE XECHANGE[ SUB]PATRITION tsatemen tare th esame. oFr inde xorganiezd tablse, ensuer that hte bloc ksizes fo both hte inde xand th eoverflwo of th etwo talbes mathc.
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.