What a weekend!! Fresh from two intense days in Hollywood, planning your Kscope15 Conference. If you follow any of your Conference Planning Committee members on Facebook or Twitter, I am sure you saw images of us with picturesque backdrops, comments about how good the food was, etc. I can definitely say it was fun. I’m …
Category: Oracle
East Coast Oracle Users Conference 2014 Wrap Up (#ECO2014)
It’s Friday, and I have just returned from the East Coast Oracle Users Conference. I must say that this regional conference comes packed with content. There were approximately 60 sessions over the two days, and at least 15 presenters were Oracle ACE Associates, ACEs, or ACE Directors. Tuesday’s Keynote session led by Kerry Osborne of Enkitec …
Data Security with VPD in Oracle EBS
Enhance data security by using VPD and EBS Profile Options to prevent viewing of sensitive data. In this example we will look at blocking employee SSN or National Identifier, as they are called in EBS, in PER_ALL_PEOPLE_F . As most people familiar with Oracle EBS know, there are a number of delivered views that have embedded security. Take …
Oracle ACE: What’s In It for Me?
Earlier this year I was honored by being awarded the Oracle ACE Associate designation. After almost a year, I continue to get similar questions from coworkers, friends, and members of the public and private sector. “What’s do you get for being an ACE?” My response is simple. I get recognized by the community for doing …
Oracle Open World 2014 in Review
Oracle Open World 2014 in Review Oracle Open World was such a blur. This conference completely shuts down a section of San Francisco to the residents as 60,000+ attendees descend upon the Moscone Center. The logistics and planning behind this event are phenomenal. Hey Oracle, can you offer a behind the scenes pass next year? …
I Am Running for The ODTUG Board of Directors
It’s official! I have thrown my hat into the ring. I am running for a seat on the ODTUG Board of Directors. Why am I doing this? You need only read my post to understand. ODTUG has had the greatest impact on my Oracle professional career, and it is important that I find ways to give back. But why …
Oracle OpenWorld 2014: DBAonTap
Oracle OpenWorld 2014 is a few short weeks away. After about 4 years of attending Open World, this year, I’ll be doing 2 sessions. Get you run on Sunday at the Golden Gate then hit the Sunday Symposiums. I’ll talking about Regular Expressions 101 (UGF9128). For the brave at heart, or the stoopid, I’m not sure …
Migrate Your SQL Developer User Defined Reports
On Tap for Today: Migrating SQL Developer User Defined Reports. I’m in the process of upgrading my work computer and in an effort to make sure it is configured the way I want it, I decided to forego the automated “side-by-side” migration. Everything was going well until I got around to SQL Developer. The install …
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 …
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 …
