# Create table creates table in SYS, not connected schema

**URL:** <https://forums.toadworld.com/t/create-table-creates-table-in-sys-not-connected-schema/40652>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 28, 2018, 5:28pm UTC](https://forums.toadworld.com/t/create-table-creates-table-in-sys-not-connected-schema/40652 "2018-02-28T17:28:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![charlyw\_281](https://avatars.discourse-cdn.com/v4/letter/c/439d5e/32.png) [@charlyw\_281](https://forums.toadworld.com/u/charlyw_281)\
**Post date:** [February 28, 2018, 5:28pm UTC](https://forums.toadworld.com/t/create-table-creates-table-in-sys-not-connected-schema/40652/1 "2018-02-28T17:28:49Z")

</div>

Hello,

The title say it all. I feel as if I am missing something basic. I am using 12.12.0.39.

I create a table through SQL+ and it created it in the correct schema.

Assistance would be much appreciated.

Thank you.

C

---

<div class="post-metadata">

**Author:** ![niel.maartens](https://avatars.discourse-cdn.com/v4/letter/n/977dab/32.png) [@niel.maartens](https://forums.toadworld.com/u/niel.maartens)\
**Post date:** [February 28, 2018, 5:52pm UTC](https://forums.toadworld.com/t/create-table-creates-table-in-sys-not-connected-schema/40652/2 "2018-02-28T17:52:07Z")

</div>

I don’t have access to a suitable environment to test this now… but what I think is happening is.

1. Your target/connected schema has DBA rights
2. When you connected in TOAD you had ‘connect as SYSDBA’ selected  
Please change your connection to ‘Normal’ and try again ?

---

<div class="post-metadata">

**Author:** ![charlyw\_281](https://avatars.discourse-cdn.com/v4/letter/c/439d5e/32.png) [@charlyw\_281](https://forums.toadworld.com/u/charlyw_281)\
**Post date:** [February 28, 2018, 7:25pm UTC](https://forums.toadworld.com/t/create-table-creates-table-in-sys-not-connected-schema/40652/3 "2018-02-28T19:25:41Z")

</div>

niel.maartens,

Thank you for taking the time to respond.

The answer is so obvious I feel embarrassed. Problem solved.

Thanks again.

---

<div class="post-metadata">

**Author:** ![niel.maartens](https://avatars.discourse-cdn.com/v4/letter/n/977dab/32.png) [@niel.maartens](https://forums.toadworld.com/u/niel.maartens)\
**Post date:** [February 28, 2018, 7:42pm UTC](https://forums.toadworld.com/t/create-table-creates-table-in-sys-not-connected-schema/40652/4 "2018-02-28T19:42:21Z")

</div>

Glad I could help…

It is one of those things you’ll do once… spend hours on trying to fix… and will never do again 🙂

Ask me how I know ! 😃