Category: dbcapoeira

APEX, DBA, dbaOnTap, dbcapoeira, E-Business Suite, EBS, OBIEE, ODI, Oracle, User Group

Georgia Oracle Users Group – Reboot

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 …

Data Migration, Database Copy, dbaOnTap, dbcapoeira, Oracle, SQLDev

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 …

Database, DBA, dbcapoeira, EBS, Error, Hints and Tip, Hints and Tips, Java, JDK, JRE, SQLDev

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 …

11gR2, Database, dbcapoeira, ORA-54013, Oracle, Rant, SQLDev, Table Export, Vent, Virtual Columns

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 …

12C, BI, conference, Databases, dbcapoeira, EBS, oow13, Oracle, SQLDev, Troubleshooting

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 …

Data Migration, Database Copy, Databases, DBA, dbcapoeira, Migration, MSSQL migration, Oracle, SQL, SQLDev, SQLDev Cart

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 …