Windows 7 and schema setting

Toad for Oracle
1

I just upgraded to Windows 7 and have Toad 10.6. All seems fine except I’m
getting a User doesn’t exist and table doesn’t exist when logged into 2 of my
instances (Test and Production). If I toggle the schema default from APPS to
something else, like INV run a quick query, then switch back to APPS it then
starts working. Sometimes it takes several toggles. In my Dev instance I log in
as Apps, in the others I have to log in with my account, then switch the schema
to APPS.

thanks,

Tom

2

sounds like the default schema is set to something that doesn’t exist.

After you log in, go to Options -> Oracle -> General and you can clear it there.

3

Oh, sorry, my last reply doesn’t make much sense when I re-read yours.

Try going to Database -> Spool SQL -> Spool to Screen. That’ll make
all of Toad’s queries show up on screen. That should make it pretty easy
to see what’s going wrong…