by: Prashant |
last post by:
Hi I have a problem with refreshing of Mviews , I will narrate every
thing step by step:
1.create table a (a number);
2.insert into table a values(&a); (after inserting 2 rows and
commiting)...
|
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: 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: Hans-Jürgen Schönig |
last post by:
hello ...
i am running into a couple of questions regarding materialized view logs.
my goal is to take data from an oracle database and replicate it to some
remote data store (maybe some other...
|
by: holdingbe |
last post by:
Hi,
I created a materialized view. when i refresh that views, it shows error like
this materialized view not present...
I created materialized logs also.....
Regards...
|
by: rumasinha |
last post by:
Hi,
I first created a materialized view that was based on the org striped views like po_headers hence the automatic refresh was not happening.
After automatic complete refresh, the materialized...
|
by: jonceramic |
last post by:
Hi All,
I need to know the best way to set up a datawarehouse/materialized
view for doing statistics/graphs in Access. My crosstabs and unions
are getting too complicated to crunch in real...
|
by: Preeti Bajaj |
last post by:
I created a materialized view log on table DUMMY_TAB as shown below:
create materialized view log on DUMMY_TAB with primary key including new values;
Primary key for the table DUMMY_TAB is...
|
by: kewldotnet |
last post by:
I have a query thats taking long time to execute. So i have created a Materialized view to refresh it every hour. But when the Materialized view is being refreshed, there is no data in the...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|