Looking for an Oracle User Group home in Atlanta? I want to re-introduce everyone to the Georgia Oracle Users Group (GaOUG). For over 20 years, this group has been laser focused on supporting the DBA community in the metro Atlanta area by hosting monthly educational meetings where individuals, both members and non-members presented on topics of …
Category: dbcapoeira
SQL Developer Database Copy: I Really Like This Tool!
SQL Developer Database Copy Recently, my team has been involved in a pretty detailed migration from a Development Instance to our QA instance prior to a final promotion to Production. In the past, some of the team members were moving PL/SQL packages between instances by doing this: Opening them up Copying to the clipboard Open …
Installing SQL Dev 4.0 (JRE 1.6 and JDK 1.7)
I’m in an environment where our 11i version of EBS (I know we need to upgrade) still requires JRE 1.6 to open Oracle Forms. Being an SQL Developer fan (listen to my podcast here), I decided to download and install SQL Dev 4.0. Anyone that’s been following this knows that the latest release requires JDK …
Virtual Columns, Table Export, and Forums: A Love Hate Relationship (SQL Error: ORA-54013: INSERT operation disallowed on virtual columns)
Ok, so kind of a weird title, but let me explain. I believe that when you post to a forum, you are either seeking knowledge or sharing it. I was on the SQLDev forum a few days ago, and someone posted what can be perceived as an error when exporting a table. Here is what …
Can I run SQL Scripts via HTTP?
I saw this question via Twitter not to long ago, and then it came up again in a brief conversation with +Bobby Curtis, and it was about running SQL scripts over HTTP. So if you are interested, here is a quick post on how to do just that. Say you have a ton of extremely useful scripts …
Oracle Open World 2013 – Wrap up (#OOW13)
So if you know anything about me, you will know that I am always amp’d up when it’s time for Oracle Open World. This year was quite a different experience for me. In previous years, I found myself running all across the Conference Complex attending session after session. This year however, I took a different …
Story by a non-DBA: Database Migration with SQLDev EA1 v4.0
It’s been a while, but this 20 minutes turned 8 hour project was a lot of fun. It just kept getting better and better. Today boy and girls, I’m gonna take you through my process of migrating a MSSQL database to Oracle. Let get stated. So, before we had Oracle EBS 11i (2008), there was …
