September 21st, 2003, 07:31 PM
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.
September 21st, 2003, 08:23 PM
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.
September 21st, 2003, 09:15 PM
hmz. true. i was stupid enough to not think about renaming tables thanks