Database management

Stop looking for Oracle Fusion and Oracle Grid Control documentation: use the dbi services firefox add-ons!

After my last post title "Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!" Some of you asked me for firefox search add-ons for Oracle Fusion(…)

Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!

Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are(…)

How to debug a Data Pump error

Recently, I had an Oracle error with Data Pump at a Customer, which was not easy to localize. Here is the error I received during a DBIOWNER schema export with Data Pump: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39125: Worker(…)

DBMS compression: determining a table’s compression ratio

According to the Oracle documentation, the dbms_compression procedure allows to determine the compression ratio for a table without creating it. Let's have a look at it.

Bug while installing Oracle 11.2.0.1 on AIX 6.1 SP2

Last week I encountered the following problem while installing Oracle 11g R2 on AIX 6.1 TL06 SP2. I met all the PreReqs of the installation document, but at the end of the installation process, I got(…)

Getting rid of network acces issues after migrating to Oracle 11.2

Are you experiencing network access issues after a migration to Oracle Database 11g Release 2 (11.2)? If yes, you probably have to allow the concerned PL/SQL packages to access your network again. This posting will show you how.

Génération de XML : le format des dates

Aprés une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour générer des documents xml est en erreur. Le format des dates a changé qu'a fait le DBA ?(…)

Password Oracle : vos mots de passe sont-ils sécurisés ?

Quelles sont les faiblesses de l’encryption des mots de passe Oracle ? Comment est-ce qu’Oracle crée les clés de hachage afin d’en améliorer la sécurité ? C’est ce que je vous propose de découvrir dans ce post. Le mot de(…)

How to connect to an Oracle database using the perl DBI module and DBD::Oracle “as sysdba”?

Well, I have read many posts about this, but was unable to find a suitable solution up to now … Google was not my friend(…)