at least we got one record in the world cup 2006. We are the first team in world cup history that got eliminated without receiving one goal
Download of the pre-release version of Suse Linux Entreprise 10 is now available
I just received my Oracle Magazine yesterday. Blair Campbell from Oracle published my interview in the peer-to-peer columns.
Go to otn.oracle.com/oramag
Last month I had an application server seminar I blogged in SOA . Yesterday it was database 10g day.
First we had exactly the same talk about EMEA marketing, vision, partner and blabla for one hour. I did not expect to hear this comparison between Oracle Database and the C: prompt (origin) and fusion and mswin (ultimative achievement)… I almost told him than the C: prompt was not the first think to appear in MSDOS, but the A: prompt, well, if I will say it next time 😉
We heared about partitioning, parallel query, real application cluster, flashback database, undo management, in about 250 powerpoint slides and not a single line of sql in the whole presentation. Well, not willing to blame the teacher, I just felt losing my time listening to this superficial presentation of oracle database.
About the things I found interesting :
– Using the listener as http server. Especially interesting is to use lsnrctl star to start the listener (just joking).
listener.ora HTTP= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=chltlxlsc1) (PORT=8080)) (presentation=http) (session=raw)) $ lsnrctl star http LSNRCTL for Linux: Version 10.2.0.2.0 - Production Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting .../bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.2.0 - Production System parameter file is .../network/admin/listener.ora Log messages written to .../network/log/http.log Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=chltlxlsc1.lcsys.ch) (PORT=8080)) (presentation=http) (session=raw))
than I should be able with the package DBMS_EPG to administer the website
– An Excel plugin : well, if your marketing department is hooked on excel, there is a plugin which enable you some connectivity within your spreadsheet. You can download it on otn for free on BI Spreadsheet Addin. I did not try it yet, but it did look sexy.
– As last month, the pause has been enjoyable. Fine starters, great cat fish, delicious dessert
EXP / IMP has a quite a lot of bugs and limitations.
Today I had a trouble with a function based index first, generating ORA-942 table does not exist on import. I also had an error with AQ.
I have a few invalid objects too :
before exp, on source system (tru64/220.127.116.11)
SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------- 54
after imp, on target system (rh4/10.2.0.2)
SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------- 142240
SQL> @?/rdbms/admin/utlrp SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------- 2699
… better, but still too much !
I probably did hit bug 3169196 too. The workaround is delicious :
<b>manually clean the data dictionary</b>
Well, I am going to drop the destination database and try again…