-
Diff betwn Materrialized views
Dear Sir,
1. I want to know exact differnce between
Updatable Materialized view(MV) & writtable materialized views.
2. Can you insert into Updatable MVs ?
3. What is syntax for creating writtable MVs ????
And why Oracle says that writtable MVs are very rare.
I have typical requirements for this but I am worrying about any risk involved if at all any.
viraj
-------------
9i OCA
A Wise Man Knows How much he doesn't know !!!
-
What documentation did you read for discussion of writable MV and updatable MV?
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
Dear sir
Oracle Provided Documention name :Replication.dbf
(I have downloaded this pdf ,few days back)
My questions are very basic.
I have tried out inserting into MV it does inserts but even afer refresh also it can not be viewed at Master site .
AM I GOING CONCEPTUALLY WRONG ???
A Wise Man Knows How much he doesn't know !!!
-
Reference
This topic/subject comes under Oracle Advance Replication for your reference.
Viraj
-----------------------
9i OCA
A Wise Man Knows How much he doesn't know !!!
-
SOS
dear sir ,
Hey Where have all Oracle Expert in this site has gone ????
Specialy Advisors
Someone Reply for this question ???
Viraj
------------
9i OCA
A Wise Man Knows How much he doesn't know !!!
-
Re: SOS
Originally posted by virajvk
dear sir ,
Hey Where have all Oracle Expert in this site has gone ????
Specialy Advisors
Someone Reply for this question ???
Viraj
------------
9i OCA
Yep! Thats the way to get your questions answered.
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|