Little error about explain plan

trak · Post by **trak** » Thu 25 Oct 2007 07:47

When user connected AS SYSDBA his
current schema come to be SYS.
And when user press a "Explain Plan" button OraDev
try to determine existance of PLAN_TABLE in user schema, but SYS schema.

And OraDev can't find USER.PLAN_TABLE, and try to create PLAN_TABLE in
SYS schema and get failed

Alexz · Post by **Alexz** » Thu 25 Oct 2007 08:32

In the next build we'll allow to choose the destination schema for new plan table.

trak · Post by **trak** » Thu 25 Oct 2007 09:50

Alexz wrote:In the next build we'll allow to choose the destination schema for new plan table.

No-no. I think you didn't catch an idea.

try to:

connect scott/tiger
select user from dual

user
-----
SCOTT

and

connect scott/tiger AS SYSDBA
select user from dual

user
-----
SYS

Alexz · Post by **Alexz** » Thu 25 Oct 2007 13:19

We'll also take this suggestion into account.