You are hereOracle


Topics related to Oracle RDBMS Oracle Server


Have you considered the impact of an unnecesary FOR UPDATE on your queries?

El export dump comprimido

¿Has estado en la situacion de mover un archivo dump generado por export y este es demasiado grande o que no dispongas del espacio suficiente para crearlo en el servidor de BD?

The squeezed dump

Sometimes you'll try to move data from one DB to another, or just between platforms. If you use the old export/import duo there are some workarounds to split big dump files in smaller pieces... but ¿what if, even with smaller pieces my file is unmanageable?

There is a workaround when working with Unix and Linux platforms: pipes and IO redirection.

These simple scripts would allow you to compress and decompress dump files 'on the fly'

Recover that lost space

Do you know what happens when you issue a DELETE? Have you wondered what happen after COMMIT? ... well, I might say that there is life after delete for all those blocks that belonged to the data recently deleted.

I'll present the following test case to show you how this works:


Syndicate content

Follow DatabasesLA on Twitter

Who's online

There are currently 0 users and 0 guests online.


Locations of visitors to this page

hidden hit counter