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…
Month: May 2020
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…