Comparing files to be used by an Oracle External tables using Python3

Since I started to work using Python to automate some tasks on my Since I started working with Python to automate some tasks in my environment. I also started to think about what I can get from it. Python is powerful and there are a lot to be explorered from it and I am a DBA person and I am slowly getting to know this programming language. I started to create some scripts for fun and that is the topic of this post . Remember that on this blog you…

#9 DIÁRIO DE UM DBA – PG.ConfBrasil 2020 – Online

Fala pessoa! Hoje, dia 04 de Junho, se inicia o PG.ConfBrasil 2020, o maior evento da América latina para banco de dados PostGreSQL . Devido ao momento vivido atualmente a edição atual será online e contará como sempre com um excelente time de palestrantes, como por exemplo Fabio Telles, consultante da prestigiada Timbira, Bruce Momjian e outros feras . O evento é gratuito e você poderá ficar por dentro das paletras na página oficial do evento: https://www.pgconf.com.br/2020/. Não fique de fora dessa! brunorsHi! I am Bruno, a Brazilian born and…

Connecting to Oracle Database using cx_Oracle module 7 for Python

In this post I will simply show how to connect to an Oracle database using Python 3 in an Oracle Linux 7.6 OS. One of the things that you have to do is to install Python in your OS. By default, Oracle Linux 7.6 comes with Python 7.6 but from 7.7 ownwards it comes with the version Python 3. If you wish to install the Python 3 in your system I do recommend you to take a look at one of my blog posts about this topic: “Installing Python 3…

Installing Python 3 on Oracle Linux 7.6

There are several ways to install python 3 on Oracle Linux 7 systems. You can either perform an installation using an EPEL (Extra Packages for Enterprise Linux) repository or the Software Collection Library (SCL) which requires that you perform other types of commands. However, on this post I am going to install from the the Oracle Linux 7 latest repository which is also another method besides the two previously mentioned. Also the OS will be an Oracle Linux 7.6 that comes installed by default, the version 2.7 of Python is…

Oracle 12cR1: Moving tablespace by using the transportable tablespace feature from a Solaris Operating System (x86-64) to a Linux x86 64-bit system

This post will be about Cross-platform transportable tablespace. Cross-platform transportable tablespace is a technique where you can copy a tablespace from a database running in one platform to another platform. Also Cross-platform transportable tablespace isn’t the same as Cross-platform transportable database. In this instance the whole database is copied including the SYSTEM tablespace. In this post we are going to copy a tablespace from one database to another database. Then the first thing you have to know is the internal names for each platform that supports cross-platform data transport and…

Join the OraWORLD magazine! It’s free!

I have added to my blog a banner about the OraWorld magazine. This magazine is free and technical about Oracle contents. To get this magazine you only have to go through this link http://www.oraworld.org/home/, click on the “Subscribe to Newsletter” tab and fill in your information like e-mail, name, last name, user group (if you a part of one), accept all terms and then submit your subscription. Once this is done, you will receive an e-mail in your e-mail box. If you don’t find the e-mail from the magazine, take…

#8 DIÁRIO DE UM DBA – GUORS: I Encontro de Usuários Oracle do RS 2020

Faz exatamente 1 ano e 6 dias desde que eu escrevi o meu últigo post sobre essa série que eu criei no meu blog para escrever em português e escrever sobre eventos e notícías do universo Oracle no Brasil. Pois é meus amigos… 1 ano e 6 dias mas isso não quer dizer que o blog ficou parado não. Desde então, teve vários outros posts mas na língua inglesa e não sobre esta série. Por isso, me desculpem ! 🙂 Voltamos com tudo e agora para falar do evento GUORS:…

Digging the STAR_TRANSFORMATION_ENABLED parameter on Oracle database 12cR1 inside a PDB

When you think of a parameter that can help you out with star queries, this parameter is the STAR_TRANSFORMATION_ENABLED. According to the Oracle official documentation, it is described as the difference between a typical query and a star query, “A typical query in the access layer is a bond between the fact table and some number of dimension tables and is often referred to as a star query. In a star query, each dimension table is joined to the fact table using a primary key to foreign key join. Normally…

Taking an Oracle exam in unusual times – Nothing like a day (or months) like the other – Oracle Autonomous Database Cloud 2019 Specialist 1Z0- 931

My interest in the Oracle Autonomous Database Cloud 2019 certification started in September 2019 when I took this exam while attending the OOW19 (Oracle Open World 2019) at San Francisco, California, USA. Back then I failed the exam for many reasons, lack of studying (what matters a lot), pressure and so on but I am not here to make excuses because it would not change the results. So since then, I was involved in more projects where I could not only work with Oracle but also with Amazon Cloud and…

PostgreSQL Archive Log Directory

According to PosgreSQL’s documentation : “Write-Ahead Logging (WAL) is a standard method for ensuring data integrity.”. These files are created in a directory at a local or remote server and if you desire to copy them you have to tape library. However, PostgreSQL database isn’t created with the WAL option enabled and to be able to use it you have to configure some essential parameters in the postgresql.conf file. Therefore , these parameters are: archive_command: Here is the directory that you want your WAL files be stored in. You can…