Data Modeler Tip: Assigning a SCHEMA to Your Objects

thatjeffsmith SQL Developer 2 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 …

Adding Columns to a Table in SQL Developer Data Modeler: Honor Column Order?

thatjeffsmith SQL Developer 0 Comments

I have an employees table. Because it’s 1984, HR has decided we need to know Twitter handles, Facebook pages, and who knows what else. So let’s add it to our table. The dialog by default puts new columns at the bottom of the table. We’ll see why in just a moment. On a side note, we’re not super fond of …

How to Generate Schema DDL Scripts with One File Per Table using SQL Developer

thatjeffsmith SQL Developer 11 Comments

A VERY specific request this morning: I want to generate scripts for all the tables available in schema. I want to generate separate scripts for each table available in schema and each script must contains it’s dependent objects like indexes for that table or if triggers are available the this must include in the script. I am using SQL developer …