Login into the Dev Instance with Admin User Go to Tools and Click on Security Console Go to Roles and search for role, Click on Plan Management Role Click on drop down on the left and select Copy Role Select Copy top role and inherited roles Give ...
Read MoreSupplier Calendar – Clipper -Supplier Test Step 1 : Define Exceptions Navigation: Setup and maintenance 🡪 Global Search 🡪 Manage Schedule Exceptions 🡪 Create 🡪 Enter the Required Details and Exception Days 🡪 Save and Close. Step 2 : Define Calend...
Read MoreWhy Do We Need Immutable Tables? In many applications, certain data should never be modified once it is stored. Traditional tables allow UPDATE and DELETE operations, which can accidentally or intentionally change critical records. Immutable table...
Read MoreWhy Oracle Database Vault? In a traditional Oracle database, users with powerful privileges such as SYS or DBA can access sensitive application data. While these privileges are required for database administration, they can also pose security and ...
Read MoreIntroduction: A software image in Oracle Base Database Cloud Service serves as a preconfigured template containing a specific Oracle Database and Grid Infrastructure Release Update. By creating and managing software images, organizations can ensur...
Read MoreIntroduction Partitioning is one of Oracle Database’s most powerful features for managing large tables efficiently. Among the available partitioning methods, Reference Partitioning allows a child table to inherit its partitioning strategy fr...
Read MoreIntroduction While working with Oracle Database 19c in a multitenant environment with Transparent Data Encryption (TDE) enabled, I ran into an issue while adding a datafile to a newly created Pluggable Database (PDB). The operation failed with: OR...
Read MoreIntroduction In modern Oracle database environments, securing sensitive data at rest is a critical requirement. Transparent Data Encryption (TDE) ensures that data stored in tablespaces is automatically encrypted without requiring any application ...
Read More