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]

Eg, the phone automatically brings up an old (defunct) AppleID account login every time I try to update my Apps. I don't know the pword for this account, nor does it have current data about me. But when I go to settings: store it shows me logged into [More]
Hello all, I recently had a situation where I needed to use ADDT's "Export Recordset as XML" behavior. However, the "Export Recordset as XML" behavior creates a php page that generates the XML when the php script is run and the resulti [More]
Hi It is possible of course to create a form on a dynamic page and have a user provide input. But how can the user input be retrieved, if the user input is sent to the same page or to another Portal dynamic page? As a Portal dynamic page can only con [More]
Hi Experts, Im wirting a BDC for MM02. There is a problem that the number of views maintained in Materials Master are not same. So in recording, the view marked for selection does not correspond to the view when opening MM02 for some material. Please [More]
it says caution and that my library is locked and on a locked disk. How do I get these pictures uploaded from my compactflash?Back Up and try rebuild the library: hold down the command and option (or alt) keys while launching iPhoto. Use the resultin [More]
Anybody know how to email a picture taken by an ipad air? Any clue would be appreciated. ThanksGo to the Photos App, touch the photo, and select the share icon (box with arrow) at lower left, then select Mail.Read other 2 answers [More]
My OEM edge code will not load in web browser after it has been uploaded to the server. I am using dreamweaver & the OEM file. The images are all grouped & labeled properly (within Edge Animate). Note the website will not load with ANY web browser [More]
Hello. I'm stumped by a problem I'm sure I inadvertently created. While becoming acquainted with Font Book, I managed to trash all the fonts, an embarrassment for someone who started years ago with a 512K Mac. I rescued them, dumped them back in the [More]
Help. Upgraded to iTunes 8 two days ago and it doesn't work. I get a message that says iTunes help module has stopped working and then a message that iTunes has experienced an error and must close (after the interim message that Windows is looking fo [More]
Hi gurus, As mention in subject. Does ABAP web-dynpro model relies on JCO? Did a quick search without solid answers...JCO, is Java Connectors to connect SAP from Java world You don't need any JCO when you are in the same ABAP Stack There is no model [More]