Uderc programming article aggregator sites
Index -> dbms refresh materialized view

dbms refresh materialized view

Advertisement

Reg:package code to refresh materialized views

i am new to pl/sql packages and procedures.i want it to execute for running mappings in informatica which takes 0 and gives 1 when executed successfully create or replace PACKAGE BODY pkg_refresh_mv as procedure prc_mv (p_mv_name varchar2) is begin d

How to Refresh materialized view

Hi, I am using 11G owb. I would like to know if any one can help me know if there is any easy to Refresh materialized view . I will be using this materialized view to source data from my maps. this map will be part of a process flow. i would like to

Refresh Materialized View in a package

Refresh Materialized View in a process. I have a USER2.Materialized view and when I want to refresh it I execute: execute dbms_mview.refresh('MV_FACT_SALES','C'); But I have the ETL process in a USER1.package The User1 needs any Materialized View Gra

Error While Creating Fast Refresh Materialized view.

Table Scripts: CREATE TABLE CONTRACT_MASTER   CONTRACT_SEQ                    NUMBER(10)    NOT NULL,   PDN                             CHAR(5)       NOT NULL,   APPID                           NUMBER(10)    NOT NULL,   CONTRACT_LOB_DESC             

Creation of fast refresh materialized view

Hi, I am creating fast refreshable materialized view.At that time i am getting error message ORA-12052: cannot fast refresh materialized view OPS$QDW.EMP_DEPT_MV I created log's also on that tables(emp,dept) Please Help me any body. I am using oracle

Fast Refresh Materialized View - failure

Okay, this issue currently has me stumped. I searched the world wide web and still cannot seem to identify the cause of this issue. Here is the scenario: I created a materialized view log for the source table (let's say table1) found at DB1. I then c

Refresh materialized view using workflow

Hi forum, I want to refresh some materialized views using oracle workflow. The dbms_mview.refresh is not in de list of public transformations when using the transformation activity. Does anybody have any suggestion / solution? Thanks in advance, Eric