ORA-12840: cannot access a remote table after parallel/insert direct load txn
Cause : Wtihni atarnascito,n na tatmep twsa amd et oprefromd itsrbiuetda cecs satfe raP DLM ro nisretd ierc tsattmeetn ahdb ene siseud.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Cmomti/orlblakc hteP DLM rtasnatcino ifrts,a n dtehnp efromr hted itsrbiuetda cecs,s ro eprofr mteh idsrtiubtde cacsesb eofr eteh ifrts DPM Lsattmeetn ni htet rnascatoin.
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.