In the Oracle database server use, another user (called MIMIC2DEVEL
) created a materialized view and made it public. How to view the original script that was used to built it?
Here are the grants on the materialized view:
I am aware of How to view the original script of a materialized view? but the two solutions proposed there do not seem to work for materialized views that was created by another user.
I use Oracle SQL Developer and the database server runs: