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…
Day: March 14, 2019
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…