Does anybody know if there is a way to tell SQL Optimizer to export it’s
‘alternatives’ to a simple text file?
The reason I ask is because we use ‘authorization is external’ for our
user/schemas and SQL Optimizer does not support that. This effectively makes SQL
Optimizer worthless for me. But, if it could write out all the alternatives to a
script, I could run them that way.
Jeff, I haven’t tried it yet, but would love to get familiar/hang on with it
because I am the Administrator of Toad in the company (we bought 28 Toad Oracle
Xpert licenses, many of developers are new to Toad). I’ll read the Toad quick
guide to learn how to optimize the statement inside of Toad. Thanks for all
info.
yes, that is what I am saying. I believe it tries to create
an additional session which requires a login. It apparently tries to do it
‘under the covers’ but when it finds that it is an EXTERNAL, it raises
an error saying something to the effect that a NULL password is not allowed.
Mike
On Wed, Apr 20, 2011 at 5:22 PM, Jeff Smith wrote:
It runs in a Toad connection...although I haven't tested it myself. Are
you saying it doesn't work for EXTERNAL OS authenticated users?
On Apr 21, 2011, at 6:18 AM, “Michael Moore” wrote:
Jeff,
yes, that is what I am saying. I believe it tries to create an additional
session which requires a login. It apparently tries to do it 'under the
covers' but when it finds that it is an EXTERNAL, it raises an error saying
something to the effect that a NULL password is not allowed.
Mike
On Wed, Apr 20, 2011 at 5:22 PM, Jeff Smith wrote:
It runs in a Toad connection…although I haven’t tested it myself. Are
you saying it doesn’t work for EXTERNAL OS authenticated users?