Sitemap

Amicuk Programming Answers

Materialized View to external dB

2015-10-11   Views:0

Advertisement

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
Advertisement
Hi,
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.
Regards
vinod

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 view....in 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]

Hot
Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default [More]
I added my twitter account and can no longer see any of my contacts in Address Book or send emails to address book entries. Removing the account brings all address book entries back.Recommendation for your consideration Hopefully your original user a [More]
The Z4 app makes use of front facing camera, but dosen't connect to my friend on macbook. Any Ideas why not?danno01 wrote: The Z4 app makes use of front facing camera, but dosen't connect to my friend on macbook. Any Ideas why not? I have not tried t [More]
Hello ! Since 2 weeks or so mail opened with a folder "october12" and not with the in-box. I try to "highlight" in-box, close mail and open it again, but still the same. What can I do to make mail open with the in-box ? Thanks in advan [More]
adobe flash player for ios 7on ipad?No. Flash for all mobile devices was discontinued over 2 years by Adobe. There was never a version for iOS. Flash on mobile is dead.Read other 2 answers [More]
Hi All, We have successfully  configured Milestone Invoicing Plan Scenario, but are facing one issue. We were successfully able to transfer PS invoicing plan to PO. After milestone is confirmed when we go to check PO in DISPLAY mode, block is still t [More]
I am a newbie with MPEG and would like to know what type or kind of file is necessary to make a QuickTime movie for the Internet. The producer of the files gave me a DVD which was not mountable on my computer, so I could not even see what kind of fil [More]
I am using FTPConnection.java by Bret Taylor, for uploading files to remote linux portal. But i cannot issue any unix command from it . please anyone help me in this case?Read this: http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html It' [More]
Hello, I m making a program I want to take a backup of database on a click of a button for which i want to execute this query : "mysqldump --user=root --password=root --opt dbname>c:\backup.sql" and my code is : String command = "cmd /c [More]
I've rented several movies over AppleTV, but can not download. I get a message "An error occurred loading this content. Try again later. " i've been trying for 3 days now... anyone with similar problem?I have the same issue, to temporarily fix i [More]