I had a requirement to move a bunch of personalization from one instance to another in my current project.I did lot of googling as well as raised an SR with oracle to find the best way to move the personalizations from one instance to another..And then I gave up on it for sometime and later while researching on a different topic I found out the best way to move adf saved queries and user personalization.
It is as simple as export from the source instance and import into the destination MDS using the EM Console.Let me show the steps here..
Step 1: Login to EM Console of your source instance.
Step 2: Click on your application deployed on a specific server
Step 3: Using Application Deployment menu, click on the MDS configuration.
Step 4: Export the mds repository contents from your source instance.
You can inspect your personalization docs by unzipping the downloaded file.
Step 5: Now upload the file back to the destination instance by logging into the EM console and Choose import