Rogerio Antonio

Versao Portuguesa In this post i'm sharing how to unlock database accounts  - even when the password is not known.

Versao Portuguesa When we work with VMs we need to make files available eg. software binaries, it has a few ways to do that, this post is about how to make share Windows (Host) folders in a Linux server (Guest).

Versao Portuguesa Have been thinking for awile to post about Data Guard,  more specifically about  to created a physical standby.  So, today is the day, the aim of this post is not to destille  Data Guard, for better undestanding lets recap some Data Guard concepts. Data Guard allows database replication sending  and applying redo log info from a site to another, keeping in that way the data replicated and available  in the case the main site is not available.

EnglishVersion Neste post parilho como copiar dados entre bases de dados em diferentes plataformas. Como nao tenho uma maquina HP-UX .. vou ter que criar datafile para HP-UX, e depois o inverso

Versao Portuguesa In this post i'm sharing how to copy data /tablespaces between databases in different platforms as I've no HP-UX here at home .. I will have to convert a tablespace to HP-UX, then to convert the datafile back to Linux

EnglishVersion A Oracle disponibiliza uma forma interessante de copiar aplicacoes / dados entre as bases de dados, chama-se TTS ( Transportable Tablespace). Basicamente exporta-se um dump com metadata do tablespace. Com esse dump + data file (s) e possivel carregar os dados noutra base de dados.

EnglishVersion Oracle allows a nice way to copy aplication / data between databases, is known as TTS ( Transportable Tablespace). Basically is to export a dump with tablespace's metadata and copy the datafile(s). With that dump + data file (s) associated to the tablespace is possible to attach the tablespace to another database.