Little error about explain plan

Little error about explain plan

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

Postby Alexz » Thu 25 Oct 2007 08:32

In the next build we'll allow to choose the destination schema for new plan table.
Alexz
Devart Team
 
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Postby 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


:)
trak
 
Posts: 6
Joined: Tue 23 Oct 2007 06:50

Postby Alexz » Thu 25 Oct 2007 13:19

We'll also take this suggestion into account.
Alexz
Devart Team
 
Posts: 165
Joined: Wed 10 Aug 2005 08:30


Return to dbForge for Oracle