Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mlog purge

DBAppsJun 9 2015 — edited Jun 10 2015

Hi Gurus ,

I am using oracle 10.2.0.5 and need help in purging this mview log .

Please find the below details .

Kindly request your help in purging the mlog.

Also if the below steps could be carried out .

```
 Un-Register Mview
```

exec DBMS_MVIEW.UNREGISTER_MVIEW (mviewowner => ‘TCP_RF’,mviewname => ‘MV_MERT_USER’,mviewsite => ‘TPSW.WORLD’);

Drop the mview log on the master table.

DROP MATERIALIZED VIEW LOG ON NIM.MERT_USER;

Re-create the mview log on the master table.

CREATE MATERIALIZED VIEW LOG ON "NIM"."MERT_USER" PCTFREE 60 PCTUSED 30 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "DATA1"

WITH PRIMARY KEY EXCLUDING NEW VALUES;

C Complete refresh of the mview on the all the dependent sites .

Thanks for looking ,

Regards,

DBApps

Message was edited by: DBApps

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2015

Added on Jun 9 2015

#general-database-discussions

4 comments

372 views