exporting tables in oracle?

Question

hi we have a .dmp file of size 76 MB in c:\. After the work on clients is finished we export the .dmp file all this my sir looks but today as my sir was absent i tried to export the .dmp file like this. i typed exp in runbox on windows start button then a dos window came asking for user id & password i gave them both next it asked for file i gave location c:\nlr.dmp it asked whether to export i just hit enter again some questions, every time i hit enter it asked whether to export table or rows or entire table i selected entire table. it started exporting export completed. but the file size is too large (compared to the previous exported files which are just around 75-80 MB in size) this one is nearly 190 MB there is a lot of data in it. i am worried whether i had made any loss to the data is there any way to bring it back to normal mode ( i am using windows xp sp2 with oracle 9i) any help in this regard is highly appreciable i've to do it by tomorrow morning) my cell no. is 9399920694.

the original .dmp file is in c:\with name nlr i.e., nlr.dmp while exporting i just selected the location of file c:\nlr.dmp and pressed enter key did the file has been over written??(my original file)

Answer 1

Don't worry... you'd be fine. Most likely you have taken a full export. If you like you can try another couple of backups and each time, pay attention to the options you are giving and take notes. Create a separate file each time you take an export and note down the name of the file along with the options you used to get that export.

Finally when talk to your PL or your other TMs who know the process better and keep the one that has options they suggest.