 | |
How to view other schemas in TOAD's Schema Browser
comp.databases.oracle.tools comp.databases.oracle.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
How to view other schemas in TOAD's Schema Browser -
03-25-2008
, 09:10 AM
#2
| |||
| |||
|
|
Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... |
Shakespeare
#3
| |||
| |||
|
|
Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... |
Shakespeare
#4
| |||
| |||
|
|
Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... |
Shakespeare
#5
| |||
| |||
|
|
Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... |
Shakespeare
#6
| |||
| |||
|
|
Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... |
Shakespeare
#7
| |||
| |||
|
|
Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... |
Shakespeare
#8
| |||
| |||
|
|
Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... |
Shakespeare
#9
| |||
| |||
|
|
"Ubiquitous" <weberm (AT) polaris (DOT) net> schreef: Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... Maybe by creating synonyms for the "linked" tables. |
the instance appears in the drop-down on the Schema Browser.
#10
| |||
| |||
|
|
"Ubiquitous" <weberm (AT) polaris (DOT) net> schreef: Production instance PROD is linked to another, PROD2, via a datalink. If I wish to view data in PROD2 I currently have to do it the hard way and use the SQL Editor window. Is there a way one can view tables in PROD2 using the TOAD's Schema Browser while logged in as PROD? I hope that makes sense... Maybe by creating synonyms for the "linked" tables. |
the instance appears in the drop-down on the Schema Browser.
|
« 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.