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 …

30 SQL Developer Tips in 30 Days, Day 19: Quick and Clean Table Copies

thatjeffsmith SQL Developer 1 Comment

Quick and clean, what’s that? Consider the following: CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=2; I call that ‘quick and dirty,’ and I imagine you have used this technique many, many times. But, I wish it would have grabbed column comments, indexes, maybe even the partitions. Partitioning a table after the fact is pretty much a no-go. …