Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SET AUTOTRACE ON -- weird error?

Re: SET AUTOTRACE ON -- weird error?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 4 Jan 2000 07:55:18 +0100
Message-ID: <946969004.16701.0.pluto.d4ee154e@news.demon.nl>


You need to grant the plustrace role to the user who needs to use autotrace, and make sure that user has access to a/the plan_table (which can mean proper privileges and a public synonym)

Hth,

--
Sybrand Bakker, Oracle DBA
john v <johnvue_at_gte.net> wrote in message news:53137sknlairc6far353uca0fihv95jeeg_at_4ax.com...
> Anyone know why I get the following error when trying to enable
> AUTOTRACE?
>
> The PLAN_TABLE does exist so that's not the problem.
>
>
> SQL> set autotrace on
> Error while connecting
> Error enabling STATISTICS report
Received on Tue Jan 04 2000 - 00:55:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US