Re: import - synonym still point to old schema

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<5rjrgvshbarugfssuajde2fbhm38gtkku3_at_4ax.com>...
> On 10 Jul 2003 12:32:05 -0700, datavector_at_hotmail.com (Ken Chesak)
> wrote:
>
> >Oracle 8.1.7
> >
> >I have exported db1_old and imported to db1_new. There are two other
> >databases, db2_old and db2_new. The db2s contain some common tables.
> > Access is granted by db2 owner to schema owner of db1. Synonym
> >created in db1.
> >
> >After import to db1_new, the tables in db2_new can be
> >view,selected,etc via synonym. But cannot compile any stored procs
> >which use the synonym pointing to two_itst.
> >
> >The compile error references the old schema, which is db2_old. If I
> >change to db2_new.tablename then all is fine.
> >
> >Looking at the synonym via user_synonym everything is fine and points
> >to new schema.
> >
> > db1_old ---> db1_new
> >
> > db2_old ---> db2_new
> >
> > select db2_new.table from db1_new OK
> >
> > compile proc in db1_new with reference to db2_new NOT OK
> >
> >Thanks
>
>
> Not sure why you aren't simply compiling those procedures as *owner*
> of the procedure.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

I was compiling as owner.

I was able to correct this problem by first dropping the synonym and then creating it. I had been using create or replace, which resulted in the synonym pointing to the old schema. There was nothing in user_synonym about the old schema. Any ideas? Received on Fri Jul 11 2003 - 08:54:55 CDT