Hi,
Source db 10.2.03
Source O/S : Win 2003
Target db : 12.2.0.1
Target O/S : Win 2012
Please bear with me, since i am new to Oracle TEXT and i don't have a developer background on Oracle side.
I took a datapump against my user schema on source db and did a datapump import on target db, and it failed creating index on one of the table ( got error DRG-10700 ) , upon doing some googling and searching through Oracle metalink, i found that my table contains a text search index for which certain ctx preferences which are present in source never made it to target db, so to fix the issue I had to create these preferences manually on target db, so my question is does anyone know why datapump did not export ctx preferences by default ?
Here's a little post that i found to be useful which recommended to generate a script out of source db and re-create it on target db.
https://community.oracle.com/thread/2152091?start=0
Is it safe to assume that datapump cannot handle/export ctx preferences ?
-Learner