by: Bernard Segonnes |
last post by:
Hi
I'm a bit lost with snapshot creation, so can I have an easy (but with
all details : *.ora, user grants, *.sql, db links, ...) example of
snapshot between :
Server1 :
instance : I1...
|
by: Matthieu Exbrayat |
last post by:
Hie all,
I am currently using materialized views within Oracle 9i.
For instance I create mv1 on DB bddist2, as a snapshot of sur1 on bddist1 :
SQL> create materialized view mv1
2 refresh...
|
by: M. Mehta |
last post by:
It seems that you can not create a materialized view if you are using
outer joins...can someone please verify this?
Thanks
M. Mehta
Please follow my example below:
created 2 tables:
|
by: Geoff Bray |
last post by:
I need to set the column types and lengths in my materialized view that is
created with a select as. Anyone able to do this?
Here's one of my gazillion attempts which gave me a syntax error.
...
|
by: Vincent LIDOU |
last post by:
Do not trust values returned by materialized views under SQL Server
without frequently checking underlying tables!!!
I already posted this message under microsoft.public.sqlserver.server
and I'm...
|
by: Neil |
last post by:
I previously posted re. this, but thought I'd try again with a summary of
facts.
I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that
is linked to the database via ODBC...
|
by: Esteban Kemp |
last post by:
PostgreSql support materialized views ???
if not, there is something similar??
Thanks
Esteban kemp
|
by: sybrandb |
last post by:
JamesLane <JamesLane03@yahoo.comwrote in message news:<3042319.1056559068@dbforums.com>...
No. You are tearing things out of context. Using this procedure you
effectively *disable* replication. I...
|
by: Pink Panther |
last post by:
Hi All,
Sorry this may be a repost as first attempt died on me...
I have a set of 50 materialized views that are populated every morning.
However 2 of the materialized views contain no...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|