I am Migrating data from one database to another. I am using the import/export method. I have two materialize views. I understand that these MV also create an underlying table.
So when I migrate(including data) to the fresh database, should I also export and import the table belonging to the materialized view?
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.