Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: 10g Database Link DBA_DB_LINKS mystery

White Unicorn

2006-07-03

Replies:

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@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
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.