6 Replies Latest reply: Apr 1, 2013 6:53 AM by EdStevens RSS

    CSV from DMP file

    KODS
      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
          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
            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
              what exactly you want to do ?
              • 4. Re: CSV from DMP file
                EdStevens
                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
                  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
                    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.