# Set Default Schema

**URL:** <https://forums.toadworld.com/t/set-default-schema/40150>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 25, 2017, 1:01pm UTC](https://forums.toadworld.com/t/set-default-schema/40150 "2017-10-25T13:01:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ravirk](https://avatars.discourse-cdn.com/v4/letter/r/b487fb/32.png) [@ravirk](https://forums.toadworld.com/u/ravirk)\
**Post date:** [October 25, 2017, 1:01pm UTC](https://forums.toadworld.com/t/set-default-schema/40150/1 "2017-10-25T13:01:36Z")

</div>

Does someone know how to set a default schema when I login using Toad for Oracle 12.12. I tried the following but seems like its not working.

Thanks-

Rajbir.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [October 25, 2017, 1:04pm UTC](https://forums.toadworld.com/t/set-default-schema/40150/2 "2017-10-25T13:04:25Z")

</div>

Go to any schema dropdown in Toad.

Choose the schema that you want for defailt.

Right-click on the dropdown, then choose “Set as Default Schema”

---

<div class="post-metadata">

**Author:** ![robert.prior](https://avatars.discourse-cdn.com/v4/letter/r/c6cbf5/32.png) [@robert.prior](https://forums.toadworld.com/u/robert.prior)\
**Post date:** [November 9, 2017, 8:05am UTC](https://forums.toadworld.com/t/set-default-schema/40150/3 "2017-11-09T08:05:38Z")

</div>

This seems to be a problem for me as well.

The Schema Browser window will default to my default schema, but the Editor window doesn’t seem to keep the value.

Also when I right click the schema dropdown on the Editor window it asks me again to clear the default of my username instead of the default schema I chose before.

---

<div class="post-metadata">

**Author:** ![gregg.barr](https://avatars.discourse-cdn.com/v4/letter/g/a88e57/32.png) [@gregg.barr](https://forums.toadworld.com/u/gregg.barr)\
**Post date:** [April 16, 2018, 8:29am UTC](https://forums.toadworld.com/t/set-default-schema/40150/4 "2018-04-16T08:29:39Z")

</div>

I am also having issues with the default schema. Sometime in the past few releases this behavior has changed.

In the past going to View, Toad Options, Oracle, General and then setting the Default schema for connection to \<tns\_name\_entry\> or @\<tns\_name\_entry and setting the user the editor window would pick this up and use it for a query without needing to select the schema from the schema dropdown. Now anytime an editor is opened for the connection, I have to select the default schema from the drop down. This defeats the purpose of setting the default schema in the Oracle, General settings. Does anyone else have this issue in Toad for Oracle 12.12.0.39?