Doubt Materialized View FAST, FORCE, COMPLETE

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

Poston Thu, 27 Sep 2007 11:44 am

Good morning guys, I'm here again and today with an easy question I guess.

Was wondering what the difference to create a Materialized VIew with Fast Refresh or with Force and Refresh Referesh Complete, because I'm trying to create a Fast Refresh and tells me that I can't create with a more advanced query, and the documentation tells me to put FORCE or COMPLETE.
meguelito
Location: Santa Catarina

Att.:
Alan Juliano Metzger
Programador Oracle
Inside System Informática
Msn/E-mail: alanjuliano@yahoo.com.br

Poston Thu, 27 Sep 2007 1:34 pm

Yes: there are a number of restrictions to creating materialized views. This link is being spoken exactly about it: viewtopic.php?t=735 viewtopic.php?t=1720 (I do not know by heart the restrictions, will have to consult the documentation).
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

Poston Thu, 27 Sep 2007 1:46 pm

Yes I know there are restrictions but I was wondering what is the difference between the three ways that I know the FAST take only the new records and the COMPLETE takes time and FORCE does what???
meguelito
Location: Santa Catarina

Att.:
Alan Juliano Metzger
Programador Oracle
Inside System Informática
Msn/E-mail: alanjuliano@yahoo.com.br

Poston Wed, 17 Jan 2018 3:50 pm

Topic under translation. Come back later. (This is an automatic message)
Yana Disconzi

Poston Fri, 02 Aug 2019 4:37 pm

Topic under translation. Come back later. (This is an automatic message)
edutavaresjiva

Poston Fri, 02 Aug 2019 8:54 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

Poston Sat, 03 Aug 2019 2:14 pm

Topic under translation. Come back later. (This is an automatic message)
edutavaresjiva


  • See also
    Replies
    Views
    Last Post


      Return to SQL

      Who is online

      Users browsing this forum: Bing [Bot] and 3 guests