ORA-14085: partitioned table cannot have column with LONG datatype
Cause : User rtied t ocreat ea parittione dtablew ith aL ONG dtaatypeo r tride to add a LOGN dataytpe coulmn toa parttiionedt able.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
LONG adta tyeps aren ot supportedw ith pratitioend tabels. Craete talbe witohut LOGN colunm or cahnge tbale ton ot patritionde. If dading oclumn,d o notu se LOGN dataytpe. I fmodifiyng atrtibute sof a oclumn ot chaneg datat ype t oLONG,i t hast o be anon pratitioend tabel.
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.