+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 17

converting .dmp to .csv

  1. converting .dmp to .csv

    I am a SQL Server DBA...I'll wait for the laughing to stop :)

    Is anyone aware of a utility that we can use\purchase that can be used
    to convert an Oracle .dmp file to some other usable format for SQL
    Server.... like .csv maybe.

    TIA Jordan


  2. Re: converting .dmp to .csv

    JMNUSS wrote:
    > I am a SQL Server DBA...I'll wait for the laughing to stop :)
    >
    > Is anyone aware of a utility that we can use\purchase that can be used
    > to convert an Oracle .dmp file to some other usable format for SQL
    > Server.... like .csv maybe.
    >
    > TIA Jordan


    You can use two Oracle-suppled utilities to generate CSV's from an
    Oracle export file: imp and SQL*Plus.

    HTH

    -g


  3. Re: converting .dmp to .csv

    JMNUSS wrote:
    > I am a SQL Server DBA...I'll wait for the laughing to stop :)
    >
    > Is anyone aware of a utility that we can use\purchase that can be used
    > to convert an Oracle .dmp file to some other usable format for SQL
    > Server.... like .csv maybe.
    >
    > TIA Jordan


    You can use two Oracle-suppled utilities to generate CSV's from an
    Oracle export file: imp and SQL*Plus.

    HTH

    -g


  4. Re: converting .dmp to .csv

    I have seen scripts to parse the DDL out of an export file so you
    should be able to use the same techniques to get the data, but I would
    not want to tackle the project even if the data did not include long,
    long raw, or LOB datatypes. I know of no products on the market to do
    this.

    If the source database exists I would just re-extract the data using
    SQLPlus in csv format.

    How do I export a database table to a flat file ?
    http://www.jlcomp.demon.co.uk/faq/flatfile.html

    HTH -- Mark D Powell --


  5. Re: converting .dmp to .csv

    I have seen scripts to parse the DDL out of an export file so you
    should be able to use the same techniques to get the data, but I would
    not want to tackle the project even if the data did not include long,
    long raw, or LOB datatypes. I know of no products on the market to do
    this.

    If the source database exists I would just re-extract the data using
    SQLPlus in csv format.

    How do I export a database table to a flat file ?
    http://www.jlcomp.demon.co.uk/faq/flatfile.html

    HTH -- Mark D Powell --


  6. Re: converting .dmp to .csv

    thanks for the feedback, unfortunately i have no control over the
    actual expoting of the data, we are going to be supplied with the .dmp.
    I hope that I can convince them to do this.


  7. Re: converting .dmp to .csv

    thanks for the feedback, unfortunately i have no control over the
    actual expoting of the data, we are going to be supplied with the .dmp.
    I hope that I can convince them to do this.


  8. Re: converting .dmp to .csv

    JMNUSS ha escrito:

    > thanks for the feedback, unfortunately i have no control over the
    > actual expoting of the data, we are going to be supplied with the .dmp.
    > I hope that I can convince them to do this.


    Or (if you have the time && user data < 4GB) download Oracle Express
    Edition, import the dmp and do as you please with it.

    --ph


  9. Re: converting .dmp to .csv

    JMNUSS ha escrito:

    > thanks for the feedback, unfortunately i have no control over the
    > actual expoting of the data, we are going to be supplied with the .dmp.
    > I hope that I can convince them to do this.


    Or (if you have the time && user data < 4GB) download Oracle Express
    Edition, import the dmp and do as you please with it.

    --ph


  10. Re: converting .dmp to .csv

    Use ODBC and MS Excel, create an external query to the database you
    want as select * from table you want.

    Save the excel as .csv

    Save the .xls too. Then when you need to redo the data, you can.

    Good for 1 or 2 tables

    Or if you want to skip the .csv, use Access, do table links and then
    update queries
    You can schedule those items... or so I am told.
    quick .vb script on the windows server to replicate the data.

    Good for lots of tables.

    OR
    use XDB in oracle, dump the tables to XML and load XML into sqlserver

    Geez... after typing ODBC,EXCEL,ACCESS,SQL SERVER, XML I have to go
    have shower... I feel DIRTY.


+ Reply to Thread
Page 1 of 2 1 2 LastLast