Oracle Link Server

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Frank Zhu SSC Veteran Points: 234 More actions · Answer 1

select * from <linked oracle server name>..SYS.DBA_TAB_COLUMNS where table_name = <your table name>;

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 2

What if the oracle login does not have permissions to view this system table? Is there another way?

Frank Zhu SSC Veteran Points: 234 More actions · Answer 3

select * from <linked oracle server name>..SYS.ALL_TAB_COLUMNS where table_name = <your table name>;

It will give you columns of all tables you have access.

Frank Zhu SSC Veteran Points: 234 More actions · Answer 4

SSC Veteran

Points: 234

June 1, 2004 at 11:47 am

I meant all tables the oracle login has access.

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 5

Awesome, thanks (this'll save me a few hours waiting for the information from thr Oracle DBA)