Database Administration (MOSC)

MOSC Banner

can't delete any sqltuning sets

edited Feb 2, 2010 11:25PM in Database Administration (MOSC) 4 commentsAnswered
Hello,

I've a Linux box with SuSE 10 and Oracle 11.1.0.6 Enterprise Edition
I'm trying to delete some sqltuning sets. But i receive always the message:

<ORA-13757: "SQL Tuning Set" "string" owned by user "string" is active.
Cause: the user attempted to update an active SQL Tuning Set.
Remove all reference to the SQL Tuning Set and retry the operation.>

What can i do? Whats the way  so i can detect all references to this SQL Tuning Set?

Thanks for any hints:-)

with regards

Stefan

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center