Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

database link

Status
Not open for further replies.
Ravala

Ravala

Programmer
Jan 28, 2004
88
US
We have two databases, dev and prod.
I created publik link on dev, COM_PROD.
Still when i use desc myTable@COM_PROD, it gives description of myTable on development server.
What could be wrong?

Thanks.
 
Sort by date Sort by votes
Does the user doing the describe have a private database link with a different set up. Have a look in sys.dba_db_links and see if the user names/passwords and connect strings are set up correctly.
 
Upvote 0 Downvote
in dba_db_links:
OWNER DB_LINK USERNAME HOST CREATED
PUBLIC COM_PROD prod 11-OCT-04

 
Upvote 0 Downvote
1. Are you sure the table on production is different than the one on development?

2. I assume the production myTable is not really a view based on the development table? I know, it sounds ridiculous, but let's exclude it right away!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hipath4k
  • Locked
  • Question
Share link to download Orcale 10 G
Replies
0
Views
152
hipath4k
hipath4k
Aung Thurein Tun
  • Locked
  • Question
opera_mail.AuthenticateCredential error ORA-20001 in Oracle Database
Replies
0
Views
254
Aung Thurein Tun
Aung Thurein Tun
BJoy
  • Locked
  • Question
Bulk insert from C# into Oracle Database
Replies
4
Views
333
karluk
karluk
billo102
  • Locked
  • Question
stats collection on DG affects standby database
Replies
0
Views
176
billo102
billo102
tekpr00
  • Locked
  • Question
Database Capacity Trend
Replies
0
Views
95
tekpr00
tekpr00

Part and Inventory Search

Sponsor

Back
Top