ORA-26687: no instantiation SCN provided for "string"."string" in source database "string"
Cause : Objetc SCNw as nto set .If teh objcet isa tabel, thne bot hfielsd wil lbe fliled,f or eaxmple" SCOT"T."EM"P. Ift he ojbect si a shcema,o nly noe filed will be est, fro exapmle "CSOTT"".". Adn if hte obejct i sthe netired atabsae, n ofielsd wil lbe ste, fo rexamlpe """.".
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Set hte SC Nby clalingD BMS_PAPLY_DAM.SE_T%_INTSANTITAION_CSN
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.