Category: Database

Big Data, Database, Oracle, SQLDev

Big Data Lite VM and SQL Developer v4.1 EA1

As a regular user of #SQLDeveloper, I decided to go ahead and check v4.1 EA1 connectivity to the Oracle Big Data Lite VM.  The good news is that it works.  The better news, is the steps are the same for the SQL Developer 4.0.3, the most recent GA release.  If by chance, you haven’t already …

Database, dbaOnTap, Oracle, SQLDev

It’s Out! #SQLDeveloper v4.1 EA1

Earlier today, I saw a few hints that we might need to check out the SQL Developer Download page.  Finally having a chance to check, yep there is was, the long awaited SQL Dev v4.1 EA1.  Now please be aware that this is and Early Adopter release. This version also requires that you have JDK 8 …

cool stuff, Database, EBS, EBS 11i, Oracle, Security

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 …

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 …

#odtug, BI, cloud, conference, cool stuff, Data Migration, Database, Databases, HCM, HFM, Hints and Tips, Hyperion, Implementation, kscope14, OBIA, OBIEE, Oracle, PLSQL, SQL, technology, virtualization

Let The Games Begin! – #Kscope14

We kicked off KScope 14 with a great Community Service event with the Nature Consortium.  If you saw my tweet earlier, we HANDLED that Himalayan Blackberry.  I’ve got some of that stuff or a very close relative growing in my back yard, so I felt really good pulling that stuff out.  Not to be beat …

ACE, ACEA, BI, BI Publisher, Database, Discoverer, E-Business Suite, EBS, EBS 11i, EBS XML, Oracle Report, Reporting, SQL, SQLDev, technology, XML, XML Publisher

XML/BI Publisher in Oracle EBS – Bye Bye Discoverer

All good things must come to an end.  It has been a long run with plenty of ups and downs.  Getting Discoverer rolled out was one of my first tasks as I embarked upon my +Oracle E-Business Suite journey.  Alas, we are saying our final goodbyes to Discoverer.  This however opens new doors to address our reporting …

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 …

12C, CDB, Containers, Database, Databases, DBA, Hints and Tips, ORA-01033, Oracle, PDB, Pluggable Databases, script, SQL, SQLDev, startup, Startup Script

Use Start-up Script to Modify State of your Pluggable Database to Open Read Write in SQL Developer 4.0 EA3 (ORA-01033)

I’m playing around with Oracle’s SQL Developer 4 EA3 and Database 12c.  Using SQL Dev, I quickly created a Pluggable Database (PDB). I try to open it, and I get this (ORA-01033). Then I remember reading that the Pluggable Databases don’t open automatically when the database services are started.  Well that sucks because now I …

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 …