I have a materialized view. I want to create a copy of it so I can modify some of the data to test a few theories about an issue and its possible solutions.
How do I make a copy of this MV as a table? The copy will reside in the same schema but will have a different name. the copy should be an identical copy (structure and data) of the MV, it's just going to be a table so I edit the data.