Stack Overflow
Stack Overflow

Questions tagged [materialized]

61 questions
2
votes
1 answer

do we need to recreate a materialized view if the underlying table structure changes

I have changed the order of columns in my base table, but after that materialized of this table in showing as invalid, even after refreshing it. Do I need to recreate the materialized view or is there something else I can implement. Is it happening…
Prakash Rai
  • 33
  • 1
  • 5
2
votes
2 answers

Create an oracle materialized view with fast refresh on aggregated join

I've got this really nasty view that I'm trying to make faster by performing some joins ahead of time via materialized views. My problem is the most expensive joins, and therefore most worthwhile to pre-execute, don't play nice with materialized…
GoldPaintedLemons
  • 482
  • 5
  • 9
1
vote
0 answers

Materialized view vs table - performance

I am quite new to Redshift but have quite some experience in the BI area. I need help from an expert Redshift developer. Here's my situation: I have an external (S3) database added to Redshift. This will suffer very frequent changes, approx. every…
Staretzu
  • 31
  • 4
1
vote
1 answer

How to create MVIEW containing dblink in postgresql

I extracted MVIEW statements from oracle database and executing those statements in postgresql db. I get below error: ERROR: syntax error at or near "@". Syntax of MVIEW statement is : CREATE Materialized view XYS as select ***** from…
Sagar Maram
  • 13
  • 2
1
vote
1 answer

Can't parallelize creation of a Materiazed View

I',m tryng to create a Materialized View referencing a remote table with over 8 million records. I put the clausole "PARALLEL 8" in DDL MVIEW statement and the hint "/*+ PARALLEL(8) */ in the MVIEW QUERY. When creating, no parallel slave process was…
Giovanni Florio
  • 33
  • 5
1
vote
0 answers

Materialize class="validate" property is not validating field in React

I am creating Materialize Form with React js, to ensure fields are not empty I am using materialize class="validate" property. Even I used required="" and aria-required="true" but while clicking on Submit button empty fields are not getting…
Abhay
  • 129
  • 1
  • 5
1
vote
1 answer

changing css style dynamically from component in Angular 5

I am using materialized range:
This input creates in HTML span tag with class thumb, how could I change the…
Sergey Vladimirovich
  • 479
  • 1
  • 8
  • 15
1
vote
1 answer

Materialized Parallax isn't working

I added a paralla code to my page, but the images don't appear, when I remove the class "parallax" from container of the image, images appear but without the parallax effect,
kach haja
  • 43
  • 4
1
vote
1 answer

How to port this Mongoose plugin to Mongoose 5

I need help porting this plugin to Mongoose 5 https://github.com/janez89/mongoose-materialized The plugin is probably not working due to mpromise being deprecated on Mongoose 5. getting error on running any method using mongoose schema promise…
Enrique Sabalza
  • 11
  • 3
1
vote
0 answers

Materialize checkbox not working

I want to display a grid of checkboxes using html (and django backend). Here is the html I wrote for that. I am using the latest version of Materialize. However the checkboxes I get are unclickable. Am I doing something wrong? I read up that…
Meet Taraviya
  • 869
  • 1
  • 8
  • 27
1
vote
0 answers

Why flexviews test_demo changelog table not created

I testing materialized view for the MariaDB which is flexviews. I'm using a CentOS latest version. I refered https://www.percona.com/blog/2011/03/25/using-flexviews-part-two-change-data-capture/ In the reference, at the step below, no table with…
Park JongBum
  • 1,245
  • 1
  • 16
  • 27
1
vote
1 answer

Materalized Views and corresponding master table log for incremental refresh in Oracle 11x

I have a complex query that does not satisfy the conditions for creating a materialized view with 'REFRESH FAST ON COMMIT' or 'REFRESH FAST'. I have created the materialized view with 'BUILD IMMEDIATE'. I have created materialized view logs on all…
user1609590
1
vote
2 answers

Materialized View - Oracle / Data is not updating

My friend has created a materialized view but the View does not receive new data from Mater Table. The view is receiving data only in creation, after it the news data are not included. Anyone can help me to resolve this issue? Fallow below my…
LozanoMatheus
  • 368
  • 1
  • 7
  • 12
1
vote
1 answer

Fail to make mview using dblink(mysql)

In my project, I need to synchronize data from MySql to Oracle. So, I tried to use Materialized View as below. step 1. make ODBC drive of MySql step 2. make DBlink to Mysql using ODBC step 3. make MView using DBlink But in step3, I got a error…
user3358517
  • 43
  • 1
  • 4
1
vote
0 answers

Oracle - MV on prebuilt table with MV log on same table

We have an Oracle 11g OLTP database that has a fairly large table on it (60 million). I will call this table, table_a. Table_a has an MV log on it (log_a). The table is replicated to an ad hoc database that is read only, via an MV using fast…
GD_Prof
  • 53
  • 1
  • 6
1
2
3 4 5