Stack Overflow
Stack Overflow

Questions tagged [materialized-views]

A materialized view is a database object that contains the results of a query. They can be local copies of data located remotely, or can be used to create summary tables based on aggregations of a table's data. Materialized views are also known as snapshots.

A materialized view is a database object that contains the results of a query. They can be local copies of data located remotely, or can be used to create summary tables based on aggregations of a table's data. Materialized views are also known as snapshots.

When posting questions with the materialized-views tag please add another tag with the RDBMS involved(Oracle, Sql Server, etc.)

Oracle's Materialized Views documentation here

839 questions
0
votes
1 answer

Oracle 11g Replication - Using refresh on commit with remote database (database links)

Good afternoon, I have 3 databases; the SIDs are config, prod1 and prod2. I am using Materialized Views to replicate data on 11 tables in the config database onto the other two databases. The Materialized Views are currently refreshing every five…
Karen Fearn
  • 3
  • 1
  • 2
0
votes
1 answer

Checking snapshots out of refresh groups in Oracle

I have an Oracle Database with a schema A, which has select privilege on DBA_* views. I also have an schema B that doesn't have these privilege, but it has a lot of materialized views. In schema A, there are three refresh groups, each one having…
marcostw
  • 11
  • 1
  • 3
0
votes
2 answers

Refresh in Materialized Views

I have been trying to understand Materialized Views concept from a long time but was unable to get the exact functioning of it except that it is a physical table(replica) for the tables in different server. I have tried the following CREATE…
Aspirant
  • 2,238
  • 9
  • 31
  • 43
0
votes
1 answer

RefrMaterialized View

I'm trying to get my materialized view to automatically refresh daily at 8:00 AM in the morning. I have written the below code but am not getting desired output: CREATE MATERIALIZED VIEW empl_M_V ORGANIZATION HEAP PCTFREE 10 PCTUSED 0 INITRANS 2…
user1515303
  • 1
0
votes
2 answers

Performance of Remote Materialized views in Oracle

I have a question reagrding Oracle materialized views ... We have two databases: Core Database Reporting database The reporting database has: a database link to the Core database a number of synonyms to the tables in the Core database a number of…
Evan
  • 101
  • 1
  • 5
0
votes
1 answer

Can't see Materialized Views from a Linked Server in SQL Server

I have an SQL Server 2008 Express Edition and added an Oracle DB as a linked server with the OraOLEDB.Oracle provider. The connection works but I can only see the views from the Oracle server, no tables, and no materialized views. I can SELECT * on…
alexkelbo
  • 724
  • 6
  • 18
0
votes
1 answer

Oracle materialized views or aggregated tables in datawarehouse

Is the materialized views of oracle(11g) are good practice for aggregated tables in Data warehousing? We have DW processes that replace 2 month of data each day. Some time it means few Gigs for each month (~100K rows). On top of them are…
Gluz
  • 3,154
  • 5
  • 24
  • 35
0
votes
1 answer

When are immediate materialized views updated

I use SQL Anywhere 11. I have the following view: CREATE MATERIALIZED VIEW "DBA"."PointsAcc"( /* view_column_name, ... */ ) IN "SYSTEM" AS select sum(PL.Points) AS Sum, DP.UserUID, COUNT(*) AS cnt FROM Points DP KEY JOIN PointLine PL KEY JOIN…
klundby
  • 301
  • 1
  • 3
  • 17
-1
votes
1 answer

Materialized view log of other schema

I have two tables in two different schemas SCHEME A (tbl1) SCHEME B (tbl2) I created a materialized view that joins the two tables. I would like to fast update and for that reason I have created two logs (one per table) using the rowi(ORA-12015…
ciro
  • 771
  • 1
  • 8
  • 30
-1
votes
1 answer

Syntaxerror, when creating an MATERIALIZED VIEW of tsvectors for fulltextsearch in postgresql

I am trying to implement a full text search, taking spelling mistakes into account. Therefor, I try to create a MATERIALIZED VIEW of tsvector of all relevant columns. CREATE MATERIALIZED VIEW unique_lexeme AS SELECT word FROM ts_stat( 'SELECT…
DatenDenker
  • 60
  • 9
-1
votes
1 answer

Is there a way to copy/move materialised view from one DB service name to another in Oracle?

so what I want is to create materialised view in my service but from the tables in another service of Oracle. But as the table names are bit large, I can't do it. So was thinking of work around to create materialised view in the same service only…
devCodePro
  • 97
  • 2
  • 4
  • 17
-1
votes
2 answers

Replace empty column by some string in Oracle Materialized view

I have to create a materialized view based on data:- ID Class_Code Student_Name 1 1011 Jatin 2 1012 Pual 3 Patrick 4 1014 Liaba 5 Noah and i want a materialized view to…
jaykio77
  • 379
  • 1
  • 7
  • 22
-1
votes
1 answer

Problema with kinked materialized view when overwriting existing postgis table

Main question: I have several views depending on a PostgreSQL/PostGIS table and a final materialized view created by querying the other views. I need a fast and updatable final result (i.e. MV) to use in a QGIS project. My aim is to update the…
ocelot73
  • 41
  • 5
-1
votes
1 answer

How to create a materialized view in Oracle EBS 12.2 that refreshed daily at 5PM

I am trying to create a materialized view in the xxcus custom schema in an 11g Oracle database on a Oracle E-Business Suite 12.2 installation that is editioned. I would like to access this materialized view from an Oracle Apex installation on the…
Superdooperhero
  • 7,584
  • 19
  • 83
  • 138
-1
votes
2 answers

refreshing materialized views in quill

how do I execute queries that looks like this using scala Quill library? REFRESH MATERIALIZED VIEW CONCURRENTLY transaction_view
binkabir
  • 144
  • 1
  • 6
1 2 3
…
55
56