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!

Exact data from a datapump export file

Discussion in 'General' started by Mark Staples, Sep 14, 2017.

  1. Mark Staples

    Mark Staples Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Alaska
    I have client that is ending there Oracle Cloud application Taleo. They need to get the data and create a legacy reporting database in SQL Server. Oracle has provided a Datapump file. Because it is a cloud application the client has no Oracle software at their site. How can we get the data out of the DP file when there is no Oracle Instances to import it into??????
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,537
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You can't. Download a copy of the Oracle software from www.oracle.com and run a free copy so you can import the file. At that point it should be fairly easy to generate a CSV file you can use with BCP or the Export/Import Wizard.