I’ve also gone to the System Privs page and assigned CONNECT and RESOURCE for my user so they can actually connect and own stuff. Then expand that, and go to ‘Users’, and create a new one. In your relational design, expand tree item for Physical Models, and create one. I’ve Already Created My Tables, Now I Need to Assign a Schema for Them This post is about how to assign a user/schema to your data model so you can AVOID this situation. So you’ve corrupted your SYS schema!!! How to fix that (FLASHBACK!) is a different post.
PROBLEM: You’ve created a schema script, you’ve generated the DDL, and you ran it on your brand-spankin’ new database.Įxcept, you ran that script as SYS, and your schema scripts didn’t have a SCHEMA defined. Was helping someone on Stackoverflow this morning, and thought you might enjoy seeing this process as well.
0 kommentar(er)
