Return
-
Title
Typing Select * from SchemaName. in the editor does not return all the objects -
Description
Typing Select * from SchemaName. in the editor does not return all the objects. It only returns a table with its columns.
This is happening only in one Toad installation and for one schema.
-
Resolution
RESOLUTION 1
1. View | Toad options | Editor | Behavior | auto Replace option
2. If there is an Alias for that particular schema, please remove it
RESOLUTION 2
1. Close Toad
2. Go to your User Files folder (C:\Users\<UserName>\AppData\Roaming\Quest Software\Toad for Oracle\12.1\User Files\)
3. Open the file ALIASES.txt and check if there is an entry for the schema with the problem. The line to remove should be similar at the one below:
SchemaName = SchemaName.xxxxxxRESOLUTION 3
Please upgrade to the latest version of Toad if using an unsupported version.
The installer can be downloaded from the link below:
https://support.quest.com//toad-for-oracle/download-new-releases