Oracle Warehouse Builder suddenly stops working?
![Oracle Warehouse Builder suddenly stops working?]({"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"} "Oracle Warehouse Builder suddenly stops working?")
Did you recently try to start your OWB client and found that it suddenly did not want to start? Well you’re not the only one. All OWB users around …
Category: Database
Feuerstein is coming to Amsterdam
On september 8, 2005 Quest Software will organize a training seminar in Amsterdam by Steven Feuerstein. It will cover two topics: 1. Correcting PL/SQL Worst Practices and 2. Survey …
Running UltraSearch
Oracle UltraSearch is a web-based search application based on Oracle Text. It can be used to index a wide variety of datasources like websites, databases, files etc. and to …
Oracle High Availability Concepts
Audience: DBA’s, infrastructure architects. A brief explanation of the Oracle Dataguard and High Availability concepts.
Oracle text
The Dutch Oracle Usergroup (OgH) organized a session about (text) searching capabilities of Oracle technology. The presentation was done by Wouter van de Weghe of Oracle and consisted of …
Oracle Enterprise Manager
With Oracle 10g (release 1) the enterprise manager is only available as a web-based application. However, it doesn’t provide all the necessary options yet. Among others, the xmldb and …
DB utilities – splitting generated DDL scripts
Have you ever tried to split the DDL scripts generated by Designer? Pretty tough, isn’t it? Well, I have a nice solution for you: the Perl script sql_split.pl splits …
Oracle Database 10g Release 2 available (only on Linux right now)
Oracle just released (or at least I just saw) the availability of the Oracle 10gR2 database, for Linux. I assume that in a few days time we will also …
About nulls in the database
The july/august edition of Oracle Magazine has a very interesting article by Lex de Haan and Jonathan Gennick about Nulls (‘nothing to worry about’) in the database. Although I …
Oracle Database 10g Release 2 – SQL and PL/SQL Features
Arup Nanda writes about new features for the upcoming Oracle 10gR2 release, targeted at the end of June 2005. In this article, he discussues new SQL and PL/SQL features. …
ODTUG Day 3 – Quiz on SQL and PL/SQL
Today Alex and I did our “Oracle Quiz on SQL and PL/SQL Quiz – See Water Burning” presentation. We wanted to demonstrate a number of new and old features …
Day One of the ODTUG 2005 Conference – first impressions and my first presentation: 10g Top 3 SQL and PL/SQL
The show is back in town, and so am I. Precisely one year a go, the ODTUG crowd assembled in Scottsdale, Arizona. This year we all flocked to New …
Executing PL/SQL from ANT – how to keep the format straight
Just read the post Executing Oracle PL/SQL from Ant on how to use Ant for executing PL/SQL tasks, such as creating Packages and Stored Procedures. I have used Ant …
TimesTen
Oracle aquired TimesTen. See here for more details. By the way “fusion middleware” is the new name for application server, collaboration suite, etc, technologies.
Using the Distributed Configuration Manager (DCM) command shell…
At first I couldn’t remember this dcm-commands and always had to type them at least twice untill… I learned about the “shell”- subcommand which is part of Oracle iAS’s …
DB utilities – Oracle JPublisher enables you to easily access PL/SQL from Java
The tool JPublisher is a little bit unknown. But it is a very handy tool for accessing PL/SQL stored procedures, packages, functions as well as object, collection or reference …
DB utilities – updating sequences the elegant way
Ever needed to update a sequence so the next value is greater than the maximum value of a table? Well, the quick and dirty ways are select SEQ.nextval from …
Mastering XML DB – COUNT and SUM
May 20, 2005
AMIS, Announce / Events, Database, Databases, DBA Oracle, IT, Web HTML5 CSS3, XML
5 Comments
Working for years with Oracle’s relational environment, XML DB is a completely different kind of beast. You’re confronted with all the languages and techniques the XML environment has to …
Old undocumented stuff – Recompiling with timestamp.
Yesterday i was reading nice discussions on Asktom about the dual table. Afterwards somehow a "undocumented" Oracle feature popped into my mind again. Last time I used is at …
XML DB basic demo experience
Introduction Last week I have been investigating the XML DB basic demo at OTN (http://www.oracle.com/technology/tech/xml/xmldb/9.2.0.2.0/index.html, Downloadable Demo). Unfortunately there is also a similar but older demo at http://www.oracle.com/technology/sample_code/tech/xml/xmldb/index.html (Oracle9i …
Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005
This paper presents a compilation of quirky questions, tantalizing puzzles and cheeky challenges that will have you wander among many interesting, useful and often surprising features and functionality, sometimes …
Customizing ORA, JBO and JHS error messages in JDeveloper with ADF
Recently I encountered the problem of overriding error messages in my project created in JDeveloper using ADF/JHeadstart. I wanted to get rid of messages containing codes like JHS-00106 and …
Oracle 10g's Finest – The Top 3 SQL and PL/SQL Features new in 10g – paper for ODTUG 2005
Papers for the ODTUG 2005 conference are limited to 10 pages. That is not enough. It never is, by the way. This time, I restricted myself to only three …
Right a Wrong in 10g – Undo transactions using FLASHBACK_TRANSACTION_QUERY
Among the topics we discuss in the Oracle 7Up Workshop at AMIS is the Flashback functionality in 9i and 10g databases. We look in depth at Flashback Query and …
Implementing a Business Process in BPEL using Oracle BPEL 10g (beta 3) – GetSalesQuote leverages PL/SQL and WebServices
Oracle BPEL PM is a tool that allows us to design and publish WebServices. The design is done in BPEL, the industry standard for specifying Business Processes. BPEL stands …
Publishing PL/SQL "Services" as WebService using Oracle BPEL
Oracle BPEL Process Manager is a BPEL engine that runs in any J2EE Application Server, though typically Oracle 10gAS (OC4J), JBoss, WebLogic or WebSphere. Oracle BPEL PM publishes business …
Recompiling invalid objects
I recently witnessed a developer recompiling his schema’s INVALID objects by selecting all the invalid objects from the user_objects table and compiling them. This he had to do 3 …
Updateable External Tables
Introduction External tables were first introduced in Oracle 9i. They provide easy access, by means of SQL, to data stored in files on the file system (i.e.: outside the …
Refreshing a ViewObject on view in JHeadstart
Imagine this situation: you have created several tables and a view that queries several columns in these tables. Using BC4J you’d create a ViewObject on the view. The ViewObject …
Eindgebruikers zijn Olifanten – Driedaags seminar ‘Effective Oracle by Design’door Oracle-fenomeen Ask-Tom Kyte (article from Optimize, March 2005)
The March 2005 issue of Optimize, the Dutch Oracle Developer Magazine, contains a review of the Tom Kyte seminar AskTom-Live. This seminar has been discussed in many details on …
Create logging data in the same table
Suppose you want to log every update on a table. You want the log records to be in the same original table. You cannot do this in a simple …
Introducing Materialized Views as mechanism for Business Rule implementation (complex declarative constraints)
Put on the trail by Tom Kyte – and after many useful discussions with my colleague Andre, we will take a look in this article at implementing complex business …
Oracle10g Lite, scratching the surface
Over the last few days I scanned trough documentation about Oracle10g (Oracle 9i) Lite the get a overview of the possibilities. Furthermore I tried to install the product on …
Creating your own advanced search engine for any website – using Oracle Text – Searching the AMIS Technology Weblog
The Oracle 7Up workshop that I teach every few months introduces many Oracle 8i, 9i and some 10g features to experienced SQL and PL/SQL developers with a firm footing …
Declarative Implementation of Mandatory Master-Detail relationship (Order must have Order Lines)
Since at least 1996, I have been involved with specifying and implementing business rules. Whenever possible, business rules are implemented in the database using declarative constraints. Triggers are the …
How to drive your colleagues nuts – dbms_advanced_rewrite (Oracle 10g)
If you really want to have some fun – and have your co-developers start wondering whether they are losing it altogether – you could consider spending a few minutes …
Registering non-default XMLDB HTTP/WebDAV and FTP ports on a non-default Oracle Listener port
Yesterday, I had to install XMLDB on an already very heavy used system. On this UNIX system, an old Oracle IAS is installed, OAS 10g (version 9.0.4) and an …
Migration from MySQL to Oracle – using Oracle Migration Workbench
All statistics on the visits to the posts in the AMIS Technology Weblog are gathered in a MySQL database that sist underneath WordPress. We would like to do some …
Little Gold Nugget: SQL*Plus COPY Command
Although not a “new” command in SQL*Plus, it’s very cool. Recently I had to move some data from one table to another in a different database. The Source table …
Pipelining 10g Database Export and Import
A very interesting feature in the Oracle 10g Data Pump I becase recently aware of is the option to link an Export job in one database to an Import …