How to view the original script of a materialized view?

sql oracle view materialized
AYR picture AYR · Jun 24, 2013 · Viewed 69.2k times · Source

I am interested in moving a materialized view from one db to the other, regardless, I also need to change one of the columns. How can I view the original script that build the MV? I am running TOAD, but cannot seem to find the original script.

Thanks in advance!

Answer

Marco Baldelli picture Marco Baldelli · Jun 24, 2013

You can use the function dbms_metadata.get_ddl:

select dbms_metadata.get_ddl('MATERIALIZED_VIEW', 'MVIEW_NAME') from dual;

Related questions

What is the difference between Views and Materialized Views in Oracle?

What is the difference between Views and Materialized Views in Oracle?

Read More
Query on View is running slower than direct query - in Oracle

I tried creating view with parameters to get the data dynamically. (I cant use WHERE condition as the select statement itself changes based on the parameters) For this, I wrote a procedure which returns me the required data as oracle …

Read More
Oracle Create View issue

I am logged in as the dba account and I want to create a view in User1's schema, but selecting data from User2's. I used the following query: CREATE OR REPLACE VIEW User1.NewView (Column1) AS SELECT DISTINCT …

Read More