Re: 10g Database Link DBA_DB_LINKS mystery

  • From: "Sinardy Xing" <oracle.rdbms@xxxxxxxxx>
  • To: adar666@xxxxxxxxxxxx
  • Date: Tue, 4 Jul 2006 11:15:19 +0800

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@xxxxxxxxxxxx> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l





--
regards,

Sinardy

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2006