Toad World® Forums

Create table creates table in SYS, not connected schema


#1

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


#2

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 ?

#3

niel.maartens,

Thank you for taking the time to respond.

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

Thanks again.


#4

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 :slight_smile:

Ask me how I know ! :smiley: