Thanks Harry! But my process is, as I have already performed one round of import(and as I have done some changes in procedures and views which I want to retain in my new database), in my second round I would only be truncating the data in the table and import the data into the table. So in that case, for the MV table should I import the data into it?
I would also like to know how should sequence be handled in this case? Should I recreate the sequence after the import or let the sequence be there(as imported in my first round of import which I had done) and next time the sequence will take the right value from the newly refreshed table with new data.