hi all,
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
We have virtual columns on some tables, when we importing these tables ( .DMP file ) oracle showing error like this ( exported using TOAD Export Utility Wizard ) and importing using command line oracle's imp utility. i checked there is no problem with Character Set on both machines are same.
is it the limitation of virtual column? oracle allow to Partition on these virtual columns then ... or my be i am doing something wrong or missing ?
output of imp utility:
IMP-00017: following statement failed with ORACLE error 984:
" ALTER TABLE "PA_FATCA_INDIV" MODIFY ("US_RES" DEFAULT CASE WHEN "
"("US_RESIDENT"='Y' OR "US_CITIZEN"='Y' OR "US_PERM_RES_CARD"='Y' OR "US_TAX"
"_PAYER"='Y') THEN 'Y' ELSE 'N' END )"
will somebody help for this problem? i will be much grateful.
with best regards.