Amicuk Programming Answers

Materialized View to external dB

2015-10-11   Views:0


I want to create a materialized view in 8.1.6 from an external dB (MS Access)using the Generic data access (Generic OTG), but cannot find documentation that tells me how to use the Generic OTG. The MS Access data can not be permanently brought into O

I want to create a materialized view in 8.1.6 from an external dB (MS Access)using the Generic data access (Generic OTG), but cannot find documentation that tells me how to use the Generic OTG. The MS Access data can not be permanently brought into Oracle since it is part of another application, but is needed in Oracle for further analysis. Where is the documentation for the Generic OTG?

The replay answer
Materialized views are schema objects that can be used to summarize, compute, replicate, and distribute data. They are suitable in various computing environments such as data warehousing, decision support, and distributed or mobile computing:
In distributed environments, materialized views are used to replicate data at distributed sites and synchronize updates done at several sites with conflict resolution methods. The materialized views as replicas provide local access to data that otherwise has to be accessed from remote sites.
Materialized views are similar to indexes in several ways:
They consume storage space.
They must be refreshed when the data in their master tables changes.
They improve the performance of SQL execution when they are used for query rewrites.
Their existence is transparent to SQL applications and users.
Unlike indexes, materialized views can be accessed directly using a SELECT statement. Depending on the types of refresh that are required, they can also be accessed directly in an INSERT, UPDATE, or DELETE statement.
A materialized view can be partitioned. You can define a materialized view on a partitioned table and one or more indexes on the materialized view
A materialized view contains a complete or partial copy of a target master from a single point in time. The target master can be either a master table at a master site or a master materialized view at a materialized view site. A master materialized view is a materialized view that functions as a master for another materialized view. A multitier materialized view is one that is based on another materialized view, instead of on a master table.
It requires lot of experience thats it.

Go to See the other 3 answers

Materialized View to external dB

Category:DefaultRelease time:2015-10-11Views:130

I want to create a materialized view in 8.1.6 from an external dB (MS Access)using the Generic data access (Generic OTG), but cannot find documentation that tells me how to use the Generic OTG. The MS Access data can not be permanently brought into O[More]

Synonym problem with external table in materialized view

Category:DefaultRelease time:2015-10-11Views:130

I have a materialized view that includes selects on two external tables. However, no matter how I try to access the external tables, the creation fails with a "Synonym Translation Is No Longer Valid" (ORA-00980) error. This happens even when I r[More]

Creating materialized view with variables - help

Category:DefaultRelease time:2015-10-11Views:130

Greetings, I want to create an materialized view (MV) from the external public db link. Below is my full query: CREATE MATERIALIZED VIEW PROJECTS_MV REFRESH WITH ROWID AS SELECT prj.Project_id, prj.desc, prj.parent_project_id, f_year, f_month FROM sy[More]

Refresh/Update data in a materialized view

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have question about the data in a materialized view and how it is refreshed. My mat view has all my dimension-ids and my (for my specialize needs) aggregated measures from my fact table. I used the mat view wizard to create my view - which work[More]

How can I fast refresh the  materialized view !!

Category:DefaultRelease time:2015-10-11Views:130

I created a MV base on some tables in order to improve the querey speed. but the mv I have created falied to refresh fast. because there are two same table in the from clause: jcdm jc1,jcdm jc2 create materialized view temp_mv nologging pctfree 0 sto[More]

How to get Materialized View to ignore unused columns in source table

Category:DefaultRelease time:2015-10-11Views:130

When updating a column in a source table, records are generated in the corresponding materialized view log table. This happens even if the column being updated is not used in any MV that references the source table. That could be OK, so long as those[More]

Materialized View to run only once in a year...

Category:DefaultRelease time:2015-10-11Views:130

Hi everybody... I want to create a materialized view which will run only once in a year and specifically some minutes after 00:00 a.m. on new year's day, so i created the following: CREATE MATERIALIZED VIEW <mv_name> BUILD IMMEDIATE REFRESH START WI[More]

Is it possible to refresh the table from a Materialized view

Category:DefaultRelease time:2015-10-11Views:130

Hi, Is it possible to update the underlying table on which a Materialized view is created when some changes in a Materialized view is done.Is this reverse compatibility possible in Materialized View? Thanks in Advance, V.DennisIf you created the mate[More]

The data of my materialized the while

Category:DefaultRelease time:2015-10-11Views:130

Hello We have problems with materialized views We have one wich re-build each a short period of time ¿Can i avoid the data to dissapear in the time process of refresh? Is so annoing to our clients to see that "from time to time" the data just di[More]

I have upgraded my iMac from 10.7.5 to Mavericks (10.9.4) I now have a wireframe on my display that follows my cursor. I have not found anything in System Preferences to turn it off. Can anyone help me to get rid of it?From the menu bar, select       [More]
i am locked out of my ipad mini...pLEASE helpIf you cannot remember the passcode, you will need to restore your device using the computer with which you last synced it. This allows you to reset your passcode and resync the data from the device (or re [More]
I bought a MB Pro and I wanted to use the DVI to VGA adapter but it's too short, is there a longer one or is this it?Maybe if you need a male-to-female. In other words, that pro [More]
I'm trying to use kerberos V5 with ActiveDirectory im using simple code from previuos posts but when i try with correct username/password i get : Authentication attempt Message stream modified (41) when [More]
Hello Experts, I m developing a report in which i have to capture accounting document number which has been generated against the cancelled A/c document number. Is any field populated when the a/c doc num has been canceeled so that we can make out th [More]
Dear, All Experts. When trying to delete vendor via OBR2 I am getting this error. Links stored incompletely Message no. FG166 Diagnosis Customer/vendor links are to be taken into consideration when archiving or deleting customers or vendors. To do th [More]
I have a Macbook Pro 17-inch, Mid 2009, with a 2.8 GHz Intel Core 2 Duo processor. I use an external HDD connected directly to my Mac via FireWire 800 for Time Machine backups. I have an external HDD connected to my Airport Extreme (Gigabit) router t [More]
2014 >>>>WK99 >>>>>>>>AFolder >>>>>>>>>AFolderPSD >>>>>>>>BFolder >>>>>>>>>BFolderPSD >>>>>>>>CFolder >>>> [More]
Dear all, I create a report such as select * from mytable.table1 where field1 = :bind_variable I create a menu to run this Customized Form and user have to select the bind_variable values. So I have another report created which also want this bind_va [More]
Hi, On a Windows 2008 R2 we get a Windows Backup error while backupping System State (event id: 5, error code: '2155347997'). We tried *ALL* solutions found on Internet regarding the same issue (and we also applied the suggested hotfix KB2807849) but [More]