What are the characteristics of table streams?
Dropping a source table removes the version history on which its stream depends, so the stream can no longer track change data and becomes stale. Multiple streams may exist for one table, and renaming a source object does not cause its stream to become stale.
Community Discussion