9 Replies Latest reply on Jul 3, 2013 6:34 AM by Scott Wesley

    Materialized view definition from export

    Scott Wesley



      Long time Oracle developer, first time poking with imp - I'm trying to find the definition on a materialized view from the dmp file, using windows.


      I've used:

      imp userid=dev/pwd file=C:\OraExports\DEV.dmp  show=Y fromuser=devmgr touser=devmgr 2> c:\scott_all.txt

      but can't locate the object I'm looking for - only the synonym of the same name.


      Are snapshots included in a typical export? Any other suggestions for locating the SQL defn?