Sometimes developers need to recover some tables and we as Oracle DBAs are asked to recover them. So in this post I am going to show you how do to that. I will be creating the table named TECHDATABASKET under the SH user using the dba_tables as example and afterwards I am going to use the syntax “FLASHBACK TABLE SH.TECHDATABASKET TO BEFORE DROP;” in order to recover this table. In the meantime, we need to execute a SELECT key on the table dba_recyclebin or simply the usage of the command…
Author: brunors
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
Optimizing star queries
DBMS_XPLAN.DISPLAY ALTER SESSION SET star_transformation_enabled=TEMP_DISABLE; Database Administration -> Database PL/SQL Packages and Types Reference -> 202 DBMS_XPLAN Database Administration -> Oracle Database Reference -> STAR_TRANSFORMATION_ENABLED brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data…
How was the Workshop: Become a Hero with Oracle Autonomous Database in Stockholm, Sweden ( March 6, 2019) ?
Hello, Hello, As I announced a few weeks ago, I confirmed that I will join the Workshop: Become a Hero with Oracle Autonomous Database in Stockholm, Sweden ( March 6, 2019) . Besides the knowledge I gained attending this event I would really like to highlight Jan Tjernberg for his participation in my Youtube video regarding this event. The language spoken is Portuguese but from the minutes 3:22, it is possible to see my interview in English with him. The video is below: I hope everybody likes it and I…
Oracle Code and Oracle ACE program dinner – Rome, Italy 2019
Hello, I am glad to announce that I am going to attend the Oracle Code Rome 2019 and I will join as a guest in the Oracle ACE dinner. The dinner will be on the 03rd of April and the conference on the 04th of April. This will be my first dinner as a guest at the Oracle ACE Program after my award in Hungary. I am excited for this and I hope to see all of you guys in Rome, Italy on the 04th of April. If you have…
Managing partitioned tables
Partition: Range Partition Interval Partition (extension of Range Partition) List Partition Hash Partition Reference Partition Range-Hash Partition (Subpartition) USER_TAB_PARTITIONS USER_SEGMENTS USER_PART_TABLES DBA_TAB_PARTITIONS USER_LOB_PARTITIONS Database VLDB and Partitioning Guide -> 4 Partition Administration https://www.youtube.com/watch?v=VBkpI4Ki49Q – Range Partition https://www.youtube.com/watch?v=0YYXfFcbC-A – List Partition https://www.youtube.com/watch?v=PrjI-aZrNZE – Hash Partitionhttps://www.youtube.com/watch?v=TT7aDwNFzC4 – Reference Partition https://www.youtube.com/watch?v=BESXA-k5EJU – Virtual column brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and…
Workshop: Become a Hero with Oracle Autonomous Database in Stockholm, Sweden ( March 6, 2019)
Hej, I was invited to join in the workshop “Become a Hero with Oracle Autonomous Database” on March 06th at Sheraton Stockholm Hotel (Tegelbacken 6 101 23 Stockholm Sweden ) from March 6, 2019 – 09:00 – 16:30 . Here is the official link to this event: : https://eventreg.oracle.com/profile/web/index.cfm?PKwebID=0x614233abcd Here is the agenda: Besides this, I was selected for an Oracle Cloud promotion in complimentary credits, valid for 30 days where I will be testing the Cloud Platform and Infrastructure services. After this event I’m going to write another post…
Novo portal do GPO – Grupo de Profissionais Oracle
Pessoal, O GPO – Grupo de Profissinais Oracle está com cara nova no ano de 2019. Sérgio Willians que é o administrador do grupo comunicou a notícia há algumas semanas e que está aceitando novos articulistas. Segue o link do portal novo: https://www.profissionaloracle.com.br/swillians/ Segue o link caso você queira se tornar um articulista do grupo: brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in…
#6 DIÁRIO DE UM DBA – Vem aí o DBA BRASIL 4.0
No dia 4 de maio de 2019 , às 8 horas, começa a 4ª edição do evento anual DBA BRASIL 4.0, o maior evento sobre Data Platform do Brasil. Segundo publicado na página oficial do site : https://dbabrasil.net.br/vem-ai-o-dba-brasil-4-0/ “Nesta edição, além das tradicionais palestras, teremos alguns hands-on conduzidos por profissionais renomados do mercado. As inscrições para palestrantes serão abertas em breve!” brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a…
[Oracle 12c]How to remove and add databases from Oracle cluster
Owner:oracle (Oracle software owner) Database: techdb Instances: techdb1, techdb2 Servers/Node: basket-techdb01, basket-techdb02 To remove and later add the cluster Oracle database, follow these steps: It is important to know the previous configuration for a possible backup: Stop the database: Remove the database from cluster configuration: Add the database in the cluster configuration: (For all nodes) Start the database: Check the configuration again : Check the status of the database : brunors*The views expressed here are my own and do not represent those of my employer.* Hello, I’m Bruno — a…
#5 DIÁRIO DE UM DBA – Terças de Dados #39 – Mesa Redonda com os “Fugidos do Brasil
Foi convidado para compartilhar no “Terças de Dados #39 – Mesa Redonda com os “Fugidos do Brasil” um pouco sobre minha experiência anteriormente na Hungria (2 anos) e atualmente na Suécia.O evento contou com vários outros profissionais de outros países como Fernando Simon (Luxemburgo), Marcelo Fernandes (Alemanha), Christian Gebert (Índia), Dennes Torres (Malta), Lucas de Lima (Portugal), Nilton Pinheiro (Portugal) e Bruno Carvalho (Austrália). Agradeço ao Fabio Cotrim pela oportunidade! Aqui está o vídeo: Aqui a divulgação no GPO: brunors*The views expressed here are my own and do not represent…