Did anyone try to do impdp on a table or two on snapshot database using "truncate" option, then invert it back to a physical standby at the end of a day? I am trying to test a script which include impdp which truncates the table prior to loading data.
Thank you in advance.
We used the snapshot standby for test case where we dropped the tables and ran the app to see the impact.
Once we done with the test we reverted it to standby database.
Snapshot standby creates the guaranteed restore point, so you can always restore it to that point.
Make sure you have enough space for flashback logs and archivelogs to store.