Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10g Database Link DBA_DB_LINKS mystery

Re: 10g Database Link DBA_DB_LINKS mystery

From: Sinardy Xing <oracle.rdbms_at_gmail.com>
Date: Tue, 4 Jul 2006 11:15:19 +0800
Message-ID: <f52c14170607032015l306ed7bl2ff339dc1f3ee38c@mail.gmail.com>


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-l
Received on Mon Jul 03 2006 - 22:15:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US