Sadly, you can't just copy to a temporary dataset and then copy back, cause you'll lose the stream buffer.

I have the same issue, but I noticed it seems to be related to the streaming buffer. I have a materialized view build on this data which is giving me a different error `unapplied Change Data Capture(CDC) upsert data within a configured perid. Please ...