![]() ![]() But if I am in that schema and just use Ctrl-T and pick the table and then put on an alias it will not work. ![]() So If I put the schema name followed by the table name and then the alias the alias works as it is supposed to. If I "alter" the session then I have to rerun the alter script again every time I reconnect but if I pick the schema from the Current schema drop-down then I don't have to do the Alter command when I reconnect. It is a pain but they will not change it. Extract the contents of the zip file to a folder, such as C:\instantclient196 There are several ways to go about this next step and it depends on your version of Windows too. (Also at our work if we are inactive for a short time (researching, coding, etc.) they kill our sessions and we have to go back up to Sessions and Test All Connections (Reconnect) to hook back up. The latest version is 19.6.0 and basic light package has all you need to connect to a database and run some queries in about a 40 megabyte zip file. This keeps me from running an Alter Schema command to change my schema. I put the main schema names we use in my "favorites" and then pick the one I want. Then we either alter our schema to the schema we need or we have to put the schema name in front of the table name. In our database we are given our own user_id to log in with. I don't like having to type in the Schema name every time but it works if I do. So I went back in and tried some other options and it worked. ![]() Where mat.NAME in ( 'Appeal Sent Expedited_') I did a F4 (describe) on mat in the Select and I got the dialog box you mentioned "Object mat not found". I tried to use the alias in other areas like within the Select part as below but it did not work there either. I will try to add some screen shots again too. This will take a bit to setup and explain. ![]()
0 Comments
Leave a Reply. |