Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Alter Oracle Table
Published by :
Obay Salah , November 28, 2024
In Oracle, ALTER TABLE statement specifies how to add, modify, drop or delete columns in a table. It is also used to rename a table.How to add column... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Create Oracle Table AS Statement
Published by :
Obay Salah , November 26, 2024
The CREATE TABLE AS statement is used to create a table from an existing table by copying the columns of existing table.Note: If you create the table... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Create Oracle Table
Published by :
Obay Salah , November 26, 2024
In Oracle, CREATE TABLE statement is used to create a new table in the database.To create a table, you have to name that table and define its columns... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Planning and Privileges for Oracle Data Redaction Policies
Published by :
Obay Salah , November 20, 2024
Since data redaction involves protecting highly sensitive data, only trusted users should create Oracle Data Redaction policies.You must hav... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Data Redaction Type
Published by :
Obay Salah , November 20, 2024
Redaction Types (Function Type):Full Data Redaction:Performs a full Redact of the contents of the specified column in the table or View... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Add Data Redaction Policy
Published by :
Obay Salah , November 20, 2024
To create a Data Redaction Policy, you must use the procedure DBMS_REDACT.ADD_POLICY, as follows:DBMS_REDACT.ADD_POLICY ( object_schema... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Benefit of Data Redaction
Published by :
Obay Salah , November 20, 2024
Benefits of Using Data Redaction:Oracle Data Redaction offers several benefits when used to protect your data.These benefits include:Redacti... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
When Use Data Redaction
Published by :
Obay Salah , November 20, 2024
When to Use Data Redaction?Unlike Data Masking, which hides sensitive data by permanently replacing it with realistic but fake data, Da... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Data Redaction
Published by :
Obay Salah , November 20, 2024
It is the process of selectively removing or obfuscating sensitive or confidential information from databases. Data Redaction provides a way... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Creating an Encrypted Tablespace
Published by :
Obay Salah , November 20, 2024
CREATE TABLESPACE encrypt_ts DATAFILE '$ORACLE_HOME/dbs/encrypt_df.dbf' SIZE 1M ENCRYPTION USING 'AES256' ENCRYPT; If you do not specify an... Continue Reading