 | |
"Drop Public Synonym" hangs
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
"Drop Public Synonym" hangs -
08-05-2008
, 03:04 PM
#2
| |||
| |||
|
|
We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob |
IIRC, you can't db-link from 10g to 8i directly (not sure about that though)
Shakespeare
#3
| |||
| |||
|
|
We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob |
IIRC, you can't db-link from 10g to 8i directly (not sure about that though)
Shakespeare
#4
| |||
| |||
|
|
We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob |
IIRC, you can't db-link from 10g to 8i directly (not sure about that though)
Shakespeare
#5
| |||
| |||
|
|
We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob |
IIRC, you can't db-link from 10g to 8i directly (not sure about that though)
Shakespeare
#6
| |||
| |||
|
|
BobsGT... (AT) gmail (DOT) com> schreef in berichtnews:f2ad0b04-36e2-4f26-b20c-498558aebd30 (AT) 25g2000hsx (DOT) googlegroups.com... We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob Maybe if you tell us the exact name of our_synonym. IIRC, you can't db-link from 10g to 8i directly (not sure about that though) Shakespeare- Hide quoted text - - Show quoted text - |
David Fitzjarrell
#7
| |||
| |||
|
|
BobsGT... (AT) gmail (DOT) com> schreef in berichtnews:f2ad0b04-36e2-4f26-b20c-498558aebd30 (AT) 25g2000hsx (DOT) googlegroups.com... We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob Maybe if you tell us the exact name of our_synonym. IIRC, you can't db-link from 10g to 8i directly (not sure about that though) Shakespeare- Hide quoted text - - Show quoted text - |
David Fitzjarrell
#8
| |||
| |||
|
|
BobsGT... (AT) gmail (DOT) com> schreef in berichtnews:f2ad0b04-36e2-4f26-b20c-498558aebd30 (AT) 25g2000hsx (DOT) googlegroups.com... We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob Maybe if you tell us the exact name of our_synonym. IIRC, you can't db-link from 10g to 8i directly (not sure about that though) Shakespeare- Hide quoted text - - Show quoted text - |
David Fitzjarrell
#9
| |||
| |||
|
|
BobsGT... (AT) gmail (DOT) com> schreef in berichtnews:f2ad0b04-36e2-4f26-b20c-498558aebd30 (AT) 25g2000hsx (DOT) googlegroups.com... We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE; create or replace public synonym our_synonym for some_other_table; Any ideas on why this is happening and what the remedy is? Thanks Bob Maybe if you tell us the exact name of our_synonym. IIRC, you can't db-link from 10g to 8i directly (not sure about that though) Shakespeare- Hide quoted text - - Show quoted text - |
David Fitzjarrell
#10
| |||
| |||
|
|
Maybe if you tell us the exact name of our_synonym. IIRC, you can't db-link from 10g to 8i directly (not sure about that though) Shakespeare |
Fitz).
2. How would my synonym name help you to respond?
3. Maybe I am cranky now (late afternoon) - but why did you bother
responding with no info?
|
« 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.