MATERIALIZED View does not refresh.

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 31 Jul 2007 10:29 am

Hello friends, I was testing the use of view Materialized, more I haven't had much success.

I created a view for atualizaze daily. but on the first day worked, the second not. There's no record. could someone I planned because there goes the command.


Code: Select all
CREATE MATERIALIZED VIEW SIATUBLU.VI_USER_CONS_COLUMNS
TABLESPACE TS_COMUM_BLU_DAT2
NOCACHE
NOLOGGING
NOPARALLEL
BUILD IMMEDIATE
REFRESH COMPLETE
START WITH TO_DATE('01-ago-2007 01:00:00','dd-mon-yyyy hh24:mi:ss')
NEXT TRUNC(SYSDATE) + 1 + 1/24 
WITH PRIMARY KEY
AS
SELECT OWNER
     , CONSTRAINT_NAME
     , TABLE_NAME
     , COLUMN_NAME
     , POSITION
  FROM USER_CONS_COLUMNS;
HenriqueMachado
Location: Blumenau - SC

Abraços,
Henrique Machado Muller

Poston Wed, 06 Mar 2019 2:09 pm

Topic under translation. Come back later. (This is an automatic message)
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


  • See also
    Replies
    Views
    Last Post


Return to SQL

Who is online

Users browsing this forum: No registered users and 3 guests