Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g Database Link DBA_DB_LINKS mystery
I don't know why but I restart Database I able to query the view..
Strange... Don't tell me Oracle create in on the fly...
On 7/4/06, Yechiel Adar <adar666_at_inter.net.il> wrote:
>
> Have you searched under the sink?
>
> I connected into 10.2.0.1 database with user that is granted DBA rule
> and I can query this view.
> Connected normally or connected as sysdba.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> Sinardy Xing wrote:
>
> >
> > Hi guys,
> >
> > Can you help me with this?
> >
> >
> > SQL> select count(*) from DBA_DB_LINKS;
> > select count(*) from DBA_DB_LINKS
> > *
> > ERROR at line 1:
> > ORA-00942: table or view does not exist
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- regards, Sinardy -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 03 2006 - 22:15:19 CDT
![]() |
![]() |