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.


It sounds like you just want a CREATE TABLE AS SELECT

CREATE TABLE your_new_table_name
  FROM your_materialized_view

If there are indexes on your materialized view that you want to create on the table, you'd need to create those separately.

| improve this answer | |
  • Not sure why SO believe I voted your answer down. There's nothing wrong with it, but I can't change "my" vote since it is locked :-( – Lennart Sep 4 '15 at 5:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.