 | |
Re: import - synonym still point to old schema
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: import - synonym still point to old schema -
07-10-2003
, 03:41 PM
|
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
#2
| |||
| |||
|
|
On 10 Jul 2003 12:32:05 -0700, datavector (AT) hotmail (DOT) 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 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?
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.