#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0

    extracting .dmp files


    ok, i've searched a lot, and i couldn't find a solution for my problem...

    i have a backup of the database in .dmp format and i need to partially restore it (there were some deletions by mistake in it and i need to restore some part of the records).

    the problem is that i can't extract the file - i found NXTract utility, but it doesn't work with CLOB fields (and i'm not willing to pay for it, plus i'm not sure if commercial version does support it)

    i know that i can import that .dmp file into the database, but that way all records will be imported and changes made after the backup was done will be removed. even if they won't be removed - there will be lots of mess.

    i just need to extract some records with some criteria out of that file. is there any way to do it?

    i don't have administrative access to oracle neither can i install it localy. that would take lots of time, and i need just part of the records in that dmp file... so basically i drop the idea of creating the new database, importing the stuff there and extracting the needed data only with some script.

    well i hope someone will understand me and help me... thanks.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2002
    Posts
    693
    Rep Power
    26
    If it's only a few records in a couple of tables you could do this:

    1. rename the tables you need to import
    2. import just the tables you need import .... tables=(t1,t2,t3)
    3. now you can delete/insert into the table from the backup you made in step 1.

    this would be quite cumbersome to do with an entire db but if it's only a few rows it would be ok.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0
    hmz. true. i was stupid enough to not think about renaming tables thanks

IMN logo majestic logo threadwatch logo seochat tools logo