Posted in General, Oracle on sept 21st, 2008 2 Comments »
Cette année j’ai la chance d’aller a Oracle Open World.
Pour ceux qui ne savent pas, c’est 5 jours avec plein d’informaticiens qui parlent de bases de données. Enfin, surtout d’une, Oracle.
Comme moi je suis la pour travailler, je vais laisser la place a mon compère, TrucTruc.
Posted in Database, Sybase on avr 10th, 2008 No Comments »
One of the main problem of sybase (and other database) is the way it handle disk space. You must create “disk devices”, which can be RAW or file on a filesystem. Then give some space of it to a database, and perhaps create or extend segments.
Of course, this may sound a good way to deal [...]
Posted in Database, Oracle on mar 26th, 2008 No Comments »
So you pay A LOT for your premium Oracle support ?
I won’t spend my time complaining on the Metalink web interface, the one you must use to open a F**King SR (Service Request), where you lost half a day each time.
I won’t complain on the F**King result you get… something nobody can [...]
Posted in Django, Mysql, OS X, Python on fév 15th, 2008 No Comments »
If you installed over your old Tiger or if you are new user, you may have experienced errors when trying to build py-mysql.Py-mysql is a Python module to connect to Mysql.I’m using it to have Django, the Python Web Framework, to connect to Mysql database. This is what I got when trying to install :
# port [...]
Posted in Sybase, UNIX on sept 26th, 2007 No Comments »
Strange, I wasn’t able to find a way to get the database page size in a Sybase (12.x) server.
Digging in sp_helpdb stored procedure gave me some more informations. To do this, or any stored proc, use this SQL command :
USE sybsystemprocs
go
sp_helptext sp_space_segment
go
You will get the stored proc as text.
Finaly, the solution to get [...]