Create table creates table in SYS, not connected schema


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

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

Assistance would be much appreciated.

Thank you.


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 ?


Thank you for taking the time to respond.

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

Thanks again.

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: