Sitemap

Amicuk Programming Answers

Synonym problem with external table in materialized view

2015-10-11   Views:2

Advertisement

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

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 replace the tablename with the full table name, including the link.
I can create a view just fine, but if I then try something like CREATE MATERIALIZED VIEW mvw_my_view AS SELECT * FROM vw_my_view (where vw_my_view is the view in question), it still throws the Synonym Translation exception.

The replay answer
Advertisement
00980, 00000, "synonym translation is no longer valid"
// *Cause: A synonym did not translate to a legal target object. This
//         could happen for one of the following reasons:
//         1. The target schema does not exist.
//         2. The target object does not exist.
//         3. The synonym specifies an incorrect database link.
//         4. The synonym is not versioned but specifies a versioned
//            target object.
// *Action: Change the synonym definition so that the synonym points at
//          a legal target object.It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

Go to See the other 9 answers

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]

Problem with replication based on materialized view

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

Problem with replication based on materialized view... Given: 1. Source: S-1 2. Targets: T-1, T-2 3. DB links: from T-1 to S-1, from T-2 to S-1 Required replicate table TBL on S-1 to T-1, T-2 via db links. On S-1 was created materialized view log wit[More]

Table and Materialized View in different namespaces?

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

I've just faced something completly new for me. It appears that there are two objects with the same name and owner. Table and Materialized View have the same names and when I look into system dictionary I can se sth. like that: OWNER OBJECT_NAME OBJE[More]

Truncate table and materialized view log

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

I user oracle 10 R2 I have a table and on that table a materialized view log. I execute in a pl/sql procedure: 1) execute immediate('drop materialized view log on tab1'); then: 2) execute immediate('truncate table tab1'); 3) Now I insert a lot of rec[More]

Oracle equals_path condition NOT working with table and materialized view

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

The user i am using is xdb with dba role. 1.When i try to use the statement SELECT PATH FROM xdb.path_VIEW WHERE EQUALS_PATH(res, '/home/OE/PurchaseOrders/2002')=1 the result is /home/OE/PurchaseOrders/2002 2. When i drop the path_view and recreated[More]

Dropping base table of materialized view

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

HI please let me know what happens if i drop the base table of a materialized view? does the MV remain valid with data?Hi, Well, it's easy to test yourself. SQL> select count(*) from t1;   COUNT(*)        100 SQL> desc t1 Name                       [More]

User_catalog - object listed as both 'TABLE' and 'MATERIALIZED VIEW'

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

SELECT * FROM USER_CATALOG ORDER BY OBJECT_NAME returns ... OBJECT_NAME              OBJECT_TYPE        BLOBBY                   SYNONYM            BONUS                    TABLE              DEPT                     TABLE              EMP           [More]

Convertion of Base tables to Material views while executing dbms_refreshes

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

Hi all, I have a typical type of problem. We have a daily task of database activities like monitoring the space, refreshing Material views etc and currently using While doing refreshing the materialized views (using dbms.refresh) All master tables ar[More]

External table fails to view data after changing file name

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

Hello, I have previously imported 122 external tables and was able to view their data without any problems. The names of these files have since changed. The names have a date in them. So I dropped the external tables from that database and recreated[More]

Need Advise on Global Temporary tables or Materialized views or Views

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

Need advise on a plsql procedure working on. I had 6 tables having 200,000 rows in total intially,but will get added a maximum 20,000 rows daily by a batch process. I am writing a plsql code that takes an input ,for example customer_id, and is requir[More]

A problem about ORA-12058 of materialized view

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

consider the huge data of tableB, we make a decision about build materialized view using "on prebuilt table" parameter. create materialiezd view log on tableB rowid mode. when we create materialized view we got the error ORA-12058. Is there some[More]

Hot
Hi, How can I get the text in a large text field to start at the top left of the field rather than at the center of the field? In addition, may one know how to make text wrap in the form as well? Thanks, DavidTo set the Text alignment properties use [More]
Can't start macbook after a failed installation.Have you tried holding down the power button and home button at the same time until the device turns off...then let go.  Can you take a picture of the box?Read other 2 answers [More]
Please review and approve the new app update "iDB Datamaster - Pro" Version 1.2, by Evince Technologies, Inc as soon as possible. All of the customers of Version 1.1.3 are enraged by it's failure to run under iPhone OS4. The makers claim that th [More]
i'm wanting to get windows 7 home premium for my macbook pro which is on os x lion version 10.7.4 and i'm wondering what version of windows is better to get, the 32 bit version or the 64 version? thank you for your helpBoot Camp- Macs that work with [More]
I am trying to create a logical dimension table by dragging the corresponding table from the physical layer. However, in the business model layer it shows up with a yellow icon indicating it is a logical fact table. Please help me how I create a logi [More]
Hi All, Can anybody send me steps to create customer using FD01, Thanks. regards, VishalDear Vishal, In Transaction FD01, 1)Give the relevant Account Group, Company code and the Sales Area for which you want to create customer and click continue. 2)E [More]
Hi Experts, I downloaded the DVDs from SAPnet and I am using as a Master DVD the one with the Number:51033746_15. During the installation I choose: My SAP 2004 and UniCode. But the DVD seems to be wrong. Could you please let me know the correct DVDs [More]
Hello, I have had this happened a couple of times, although most of the time I don't have this problem, and I haven't been able to locate the option to stop this. Simply put, when I select the Page Tool in the toolbox and I resize the page, once I re [More]
I am using an iPhone connected to an Exchange 2007 server. On myt mac I am running Snow Leopard and have my mail connected to Exchange as well. The mail syncs just fine, but the one thing that I noticed is that when I respond to an email from my ipho [More]
AAARRRGGHhh!!!!! I HATE the MS Paint in Win 7!!! I want to save a .BMP with just TWO colors - Black & White -  for use in another program where I import a .BMP. However I can't import since I get an error that the .BMP is more than 256 colors....EVEN [More]