Re: on "_system_trig_enabled" parameter setting

###
17:09:42 NVUATDB > select * from dual;

D
-
X

Elapsed: 00:00:00.02
###

17:09:45 NVUATDB > select * from x$dual;

ADDR                   INDX    INST_ID D
---------------- ---------- ---------- -
0000000102E229E0          0          1 X

Elapsed: 00:00:00.01
###
Thank you Very much for the reply.

Bala --

On 3/12/07, Jared Still <jkstill_at_gmail.com> wrote:
>
> What are the results of running these queries?
>
> select * from dual;
>
> select * from x$dual;
>
>
>
> On 3/12/07, Bala < oratips_at_gmail.com> wrote:
> >
> > 1) I am getting ORA-06553: PLS-213: package STANDARD not accessible,
> > temporary workaround i am doing is setting init.ora parameter
> > "_system_trig_enabled=false" and recreate standard package.
> > 2) If i dont do the above , i cant even chanage users password , get the
> > following
> >
> > SQL> alter user test identified by welcome
> > --
> > ERROR at line 1:
> >
> > ORA-00604: error occurred at recursive SQL level 1
> >
> > ORA-01422: exact fetch returns more than requested number of rows
> >
> > ORA-06512: at line 11
> > 3) any insight is very much appreciated. Thanks for your time.
> >
> >
> > Solaris 2.9, Oracle 9.2.0.6
> >
> > Regards,
> >
> > --
> > Bala Rao
> >
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

-- 
Bala Rao

--
http://www.freelists.org/webpage/oracle-l