- http://jonathanlewis.wordpress.com/2014/09/19/shrink-tablespace-2/: weist darauf hin, dass es in aktuellen Releases sinnvoll ist, zugehörige Indizes vor einer Move-Operation einer Tabelle als unusable zu markieren, da die Segmente in diesem Fall sofort gelöscht werden (nach der Move-Operation findet diese Löschung ohnehin statt, da die Index-rowid-Referenzen durch die Bewegung der Tabelle unbrauchbar werden). Diese Löschung erlaubt dann die Tabelle "weiter vorn" im (more...)
|Idioms - the bane of ESL speakers?|
Reading Anton's comment on a Friday afternoon got me a little too excited - upon reading it again Tuesday (we had a long weekend) I realised it was tongue in cheek.
So instead I went to Twitter to find what's being said at Oracle Open World about #orclapex. Turns out there will be a third early adopter - (more...)
Businesses all over the world have spent millions and millions building data warehouses and implementing Business Intelligence (BI) without coming anywhere near the promised business benefits.
That is about the change.
And the thing that will change this is interactive, visual analytics on tablets.
Tablets and modern interactive graphics are a match made in heaven. Business users who will reluctantly spend half an hour looking at a BI report will happily spend hours playing around (more...)
My session on "Oracle 12c for Developers" is done.Afterwards someone asks the question:
What happens when you use DBMS_REDACT with a complete row update?My guess was that it would place the redacted data in the column, but I haven't tried it, so here goes:
create table emp
,to_char (abs (dbms_random.random)) credit_card
(object_schema => 'A'
,object_name => 'EMP'
,policy_name => 'Hide Creditcard'
These techniques aim to be useful as well as fun to learn for (more...)
The big annual Oracle event is almost here – starting Sunday 28 Sep with the User Group Sunday followed by four days of presentations in around 50 tracks!
If the agenda seems a bit overwhelming, read the OTech Magazine Special OpenWorld Issue to find some of the highlights and can’t-miss sessions.
My sessions are:
- Mastering Oracle ADF Bindings: Advanced Techniques (UGF3484). Sunday Sep 28 at 10am in Moscone South room 270
- Starting Your Oracle Application (more...)
Apex 5.0 is going to be released in a couple of hoursIt's a long weekend here in Perth, and I have a footy grand final to watch - but no doubt I'll be installing it somewhere soon!
All that being said, apex.oracle.com is still on 4.2.5, so don't hold your breath for too long.
I’ve been setting up a simplified lab environment to let my students learn use in class. This added content will show them how to do reverse engineering with MySQL Workbench.
It’s a complete Fedora image with MySQL and Oracle Database 11g for the course. The uncompressed image is 14GB and the compressed image is 5.3GB. I chose Fedora because it’s the smallest open source image that supports both environments, and Fedora is the closest (more...)
Finally there is a real guide to OpenWorld - (more...)
I’m at Oracle Headquarters for pre-OpenWorld briefings this week, and am seeing many great things (that I’m not allowed to blog about yet
One thing that still puzzles me is that Oracle still don’t get social. They have very nice Social Network features (their product is called Oracle Social Network), but they insist on keeping this inside a walled garden with no integration to the outside world. In this, they are no different from (more...)
With dozens of ADF/Forms/Mobile/Cloud sessions planned for Oracle OpenWorld 2014, choosing which to attend can easily become an overwhelming task. Since I can relate to the chaos that occurs leading up to OOW each year, I thought I would make your lives a little easier by sharing my top ten picks of sessions to attend this year. (And to be frank it took me almost 4 days). Life requires too many decisions as it is, so (more...)
Now finally after a long period of waiting - and looking presentations and reading blogs I was able to do In-Memory databasing on my own. Having sampled some theoretical background how a a pure In-Memory Db works with SAP HANA; my expectations on the Oracle In-Memory Option were high. Also because Oracle promised it would work without code change, out of the box.
The Oracle database is located on Sun Solaris Machine (more...)
Originally posted on Oracle Data Warrior:
I just got this email from Amazon:
Congratulations, your book “UNA LISTA DE VERIFICACIÓN PARA REALIZAR REVISIONES A LOS DISEÑOS DE MODELOS DE DATOS” is live in the Kindle Store and is currently enrolled in KDP Select. It is available for readers to purchase here.
If you are in Mexico, you can get the book here.
If you are in Spain, you can get it here.
Somebody asked how to put PostgreSQL on my Fedora image with Oracle Database 11g and MySQL. It’s fairly simple. You can check for the current download at yum.postgresql.org and then download it like this as the
yum localinstall http://yum.postgresql.org/9.3/fedora/fedora-20-x86_64/pgdg-fedora93-9.3-1.noarch.rpm
You should see the following output when the download is (more...)
Both jQuery and Font Awesome are standard included with APEX5 (still in early adopter). With a little bit of jQuery you can create an animated button that reflects that it is doing something in the background.
For this example I created a button "Text + Icon button". Simply drag and drop this in the Page Designer.
The Icon CSS Class: "fa-play-circle-o"
and the action: "Defined by Dynamic Action"
For the Dynamic Action: it should respond (more...)