I just download and installed Oracle Application 10g Release 3 on my linux box. The version released this week is very light! No ldap, no database, well, a light one… Application Server 10g Release 3 x86: 531 MB Included: * Oracle HTTP Server * Oracle Application Server Containers for J2EE (OC4J) * Oracle Enterprise Manager […]
Month: January 2006
Recursive PL/SQL
it will be a good week ! I found an elegant way to solve a query with recursive pl/sql. an user wanted to have DHSGHDADSFDF translated in DHSGAF, that is, duplicated chars removed, order retained. here is my function : create or replace function f(v varchar2) return varchar2 is begin if (v is null) then […]
raptor early adopter release 3.1 is out
raptor product page I have not checked the differences with 3.0 yet, probably bug fixes with “do not save passwords”
raptor early adopter release 3 is out
This is THE release I have been waiting for, a raptor which does NOT save the password on your local PC. Save a password, even encrypted, on you local PC allows every one with physical access to your PC to get access to your productive database, which may be high-secured and with controlled physical access. […]
static expression
Using Static Expressions with Conditional Compilation defines the kind of expression you can use with conditional compilation… I got one question on forums.oracle.com today, an user wanted to use bitand and could not. I wrote my answer but, … , the site is down and eventually my answer did not get accepted. So, to translate […]
difference between EXPLAIN PLAN and SET AUTOTRACE TRACEONLY EXPLAIN
most of the time I use set autot trace exp in order to get the execution plan. It seems more easy than explain plan for [query]; followed by select * from table (dbms_xplan.display);. However, take care, set autotrace traceonly explain does modify the rows if you explain a plan for insert/update/delete. SQL> set autot trace […]
change MAXDATAFILES, MALOGFILES, MAXINSTANCES, MAXLOGMEMBERS without downtime
this is a 10gR2 new feature. It is no longer necessary to recreate the control file to increase those parameters. Actually, you do not have to change them, they change “automatically” Demo SQL> CREATE DATABASE MAXDATAFILES 5 MAXINSTANCES 1 MAXLOGFILES 2 MAXLOGMEMBERS 1 extent management local default tablespace users default temporary tablespace temp undo tablespace […]
security bug revealed
Pete Finnigan just mentioned a bug, which allow any user in any oracle version to get dba privilege Imperva discovers a critical access control bypass in login bug. This is incredible! Well, Pete urged you to apply CPU2006January asap.
select * from test where my_long like ‘%toto%’
A good way to learn is to try to answer user questions. Instead of referencing other posts, I tried today to answer that frequently asked question myself on developpez.com (french forum) SQL> create table test ( my_long long); Table created. SQL> insert into test values (‘hello toto !’); 1 row created. SQL> exec for r […]
new version of raptor
a few improvement described in the readme.txt. One of this is big-tnsfile support. always missing is a way to NOT SAVE the password on the client!
oem grid control 10gR2 on Suse10
Last friday I installed RAC on my Suse10. Today, I installed Grid Control. Of course it is not supported. The packages I neeeded additionaly are db1 and openmotif. It did not work 100%. I finally started the iasconsole (emctl start iasconsole), and within the iasconsole, I restarted the failed elements. I created the repository manually […]
clear screen reports cleared columns, breaks and computes
$ echo clear screen|sqlplus scott/tiger SQL> columns cleared breaks cleared computes cleared but if I quit properly, it does not report that $ echo “clear screen quit”|sqlplus scott/tiger SQL> a good reason to improve the quality of your shell script by quitting at the end 😉
Suse10 10gR2 Laptop RAC
Hi, [EDIT] I did read Dizwell article about Linux 10g Laptop RAC. The article is no longer available [/EDIT] I have just installed RAC 10gR2 on Suse10. The document above guided me thru the steps. Specific Suse10 : – raw devices are configured by editing /etc/raw with values like raw1:loop1 and must be activated with […]