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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing Oracle public synonyms via linked server

Status
Not open for further replies.
martynh

martynh

Technical User
Joined
Oct 17, 2001
Messages
73
Location
GB
If you look at Public synonyms in an Oracle database via a linked server the schema is null (Public is not a 'real' user in Oracle). Selecting data by not specifying the schema in the 4 part name generates an error (MS Oracle OLE DB Provider), as does specifying the NULL keyword.

Any offers on how you can access, for example, the ALL_TABLES system view?

Regards

Martyn
martyn.hodgson@cdesolutions.com
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question Question
Parameterised sql server query
Replies
8
Views
884
Chriss Miller
C
V
  • Locked
  • Question Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
1K
Volvere
V
Colin Burton
  • Locked
  • Question Question
Determine if a file exists on s different server to the SQL Server
Replies
2
Views
1K
gmmastros
gmmastros
BeatriceC
  • Locked
  • Question Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
370
pjw001
pjw001
ElEye
  • Locked
  • Question Question
Parse XML via SQL query
Replies
1
Views
393
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top