I think that's still the case, unless 9i changed that.
Ilya
-----Original Message-----
From: Michael A. Chase
To: Jared Still; Linda Xu; [EMAIL PROTECTED]
Sent: 06/05/2001 5:13 AM
Subject: Re: ORA-00942 when query from Dynamic view table
I may be showing my age, but it at least used to be that the synonyms
didn't
exist as public synonyms unless the DBA deliberately created them.
--
Mac :})
** I normally forward private database questions to the DBI mail lists.
**
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Jared Still" <[EMAIL PROTECTED]>
To: "Michael A. Chase" <[EMAIL PROTECTED]>; "Linda Xu"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 20:55
Subject: Re: ORA-00942 when query from Dynamic view table
> If the synonyms are missing, then he has bigger problems
> than a perl script not working, as a number of other problems
> may appear in the database.
>
> On Friday 01 June 2001 17:16, Michael A. Chase wrote:
> > Along with the other problems already mentioned (grants and ""
> > interpolation), you might not have a synonym defined for the view.
The
> > base views are actually in the form V_$% in the SYS schema (e.g.,
> > sys.v_$database).
> >
> > use strict and -w are almost always good ideas.
> >
> > $DBI::errstr always referees to the most recently used DBI handle's
errstr.
> > --
> > Mac :})
> > ** I normally forward private database questions to the DBI mail
lists.
**
> > Give a hobbit a fish and he'll eat fish for a day.
> > Give a hobbit a ring and he'll eat fish for an age.
> > ----- Original Message -----
> > From: "Linda Xu" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, June 01, 2001 14:05
> > Subject: ORA-00942 when query from Dynamic view table
> >
> > > I need to get information from V$ dynamic table from Oracle. But
receive
> >
> > > Orac-00942 error : table or view not exists
> > > I am using system as connect user.
> > >
> > > Here is my code:
> > >
> > > use DBI;
> > >
> > > $dbuser='system/manager';
> > > $dbh=DBI->connect('dbi:Oracle:host=X.X.X.X;sid=X;port=1521',
$dbuser,'')
> > > or die "Cannot connect to database: $DBI::errstr";
> > > $dbh->{RaiseError}=1;
> > >
> > > $locksql=$dbh->prepare ("select to_char(sysdate, 'mm/dd/yy
hh24:mi:ss')
> > > ,s.machine, s.program, l.sid, l.addr,l.kaddr,l.type,
> > > l.id1,l.id2,l.lmode, l.request, l.ctime, l.block
> > > from v$session s, v$lock l where
s.sid=l.sid")
> > > or die "Cannot prepare: ".$dbh->errstr();
> > > $locksql->execute() or die "Cannot execute: ".$locksql->errstr();
> > > @lock = $locksql->fetchrow_array;
> > > print @lock;
> > >
> > >
> > > Does any body know how to query from V$ dynamic table?
