Devart Forums

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

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

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

We'll also take this suggestion into account.