Hi Yenny,

Simple Question, to understand the soln. u need some logical thinking.

I will explain u the scenario and try to understand...

Say evening 5 pm a gay comes and tell u that I dropped an important table in the morning 10 am and he needs that table with data and at the same time u shouldnot loose other data. OK this is your problem...

For this u need ur database in archive log mode - most important.

step 1.

Import database with full data and keep it in a different place and forget it for timebeing. say final.dmp

step2.

come to the original db and recover the database till time
(I think u know this until cancel or until time etc) say 10am
or check ur last archive log time and make it 9.30 to 10 am and recover till that archive.

Now u may loose all other data after that period. ok. but u have the table recovered by this way.

Now export this table , this table may contain 90 to 100% of its data. and keep it sepatately say table1.dmp

Now import the final.dmp but now u don't have that table in the database ok. Now import table1.dmp in the finaldatabase.

Now u got the table in the database and didn't loose any data

OK Now u Happy... Enjoy