title: Get a list of materialized view log in oracle'
body: <p>I want to get a list of materialized view logs in Oracle. How can I do that? I thought that this will give me a list: </p>
  
  <pre><code> select * from USER_BASE_TABLE_MVIEWS;
  </code></pre>
  
  <p>When a materialized view log was dropped and recreated by using the script similar to this :</p>
  
  <pre><code> CREATE MATERIALIZED VIEW LOG ON "XXX"."STATUSES_AUD"
   PCTFREE 10 PCTUSED 30 INITRANS 1 MAXTRANS 255 LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 ....
  </code></pre>
  
  <p>It does not show up when this query is run :</p>
  
  <pre><code>select * from USER_BASE_TABLE_MVIEWS;
  </code></pre>
  
  <p>Any ideas ?</p>