1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

instance1 to instance2 discoverer report moving

Discussion in 'Oracle Discoverer' started by Bharat, Apr 28, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    Can anyone please help me how to move report or workbook from one instance to another instance.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    Anyone please help me on this issue.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Describe exactly what you want to do, please.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi David,

    I have just created workbook in local instance and now I want to move it to another instance which is located in US. Can I know how to move that workbook to that location.
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    Is there any command exists to do this from command line. Just like import/ export commands.
     
  6. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hey Bharat

    It depends somewhat on the version you are using. Generally there are two ways

    1 Use Discoverer Desktop and save the report locally from the first instance (most likely dev), then login to the second instance (production ) using the desktop and open the file. If it opens then all the items exist and you can save it to the database.

    2. Using the admin export you can export a specific workbook, you should be able to see this option assuming you use version 10

    Also Discoverer's Admin Manual lists the steps in more detail if I recollect accurately... :)
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi sadik,

    Do we need to have discoverer to move the workbook which is created in one instance to another instance. Because here in our other instance there is no discoverer exists to do so. Thanks for your help.
     
  8. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Follow the second method if you don't have discoverer desktop. (which version of discoverer is this?)
     
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi sadik,

    Actually Iam new to this so please dont mind of posting all the information from the help.

     
  10. nazeer23

    nazeer23 Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    how to move discoverer plus reports created in test instance to prod instance.

    hi all,

    i have created 4 reports in discovere plus in test instance, i want to move all the reports in prod instance,how can i move the reports.

    Any help will be greatly appreciated.

    Thanks,
    Nazeer
     
  11. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
  12. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi sadik,

    Are there any pre-requirements to do this. I have followed export and import process but the workbook is not importing successfully. Its showing that partially imported.
     
  13. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    The account you are using may not have Administration Privilege (Tools | Privileges). If I recollect correctly, you need the Create / Edit Business Area privilege in both source and target.
     
  14. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi sadik,

    I will check them and get back to you sadik bhai. Thanks for that.
     
  15. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi sadik,

    The privileges are fine for that, but they are not importing.