Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [07-2006 Date Index] [Date Next] || [Thread Prev] [07-2006 Thread Index] [Thread Next]

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





--
regards,

Sinardy




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.