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 …

Uncategorized

ORACLENERD: Why I’m voting for Danny Bryant and You Should Too…

This is an awesome display of support.  Thanks for all you do! ORACLENERD: Why I’m voting for Danny Bryant and You Should Too…: I’m talking about the  ODTUG Board of Directors …

Hints and Tip, Hyperion, Implementation, Oracle

Hyperion Implementation is Difficult

You would not believe the number of times I’ve heard that.  Every conference and product demo I went to.  This was a common sentiment.  To be honest, it is, but not impossible.  By following some simple yet important considerations, you can have a successful Hyperion implementation. Define Requirements Why are we doing this and what …

#odtug, board of directors, EPM, kscope, OBIEE 11g, Oracle

Service: ODTUG Board of Directors (#ODTUG) Voting 10/9 – 10/29

Greetings ODTUG Family: I wanted to officially wait until October before putting this out.  A great thing happened at Oracle Open World 2013.  I was nominated for the Board of Directors of ODTUG.  This is a great chance to serve, and I am humbled yet excited about the opportunity, therefore I am asking for your …

dbcapoeira, SQL via HTTP, SQLDev

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 …

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 …

oow13, Open World, Oracle

Oracle Open World 2013 Day One (Saturday)

Been so inspired by all the new connections and reconnections.  Great to meet you Yuri (sp), Vanessa, Dan and others.  Good to see you again +ORACLENERD , +Bobby Curtis , +Galo Balda-Andrade , #dbakevlar,  +Tim Gorman , +Kent Graziano , #monty_odtug, +Lauren Prezby , +Crystal Walton   et al.  Today was a good day!  Got into San Francisco in good fashion, and had the opportunity to share …

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 …

Discoverer, EBS, Oracle, Reporting

Discoverer – Complex Folders Part 2

A couple of days late, but here is the how to guide for creating Complex Folders in Discoverer.  This post assumes knowledge of the Discoverer Administrator Tool. First we need to add the desired folders to a Business Area and Join the folders on the appropriate columns: Once you have created the Join, you need …

Uncategorized

Discoverer – Complex Folders Part 1

I’m goofing off in Discoverer.  Yes, it’s an older tool, but it is still in use.  Maybe an article on that later. What was I saying??  Oh yes, Discoverer.  For the longest time, we have been creating Business Areas and adding folders in an effort to “empower” our users.  We have situations where users need …

Related Posts Plugin for WordPress, Blogger...