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]

Create material view with MATERIAL_MAINTAIN_DARK

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

Hello ! I have done a material migration program with FM MATERIAL_MAINTAIN_DARK. The program integrate the basic data, and then each view one by one. It works fine except with material with internal number. It creats the basic data but when i use the[More]

Materialized View and AND/OR

Category:DefaultRelease time:-0001-11-30Views:130

I am really in need of some help as I am having trouble refreshing this materialized view. Basically the code below if triggered by executing the SQL manually will pull the correct records which is somewhere in the 970 unique record range. Having kno[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]

b My goal: A generic script object with custom classes; and creating object instances in the form (and add them as property to XFA-objects). b My code in Script Object (named: 'gModel'): >function CustomClass() { > this.property1 = "Hello World [More]
In a previous (long) thread I had asked about using Business Partners and the problem I was having assigning work to a BP.  I keep getting the error message "no work center found for resource".  I was told that to fix this problem I was told &qu [More]
Problem: facelets not located in the root folder are unable to reference the project css file. I have a facelets template: layout.xhtml in my WEB-INF folder. When I reference the template from a .xhtml page in the root directory the css file is found [More]
how to rectify -- transport error 202 bind failed address already in use-- while running CA server i have created new production and pub server, first i runned production server after that while running CA server i got that error. if i run CA server [More]
Newly installed Windows 2012 R2 server throws the following event roughly every 3 minutes: Session "" failed to start with the following error: 0xc0000022 The PID referenced in the event points to WmiPrvSE.exe running as NETWORK SERVICE.  Is th [More]
I have a file in pages I am trying to create to make three separate documents at once.  I have a check out sheet, an invoice, and a rental agreement.  I want to have an entire table duplicated from the check out sheet to the invoice, but the table wi [More]
Hello Is it possible that my edited pictures on Iphoto get imported as original (with no changes) to my Ipad2? Is there a solution? Thankyou! AlexAlexmanj- I believe you are correct.  Try exporting the photos from iPhoto and placing them in a folder. [More]
Hallo experts! If I have an InfoCube which has among others two characteristics, 0MATERIAL and 0VENDOR, should i put them in one dimension or not? We have sometimes multiple vendors for one material and one material can be produced or delivered by mu [More]
Once again, and without obvious cause, my browsers (Safari and Opera) stopped allowing connection to BOA's website. The error is BAD REQUEST...your browser sent a query this server does not understand. Apple's only solution, reinstall the OS (twice n [More]
I have an Apple account but i can't install the free Applications always asking about the billing payment?so what shall i do?You need to supply the Requested Information...Read other 2 answers [More]