This discussion is archived
6 Replies Latest reply: Apr 1, 2013 4:53 AM by EdStevens RSS

CSV from DMP file

KODS Newbie
Currently Being Moderated
Dear Masters/Gurus/All,

We are using oracle 10.2.04 version on HP UNIX.

We have a specific requirement to prepare CSV file from oracle dump(DMP File).

Please let me know the process.


Thanks,
KODS
  • 1. Re: CSV from DMP file
    EdStevens Guru
    Currently Being Moderated
    KODS wrote:
    Dear Masters/Gurus/All,

    We are using oracle 10.2.04 version on HP UNIX.

    We have a specific requirement to prepare CSV file from oracle dump(DMP File).

    Please let me know the process.


    Thanks,
    KODS
    There is no process, because it can't be done. A dmp file is a binary file created and intended for the use of the import utility (imp or impdp, as the case may be). those import utilties are the only programs available to you that know how to read a dmp file, and they do not create csv files.

    Creating a csv from a dmp is NOT a requirement. It is a pre-conceived (and in this case an ill-conceived and impossible) technical solution to some requirement you have not revealed to us.

    Edited by: EdStevens on Mar 30, 2013 6:42 AM
  • 2. Re: CSV from DMP file
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    What is the business or technical issue you are trying to solve ? At a high level, you will need to -

    1. Import the dump file into temporary tables or temporary schema
    2. Write code to extract the required data into a CSV text file

    HTH
    Srini
  • 3. Re: CSV from DMP file
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    what exactly you want to do ?
  • 4. Re: CSV from DMP file
    EdStevens Guru
    Currently Being Moderated
    Osama_mustafa wrote:
    what exactly you want to do ?
    Isn't that why I asked 4 hours earlier, and what Srini asked 3 hours earlier?
  • 5. Re: CSV from DMP file
    KODS Newbie
    Currently Being Moderated
    Dear All,

    Thanks for reply and kindly accept my apologies for delayed in reply.

    let me explain little background.

    In a telecom domain for every customer there are multiple records exists with respect to calls on any particular day if you consider. On few tables the production dba will take the schema/table backup. But the end users/customer care people's application is designed in such a way that, it can read data from CSV format.

    Because of this reason I like to know the process of reading data from dump file and convert it into CSV file.

    Thanks,
    Kods

    Edited by: KODS on Apr 1, 2013 4:33 PM

    Edited by: KODS on Apr 1, 2013 4:34 PM
  • 6. Re: CSV from DMP file
    EdStevens Guru
    Currently Being Moderated
    KODS wrote:
    Dear All,

    Thanks for reply and kindly accept my apologies for delayed in reply.

    let me explain little background.

    In a telecom domain for every customer there are multiple records exists with respect to calls on any particular day if you consider. On few tables the production dba will take the schema/table backup. But the end users/customer care people's application is designed in such a way that, it can read data from CSV format.

    Because of this reason I like to know the process of reading data from dump file and convert it into CSV file.

    Thanks,
    Kods

    Edited by: KODS on Apr 1, 2013 4:33 PM

    Edited by: KODS on Apr 1, 2013 4:34 PM
    Doesn't matter. A dmp file can ONLY be read by the import utility. If you want a csv file, you'll need to import the dump file back into a database, then create your csv file from there.
    Or create the csv file instead of the dump file in the first place.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points