9 Replies Latest reply: Jul 3, 2013 1:24 AM by Richard Harrison . RSS

    Materialized view definition from export

    scott.wesley

      Hi,

       

      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?

       

      Cheers,

       

      Scott