Importing Your Data Dictionary to a new Oracle SQL Developer Data Modeler Design

thatjeffsmith SQL Developer 6 Comments

I’ve shown how to drag and drop database tables from Oracle SQL Developer into a design. But I’ve never done a start-to-finish, blow-by-blow post on how to import your existing database objects into a data model with SQL Developer. So let’s do that now. Warning: Lots of pictures coming up. Want to import from SQL Server (or DB2) instead? Check …

30 SQL Developer Posts in 30 Days, Day 25: Importing Partitioned Tables to a Data Model

thatjeffsmith SQL Developer 0 Comments

We get lots of questions around how to model specific partitioning schemes in Oracle SQL Developer Data Modeler, and we do support all of the different ways to part and subpart your data – but today I want to show you: Where to see the partitions in the model How to bring in everything BUT the partitions Where are my …

Importing Multiple Schemas to a Model in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 22 Comments

Your physical data model might stretch across multiple Oracle schemas. Or maybe you just want a single diagram containing tables, views, etc. spanning more than a single user in the database. The process for importing a data dictionary is the same, regardless if you want to suck in objects from one schema, or many schemas. Let’s take a quick look …