Data Modeler Tip: Assigning a SCHEMA to Your Objects

thatjeffsmith SQL Developer 0 Comments

Was helping someone on Stackoverflow this morning, and thought you might enjoy seeing this process as well. PROBLEM: You’ve created a schema script, you’ve generated the DDL, and you ran it on your brand-spankin’ new database. Except. Except, you ran that script as SYS, and your schema scripts didn’t have a SCHEMA defined. So you’ve corrupted your SYS schema!!! How …

Demonstrating Oracle SQL Developer Web: the Data Modeler

thatjeffsmith SQL Developer 2 Comments

In this 10 minute video, you get: super quick recap of the Worksheet building a new diagram moving stuff around, changing the colors generating DDL generating a data dictionary report saving and searching diagrams This was my 50th post on YouTube. If you like what you see, be sure to subscribe there so you don’t miss any updates. Your subscriptions …

Generating a Data Dictionary Report and Diagram for a SubView

thatjeffsmith SQL Developer 5 Comments

Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on the main File menu. First, we don’t want the main diagram in the report, that’ll …