Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: read tables from dmp

    Hi

    I need to read some tables from a dmp (backed up) and export the results to any format like access, xls, dbf,etc.

    any ideas are welcome.
    thx
    FM

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: read tables from dmp

    I can think of 2 ways to do so:

    a) the supported way is to import these tables into any (dummy) db and then create something like a csv (eg. using sqlplus/spool) or use odbc to access the tables from access.

    b) a little bit tricky and really unsupported: have a look at the export-dump. There are the SQL-statements to create the tables and insert data readable. Maybe you can do some patternprocessing on this file to get any useful data directly.
    ^/\x

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •