Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: migration of DB Oracle 7.3.4 -> 8.1.7

Re: migration of DB Oracle 7.3.4 -> 8.1.7

From: Jochen Erfurt <jerfurt_at_hpberlin.de>
Date: Thu, 25 Jul 2002 15:51:24 +0200
Message-ID: <ahovoq$iet$05$1@news.t-online.com>


The application is an old release of MS Great Plains Apertum ERP Solution. The table
system and value para are existing.

Hope this helps:



2002-07-25-14.38.55.020000: 'S.C.I. GmbH - Auftragsverwaltung' SQL-Fehler 20980 - ORA-00980: Synonymubersetzung ist nicht mehr gultig, position: 0, handle: hSql
Letztes registriertes SQL-Kommando:
select wert into :sValium0 from system where para = 'PLZusatz'

ORA-00980 synonym translation is no longer valid Cause: The synonym used is based on a table, view, or synonym that no longer exists.
Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.

Jochen

"Peter van Rijn" <p.vanrijn_at_rm-this.zhew.nl> schrieb im Newsbeitrag
news:ujvh8nol7hgvf5_at_corp.supernews.com...

> Perhaps you could give us some details. "Not properly working" is really
not
> enough to get us "properly working"!!
> Error messages, performance aspects, connection problems, etc, etc.
>
> Peter
>
>
> "Jochen Erfurt" <jerfurt_at_hpberlin.de> schreef in bericht
> news:ahofai$ahh$01$1_at_news.t-online.com...
> > Hello,
> >
> > I have to migrate an Oracle 7.3.4 DB to Oracle 8.1.7 and have only
> > access to a DB dump.
> >
> > Setting up an DB with Oracle 8 and importing the dump works fine,
> > however my application does not work proper.
> >
> > Thanks and best regards,
> >
> > Jochen Erfurt
> >
> >
>
>
Received on Thu Jul 25 2002 - 08:51:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US