Month: July 2014

ACEA, cool stuff, Database, Migration, Oracle, SQLDev

Database Objects Compare: Grants, Types, and Owners

On Tap for Today: I had a chance to have a little fun today browsing these database tables: sys.obj$, sys.objauth$, sys.user$, and table_privilege_map. This last migration, the result of at least two other blogs posts, has forced me to think about how we do object migrations.  It’s one of the few times that we had …

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 …

#odtug, Conferences, KScope14, Oracle, SQL

The Final Note – Kscope14

KScope14 was hosted in Seattle, the City of Music, and what an experience it was.  For six days, Oracle experts and professionals descended upon the City to share with and learn from each other.  We kicked off on Saturday with a Community Service event event with the Nature Consortium.  After being stuck and scratched by …