10g Database Link DBA_DB

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

10g Database Link DBA_DB_LINKS mystery

10g Database Link DBA_DB_LINKS mystery

2006-07-03 - By Sinardy Xing

Reply: 1 2 3

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@(protected)> 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 (See ORA-00942.ora-code.com): table or view does not exist
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
regards,

Sinardy

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... 
<div>On 7/4/06, Yechiel
Adar <<a href="mailto:adar666@(protected)">adar666@(protected)</a>>
wrote:
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">Have you searched under the sink? I
connected into <a href="http://10.2.0.1">10.2.0.1</a> 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 (See ORA-00942.ora-code.com): table or view
does not exist >
 > > -- <a href="http://www.freelists.org/webpage/oracle-l"
>http://www.freelists.org/webpage/oracle-l</a> </blockquote></div> -- regards, Sinardy