| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Link Problem
--=====================_1863699==_.ALT
The workaround is to
select * from all_tab_columns where table_name = '<table_name>'
> >You're not doing anything wrong, it's just an > >unfortunate limitation of Net8 that you can't do a > >describe over a dblink to an O7 db. > >--- Ravindra P Channe <ravindra_c_at_mindtree.com> wrote: > > > Hi Oracle Gurus, > > > > > > I have recently started learning DBA skills. All the > > > day I just go thru this > > > list to pick up as much as I can. It would be nice > > > if my problem is solved, > > > which might be very simple, but as I m still in > > > learning phase I might not > > > have gone thru the complete information about it. > > > > > > I have created a Database link 'link1' in user > > > schema 'user1' on Oracle > > > 8.1.5 to connect another database on Oracle 7.3.3. > > > Using the link I can do > > > 'select * from table1_at_link1' operation, but when I > > > try to describe the same > > > table using 'desc table1_at_link1' it gives me an error > > > 'ORA-12663 : Services > > > required by client not available on the server' > > > > > > Is there any thing which I missed out.... > > > > > > Thanx in advance.... > > > > > > Ravi ============================================================ Kenneth Komoto Email: kgkomoto_at_ucdavis.edu Office of the Registrar Phone: (530)752-7197 University of California Fax : (530)752-0329Davis, Ca 95616
--=====================_1863699==_.ALT
<html>
The workaround is to <br>
select * from all_tab_columns where table_name =
'<table_name>'<br>
<br>
<br>
<blockquote type=cite cite><x-tab> </x-tab>>You're
not doing anything wrong, it's just an<br>
<x-tab> </x-tab>>unfortunate
limitation of Net8 that you can't do a<br>
<x-tab> </x-tab>>describe
over a dblink to an O7 db.<br>
<x-tab> </x-tab>>---
Ravindra P Channe <ravindra_c_at_mindtree.com> wrote:<br>
<x-tab> </x-tab>> >
Hi Oracle Gurus,<br>
<x-tab> </x-tab>>
><br>
<x-tab> </x-tab>> >
I have recently started learning DBA skills. All the<br>
<x-tab> </x-tab>> >
day I just go thru this<br>
<x-tab> </x-tab>> >
list to pick up as much as I can. It would be nice<br>
<x-tab> </x-tab>> >
if my problem is solved,<br>
<x-tab> </x-tab>> >
which might be very simple, but as I m still in<br>
<x-tab> </x-tab>> >
learning phase I might not<br>
<x-tab> </x-tab>> >
have gone thru the complete information about it.<br>
<x-tab> </x-tab>>
><br>
<x-tab> </x-tab>> >
I have created a Database link 'link1' in user<br>
<x-tab> </x-tab>> >
schema 'user1' on Oracle<br>
<x-tab> </x-tab>> >
8.1.5 to connect another database on Oracle 7.3.3.<br>
<x-tab> </x-tab>> >
Using the link I can do<br>
<x-tab> </x-tab>> >
'select * from table1_at_link1' operation, but when I<br>
<x-tab> </x-tab>> >
try to describe the same<br>
<x-tab> </x-tab>> >
table using 'desc table1_at_link1' it gives me an error<br>
<x-tab> </x-tab>> >
'ORA-12663 : Services<br>
<x-tab> </x-tab>> >
required by client not available on the server'<br>
<x-tab> </x-tab>>
><br>
<x-tab> </x-tab>> >
Is there any thing which I missed out....<br>
<x-tab> </x-tab>>
><br>
<x-tab> </x-tab>> >
Thanx in advance....<br>
<x-tab> </x-tab>>
><br>
<x-tab> </x-tab>> >
Ravi</blockquote><br>
<div>============================================================</div>
<div>Kenneth
Komoto<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>Email:
kgkomoto_at_ucdavis.edu</div>
<div>Office of the Registrar<x-tab> </x-tab>Phone:
(530)752-7197</div>
<div>University of
California<x-tab> </x-tab>Fax
Received on Wed Jul 05 2000 - 11:35:44 CDT
 |
 |