2017 Site redesign

After 6 years, Gioorgi.com is in “redesign mode”: site design is evolving!

New Site design will slowly roll out in the next month: stay with us until mid-January for new feature articles.

New shiny WordPress theme is on the go: menu bar and layout will “pop” during the next three weeks.

ObjectsRoot.com domain has been dropped after 16 years: please udate your bookmarks because it is not here to stay….

A new strong oracle expertise area is on the go, like this article shows.

 

 

I am smarter syndrome

Sometimes in University I found bold young guy saying something like:

I will reimplement this in machine language because is faster

I will reimplement this xyz C function by my own

My program crash, I think there is a bug in HP UNIX socket implementation

I will ge rid of this Java Garbage Collector because it is too slow. I will reimplement all the code in my C++ routine.

 

Belive me: your code is doomed. A full list of guys have already done your same code, found a million bugs and corrected it in the tool you want to replace because they are shitty slow, to your eyes.

I feel your pain because I made your same mistake. Keep reading.

Continue reading “I am smarter syndrome”

Oracle Database Sync

Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now.

I will show here a very fast way of comparing different database and auto-generate migration script.

  1. Reverse engineer the source database using Oracle Data Modeler
  2. Now select the right arrow  shown below:
    sync-with-db
  3. Select the destination datasource (more here) when asked.
  4. The compare pane will enable you to compare the databases.
    But the default options will also use schema name to detect different object, so you will not get what you want in every scenario.
    In 50% of my daily job, schema are different, so you must select the options below to fix it:
    Select “Options” and then “Compare options”. Then  de-select “Use schema property” like suggested below:
    magic-option
  5. Push the “Sync new object”. Then push the “DLL Preview” button and inspect the generated database.
  6. Bonus: by default the tool will not include tables to drop. Inspect the two pane ad check the table you want to drop in the left pane.
  7. Refrain launching the script without proper testing. You are migrating your valuable data.