Inserts during expdp
So I am facing this scenario. An Oracle 11g DB, with 4 tables, and data is inserted in them basically all the time(24/7, at different intervals).What we are using to keep this data safe, is to do an Data Pump API export each day.
My question is quite simple...still i haven't had any luck in finding an precise or "official" answer.
Given my scenario, let's say that the export starts at 10 PM, and because of the data volume, it usually takes about 10 minutes to complete. What happens to the data that is being inserted in this period ? From what I saw, the tables are exported in a random sequence, so if the backup for table X1 is complete at 10:02 PM, then all the data that is inserted after that is obviously not part of the DMP file...even though the export is not complete, as next table X2 is exported...right?
My question is quite simple...still i haven't had any luck in finding an precise or "official" answer.
Given my scenario, let's say that the export starts at 10 PM, and because of the data volume, it usually takes about 10 minutes to complete. What happens to the data that is being inserted in this period ? From what I saw, the tables are exported in a random sequence, so if the backup for table X1 is complete at 10:02 PM, then all the data that is inserted after that is obviously not part of the DMP file...even though the export is not complete, as next table X2 is exported...right?
0