Tuesday 13 January 2015

How to Export and Import a folder in Oracle Discoverer

You can export individual folder from one instance to other instance in Oracle Discoverer.

Follow the below steps .



Step 1:
Login to Oracle Discoverer Administrator.
Step 2:
Go to File>>Export>>
Export wizard will be appeared








Step 3:
Mark ‘Selected Objects in the End user Layer’ from the Wizard and Click on Next
 





Step 4:
Select the folder/s you need to migrate and click on next .
 






Step 5 :
Provide the file name and location to save the file and click on Finish
 







Now the Exported folders are ready to import to destination with extension *.eex
 


Step 6:
Login to Discoverer administrator of your destination instance .
Go to File>>Import
Select the *.eex file from the location you have saved by pressing on Add file button from the Wizard.
Click on next
 




Step 7:
Keep the default selections as it is and click on Next
 








Step 8 :
Click on Start button
 






Once the import is completed click on finish.
Step 9:
Once folder is imported go to Tools>>Manage Folders
 






Select the business area where you need to move the folder and Move the folder/s to the Business Area
Note:
1) make sure that all the DB objects relating to the folder are moved to destination before importing the folder
2) Make sure that all the related folders are included in single *.eex file while exporting.
        Eg. If a workbook relating to 2 folders which are joined need to be export in single *.eex file .
 

No comments: