Re-ordering without procedural code or using a sequence
![Re-ordering without procedural code or using a sequence]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http://seattletimes.nwsource.com/ABPub/2012/08/02/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Re-ordering without procedural code or using a sequence")
Question from one of my customers: “Please help me find an update statement that’s able to re-order a primary key after a delete.. and by the way.. you are …
Category: DBA Oracle
OOW 2012 – And was there news on the XMLDB front…?
Just finished my Birds of a Feather XMLDB panel session in the Marriott Hotel and now looking back on a event full day. It all started of with a …
OOW 2012 – It will be a great Conference…
For me it all started out very stressful. I overslept yesterday, or the day before, and noticed that it already was 08.25 AM. My flight would leave at 09.50, …
Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond
Van 30 september tot 5 oktober is San Francisco weer het domein van tegen de 45.000 deelnemers aan de Oracle Open World en JavaOne conferenties. Ruim 2000 presentaties worden …
Compare tables with the minus operator, even if they contain clobs and/or blobs.
I wanted to compare the content of two tables with identical layout quickly with the minus set operator, but ran into a couple of errors, caused by clob and …
Oracle Enterprise Manager Cloud Control 12.1.0.1 – Agent Installation, Issues and Solutions
Currently busy for a client to install and configure Oracle Enterprise Manager 12c for database and more administration across the globe. These environments were configured and setup by a …
Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)
December 20, 2011
AMIS, Architecture, Big Data, Database, DBA Oracle, Oracle, PL/SQL, XML
7 Comments
People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the …
UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server
Last Thuesday, Mark Drake, Senior Product Manager and I, delivered a good presentation during UKOUG in Birmingham about how to use your database, via XMLDB functionality, as a file …
UKOUG 2011: Using your Database as a Fileserver
UKOUG 2011 is nearby and one of the coolest things in Oracle 11g and onwards is, IMHO, a functionality called XDB Repository Events. Most of you probably know that …
Review: The Method-R Profiler
I was lucky enough to get my hands on the Method-R Profiler and had a test drive with it. So first of all what is it? As you might …
Rman 11gR2 changes tag labeling of the inc backup in incrementally updated backups
In (rman) incrementally updated backups, only incremental backups are done after the first full backup to the Fast Recovery Area. From 11gR2 on the incremental backup pieces will get …
How to switch datafiles to FRA and back again
If you, like me, like to use (rman) incrementally updated backups, a copy of all datafiles will be present in the Fast Recovery Area. That becomes quite handy if …
2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)
October 13, 2011
Announce / Events, Architecture, Big Data, Book reviews and Publications, Cloud, Database, Databases, DBA Oracle, Development Tools, IT, Oracle, Oracle E-Business Suite, PL/SQL, SOA, Software Development, Testing, Tools
No Comments
In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken …
OOW 2011 – Oracle XMLDB and Big Data
Last day of Oracle Open World and I am currently attending the last presentations. The first presentation, “Oracle XMLDB: A noSQL Approach to Managing all your Unstructured Data”, deals …
ODTUG KScope Preview 2011
Ook dit jaar, namelijk op dinsdag 14 Juni, organiseert AMIS de ODTUG Preview. Het jaarlijkse congres van de ODTUG, de Oracle Development Tools Users Group, vind dit jaar plaats …
My First Steps with RAC One Node 11gR2 (11.2.0.2)
I’ve been using RAC (10gR2) for years now and I was wondering how RAC One Node differs from RAC. That’s why I used a few ‘old’ RAC servers that …
DBPITR with a rman archival backup
One of our customers had this request: Can you make a backup of my development database that I can use to restore ( the same database ) to a …
10gR2 RAC service failover and ORA-12545
A few years ago I was lucky to be able to start working for a client that has Oracle RAC clusters. There we encountered lot’s of interesting issues, and …
Being Mr. Ellison…
December 23, 2010
Architecture, Database, DBA Oracle, IT, Oracle, Oracle E-Business Suite, Software Development
2 Comments
Its almost Christmas and the end of this 2010 year and I keep wondering what will happen, Oracle wise, in 2011. I have, had, my idea’s about what might …
Software. Hardware. Complete
A lot is happening here at Oracle Open World, more than my brain can master right now. Exalogic, ZFS storage, Unbreakable Enterprise Linux, Fusion Apps (finally), Oracle VM for …
Call for Papers UKOUG ends on Monday
Be aware that the Call for papers for the UKOUG Tech. Conference in December is closing on Monday. ….and yes I know, having Oracle Open World almost opening its …
Laatste "Plug" – Cuddly Toys Not Included – Een AMIS Query met Doug Burns
June 15, 2010
AMIS, Databases, DBA Oracle, Development Tools, Oracle, Software Development, Tools
2 Comments
Donderdag as. is de AMIS Query van Doug Burns over SQL Tuning, gebruikmakend van de Oracle Enterprise Manager (Tuning en Diagnostics pack). Misschien verwachten velen een hoog “DBA” gehalte, …
I don't like a reclaimable database disk copy
As of Oracle 10g it’s possible to recover (or wind forward) a RMAN disk copy of the database to a specific time in the past. This type of backup …
Aanmelden AMIS Query "An Evening With…": Doug Burns
Op Donderdag 17 juni, vanaf 18:00 uur, zal Oracle Database Expert en Oracle ACE Director Doug Burns(Schotland), een kennisavond vullen met live demo’s op basis van de Oracle Enterprise …
ODTUG Preview: mini conferentie (APEX, Database en SOA)
Voor het vierde achtereenvolgende jaar organiseert AMIS de “ODTUG Preview” sessie op 8 juni 2010 bij AMIS in Nieuwegein. ODTUG Kaleidoscope 2010 is een conferentie voor Oracle ontwikkelaars, dit …
AMIS Query: An Evening with Oracle ACE Director Doug Burns…
On the 18th of June I am very happy to have arranged an internal mini masterclass for my DBA colleagues and some AMIS customer DBA peers. The evening before …
AMIS Query: A (hacking :) event with Oracle ACE Director Pete Finnigan
Zoals al aangekondigd in een eerdere blogpost heeft AMIS in samenwerking met Miracle Benelux, Masterclass trainingen, de mogelijkheid om vlak voor de twee daagse Masterclass in Utrecht van Oracle …
Registrations are open for "An Evening with…"
Just a small update, if you want to join us on the evening with Oracle Database Security Expert: Pete Finnigan, you are now able to register yourself for this …
An Evening with Oracle Database Security Expert: Pete Finnigan
April 10, 2010
AMIS, Architecture, Databases, DBA Oracle, Software Development, Software Engineering
1 Comment
AMIS Technology School is proud to present, in collaboration with Miracle Benelux Masterclasses: An Evening with Oracle Database Security Expert: Pete Finnigan on Tuesday 25th of May, 2010. Miracle …
Oracle VM Single Box Install (Server & Manager/NoVM)
A brother of mine asked me if I could create a database machine and an application server machine during this Easter bank holidays regarding a Demo/Proof Of Concept setup. …
Hotsos 2010 – A Training Day with Tanel Poder
My last day already, so I hereby leave you with some impressions from Tanel’s Training Day. Maybe until next year. If you also want to learn from him, then …
Hotsos 2010 – Presenters, Presentations, Presenting
I never find it very easy to try to capture the atmosphere during a conference, the presenting part, the presentations or the discussions, for example, you could have with …
Part of the Puzzle: Oracle XMLDB NFS Functionality
This story is long overdue and no its NOT about the Oracle Database 11g Database File System (DBFS). Its about an “undocumented” NFS functionality that, maybe someday, will be …
Advert: Oracle XMLDB Masterclass in Germany
Here a small advert for one of my events scheduled for this year. On the 24th of Februari I will be giving a Masterclass regarding Oracle XMLDB in Germany. …
Oracle Open World XMLDB Sessions and Presentations
Its time to enlist. It really is. At least regarding the XMLDB related sessions and presentations during Oracle Open World 2009. As far as I have seen today, the …
Oracle Database 11g Release 2: Flash Cache and Exadata V2
So, if I would wonder what is the purpose of this almost “hidden” feature called flash cache and were this came from (also see my post “Permanent Link to …
Uitnodiging AMIS Query – Technical Introduction of Oracle Database 11g Release 2
(dutch text) Oracle heeft zijn nieuwe database release – 11g Release 2 – begin deze maand vrijgegeven. AMIS heeft als deelnemer aan het beta-traject al geruime tijd met deze …
Oracle Enhances XBRL Reporting Capabilities with UBmatrix, Inc.
June 27, 2009
AMIS, Architecture, Database, DBA Oracle, Development Tools, Oracle, Oracle E-Business Suite, XML
No Comments
Oracle posted a press release about their involvement and commitment for UBMatrix XBRL technologies last Wednesday saying (among others): "To help publicly held companies facilitate the preparation, publishing and …
Enhancing fast queries using "Tapio-Indexes"
During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these …
"Hotsos Revisited", Revisited…
May 19, 2009
AMIS, Book reviews and Publications, Databases, DBA Oracle, IT, Oracle, PL/SQL, Software Development
1 Comment
Lucas already gave a very good in depth overview of the "Hotsos Revisited" session last night. It always amazes me how fast he can make a cool blog post …