Little error about explain plan

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
trak
Posts: 6
Joined: Tue 23 Oct 2007 06:50

Little error about explain plan

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
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

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
Posts: 6
Joined: Tue 23 Oct 2007 06:50

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
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Thu 25 Oct 2007 13:19

We'll also take this suggestion into account.

Post Reply