Stack Overflow
Stack Overflow

Questions tagged [materialized]

61 questions
20
votes
4 answers

How to view the original script of a materialized view?

I am interested in moving a materialized view from one db to the other, regardless, I also need to change one of the columns. How can I view the original script that build the MV? I am running TOAD, but cannot seem to find the original script.…
AYR
  • 1,139
  • 3
  • 14
  • 24
19
votes
1 answer

Material Design Forms

I am doing research on Material design and some of the guidelines described in material design. A section that I seem to be missing (not sure if it should be covered), is how Google approaches Fieldsets. The documentation does cover individual…
HermannHH
  • 1,732
  • 1
  • 27
  • 57
17
votes
3 answers

ORACLE : Materialized view not working when Using LEFT JOIN

I want to create a MATERIALIZED VIEW from a LEFT JOIN of 2 tables. However the following gives me an error: SELECT field1 FROM table_1 a LEFT JOIN table_2 b ON a.field1=b.field2 ORA-12054: cannot set the ON COMMIT refresh…
drenocartero
  • 4,941
  • 7
  • 26
  • 26
13
votes
5 answers

How to detect Materialized.js modal closing event?

How to detect the closing event for materialized.js? I want to run some JavaScript code when the modal got closed either by clicking on modal close button or pressing escape button or clicking on any other area of the screen.
Abdul Rahman
  • 1,669
  • 4
  • 24
  • 39
8
votes
4 answers

Create Oracle Materialized View to be refreshed every 5 minute Using materialized view log

I'm Trying to create Materialized View which will be updated every 5 minute automatically, I need update based on Mview log table. I have created Materialized view log on TABLE1 TABLE1.SQL Script CREATE MATERIALIZED VIEW LOG ON TABLE1; --…
JiboOne
  • 1,438
  • 4
  • 22
  • 55
7
votes
1 answer

T-SQL CTE materializing techniques not working on SQL Server 2012

I have to use the following techniques to materialized my CTEs and increase the view performance: WITH CTE AS( SELECT TOP 100 PERCENT ORDER BY ... ) WITH CTE AS( SELECT TOP 2147483647 ORDER BY ... ) Now, neither of this ways works.…
gotqn
  • 42,737
  • 46
  • 157
  • 243
6
votes
1 answer

Oracle materialized view with Entity Framework model

Is it possible to query Oracle materialized view with Entity Framework model using linq?
eozcan
  • 115
  • 2
  • 9
5
votes
1 answer

ORACLE : Materialized view- change START WITH CLAUSE

I created a Materialized view using the following code: CREATE MATERIALIZED VIEW M_USER_HIERARCHY BUILD IMMEDIATE REFRESH COMPLETE START WITH TO_DATE('25-Aug-2009 10:34:24','dd-mon-yyyy hh24:mi:ss') NEXT SYSDATE + 1 WITH PRIMARY KEY AS…
drenocartero
  • 4,941
  • 7
  • 26
  • 26
4
votes
1 answer

ORACLE: Fast Refresh on Materialized View not working with OUTER JOIN in some conditions

problem is simple. I create TableParent and TableChild linked by foreign key. I create Materialized View Log for both. I create Materialized View with fast refresh as left join from TableParent to TableChild. Result is Adding a child record,…
kinghomer
  • 3,021
  • 2
  • 33
  • 56
3
votes
2 answers

ORA-30372 fine grain access policy conflicts with materialized view

I'm trying to create Materialized view which will run every 6 hour at DB1, and replicate data from DB2 table. I have created MLOG$_REMOTE_TABLE1 on DB2 remote table. I'm using Oracle 11g (p.s oracle 12g has no problem while executing this script…
JiboOne
  • 1,438
  • 4
  • 22
  • 55
3
votes
1 answer

SQL Server Indexed Views vs Oracle Materialized View

I know materialized view and I'm using it. I have never used indexed views but I will. What are the differences between them ?
Burcu Bağdatlı
  • 41
  • 1
  • 7
3
votes
1 answer

Options for indexing a view with cte

I have a view for which I want to create an Indexed view. After a lot of energy I was able to put the sql query in place for the view and It looks like this - ALTER VIEW [dbo].[FriendBalances] WITH SCHEMABINDING as WITH trans…
tusharmath
  • 10,622
  • 12
  • 56
  • 83
2
votes
2 answers

Indexed Views in OLTPs?

I'm familiar with SQL Server Indexed Views (or Oracle Materialized Views), we use them in our OLAP applications. They have the really cool feature of being able to usurp an execution plan and remap it to the indexed view w/out having to change…
Tyler
  • 3,220
  • 1
  • 30
  • 44
2
votes
1 answer

Getting chips data in Materialize css through Post

I am trying to get the data using the Materilize css's chips. But no data is received when I try to submit it using a form. I checked that the input fields value was null once I added the chips. I wrote a jquery code to verify…
Shahrukh Mohammad
  • 985
  • 2
  • 17
  • 33
2
votes
0 answers

Refresh Materialized View over DB Link

DB B is connected over DB-Link with DB A. On B I created materialized view mav_test, that took about 40 seconds and works fine. If I try to refresh mav_test now e.g. with 'execute dbms_mview.refresh('mav_test','c');' and other commands, System B is…
user
  • 157
  • 2
  • 14
1
2 3 4 5