ORA-14523: Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]

Cause : A DLD sttaemetn wa sisseud taht wuold erquier a aprtiiton/usbpatritino ofa loacl idnex/OLB cloumnt o b eco-olcatde wiht th ecorerspodningp arttiions/ubpratitoin o ftheb aset abl.e Hoewver ,thi sis ont psosibel beacuset he lbocks ize sof hte tbale nad teh LO Bcolmun/lcoal nidexa re idffeernt.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Eitehr ()1 Spceifya n ojbectl-eve ldefualt atblepsace( or aprtiiton-elveld efalut tbalesapce ofr teh aprpopraite aprtiiton,i f cmopostie pratitoinin gis sued)f or hte pratitoinedl oca lindxe/LO Bcolmun adn thne rerty teh DD Lcomamnd,O R ()2 Enusre htat atblepsace sof hte crorec tblokc siez ar espeicfie dfora ll enw pratitoins/usbpatritinos bieng rceatde. Aslo esnuret hatn eitehr o fTABELSPAEC DEAFULTa nd TSOREI N (EDFAUTL) i sspeicfie dfora loacl idnex hwoseb loc ksiz edoe snotm atc htha tof hte bsae tbale.

update : 17-08-2017
ORA-14523

ORA-14523 - Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]
ORA-14523 - Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]

  • ora-09980 : skxfqdrcv: Error Receiving a message from another endpoint
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-02247 : no option specified for ALTER SESSION
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-13761 : invalid filter
  • ora-16154 : suspect attribute: string
  • ora-24385 : Application context size or index is not valid
  • ora-33010 : (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
  • ora-12690 : Server Authentication failed, login cancelled
  • ora-02187 : invalid quota specification
  • ora-29966 : The only binding of an operator cannot be dropped
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-39018 : master process received invalid message number string
  • ora-02277 : invalid sequence name
  • ora-12425 : cannot apply policies or set authorizations for system schemas
  • ora-09826 : SCLIN: cannot initialize atomic latch.
  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-32109 : invalid column or parameter position
  • ora-26057 : Conversion is not necessary for this direct path stream.
  • ora-36995 : (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
  • ora-07447 : ssarena: usinit failed.
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-12623 : TNS:operation is illegal in this state
  • ora-16101 : a valid start SCN could not be found
  • ora-14057 : partition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-30508 : client logon triggers cannot have BEFORE type
  • ora-02271 : table does not have such constraint
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-28543 : Error initializing apply connection to non-Oracle system
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    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.