Browsing: Announce

Amis specific and general announcements

3 With double quotes (almost) everything goes…

After you have read the blog posts the websites of Sergio Leunissen, Eddie Awad or the “Ask Mr. Ed” website, you may wonder, if that was all you could do with those “magic” double quotes…
Probably not, I know of at least one other neat “trick” you can do with it…

Ever tried the following?

SQL> create user “=:Marco:=” identified by “Username is Invalid”;

You won’t make life easy though, because now you will have to use the double quotes to login as follows:

5 Solving VMware network problems on Linux VMware guests

When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware software if it should update the configuration file. When updating the configuration file, as requested by the software, your once working network settings won’t work anymore.

The following will help you to get on your way resolving these network problems, caused by MAC addresses, which are now out of sync…

0 Oracle 10.2 EE on SUSE 10 ES

I signed up a while ago for the SUSE Cool Solutions mailling list and I saw a very good step-by-step from Michel Bluteau regarding “Installing Oracle 10g R2 Database on SLES 10″. Although it is not yet a supported environment; it is very good post on how to install Oracle on SUSE Linux.

7 And off you go AMIS started 11gR1 Beta 1 testing

AMIS has been proven worthy to test the upcoming release of the 11gR1 database. After entering a lot of data in questionnaires and filling in project plans, AMIS got the approval to enter the test program. Last night I had my first 11gR1 (standard demo install) database installed on RedHat ES 3 and I must say;

It went like a breeze.

5 Mastering XML DB – COUNT and SUM

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 offer – XML, XML Schema, XSLT, Xpath, DTD, DOM, SAX, etc,etc,etc – plus the ones you know from Oracle’s (object) relational (database) world – SQL, PL/SQL, java, OCI, java, etc.

I am currently working for a customer, who implemented the XML DB functionality in a new system. The total amount of XML data is roundabout 200 Gb. The XML data is split-up in 4 tables, 2 tables containing an XMLType column (XML Schema based, CLOB storage) and 2 XMLType tables (XML Schema based, Object Relational storage).

Some XML documents are more than 200 pages printed data and fairly complex in their structure , sometimes as big as 3 to 4 Mb. So it’s a real challenge to get the data you want, in a decent time period. Even simple questions like “give me a count of…�? or “summerize the following numbers…�? can be tricky if you are dealing with complextype constructions/elements. Usage of COUNT and SUM can be tricky in an XML environment.

The following will give you more insight in Oracle SQL/XPath solutions and the need for a clear understanding of your XML Schema’s and the solutions presented by the Oracle database.

2 Just before X-mas

On the 7th of December, I, a database administrator, had a seminar from Mr. Chris Date about “Relational Remodeled” (into…

1 KC SDPL planning

In the next 6 to 12 months Knowledge Center Server Development & Programming Languages intends to deal with the themes…