Online Table Redefinition
Do you need to change the definition of a table ( add partitions, changes partitions, …. ) but you don’t have the luxury of affording downtime? Don’t you worry about …
Online Table Redefinition Read MoreDBA Basic
Anonymization After PROD To NONPROD Syncing
The most valuable asset nowadays is data. Having said that, every company must protect it at all costs. One way is the protection of a production environment. However, you should …
Anonymization After PROD To NONPROD Syncing Read MoreAuditing
Whenever you work with large databases where multiple users maintain the data inside, you will need a way how to audit the activity inside. Oracle Audit allows you to monitor …
Auditing Read MoreUsers Management
There is no EDW (Enterprise Data Warehouse) system allowing only one user to access and operate with its data 🙂 There as in any other system Oracle will have to …
Users Management Read MorePhysical Storage Structures
Physical storage structures are accessible only by an operating system. In this article, I will familiarize you with how data are stored and retrieved from the operating system (physical) perspective. …
Physical Storage Structures Read MoreLogical Storage Structures
Storage structures take care of the data/information storage. There are two types of storage structures in Oracle; logical and physical. In this article, I will familiarize you with how data …
Logical Storage Structures Read More