before we go to generate for enable privilege audit, I have to talk about the structure of oracle, They have many kinds of audit types so I think the three types of audit that I’ll say about, it’s exactly the same meaning, let get the look. Using Default Auditing for Security-Relevant SQL Statements and Privileges […]
Before export or import, You have to create a directory for an object, it can access. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file system of the database server. A data pump is a logical Backup, You can back up […]
How are we choosing to enable or disable archivelog Archivelog Mode You can perform a backup when the database is online(Hot backup) and the database is offline(Cold Backup) that means if You see a problems or disasters something with your database then you’ll have the copy data and archive the log file to recover a […]
When you do maintenance, upgrade and migration. You have to keep data before and after to compare to the same thing. For count object SELECT OWNER,OBJECT_TYPE,COUNT(*) FROM DBA_OBJECTS WHERE OWNER NOT IN (‘SYS’,’SYSTEM’,’SYSMAN’,’ANONYMOUS’, ‘APPQOSSYS’,’DBSNMP’, ‘EXFSYS’,’MDSYS’,’ORACLE_OCM’ ,’ORDSYS’ ,’OUTLN’ ,’SYSTEM_LOAD_TEST’,’TSMSYS’,’WMSYS’,’XDB’,’XS$NULL’,’ORDDATA’,’CTXSYS’) GROUP BY OWNER,OBJECT_TYPE ORDER BY OWNER,OBJECT_TYPE; 2. For counting objects by status SELECT OWNER,OBJECT_TYPE,STATUS,COUNT(*) FROM DBA_OBJECTS WHERE […]
Segments The level of logical database storage greater than an extent is called a segment. A segment is a set of extents, each of which has been allocated for a specific data structure and all of which are stored in the same tablespace. A segment and all its extents are stored in one tablespace. Within a […]
Database security Each database product like Oracle has a particular security model and the DBA should be well aware in order to control access to data. This is part of authorization, Authorization is granting permission on various parts of the database. Object privileges An object privilege is a right to perform a particular action on […]
Database security (Recompiling) Each database product like Oracle has a particular security model and the DBA should be well aware in order to control access to data. This is part of authorization, Authorization is granting permission on various parts of the database. ***note*** You can use just UTLRP for all invalid objects If you are […]
Database security Each database product like Oracle has a particular security model and the DBA should be well aware in order to control access to data. This is part of authorization, Authorization is granting permission on various parts of the database. System privileges A system privilege is a right to perform a particular action or […]
Prerequisite You have to create a temporary tablespace for the user You have to create a tablespace for the user You have to prepare a role and profile for the user — CREATE USER WITH DEFAULT TABLE — AND TEMPORARY TABLESPACE — AND PROFILE SELECT ‘CREATE USER ‘||U.USERNAME||’ IDENTIFIED BY VALUES ”’||S.PASSWORD||”’ DEFAULT TABLESPACE ‘||U.DEFAULT_TABLESPACE||’ […]
Many Types of Database files, and sometimes I feel more confused, but you have to be aware of block size and increment, like my command. ***note*** before you’ll use my command. Please read to understand. —– Those commands are separated into 4 types —– 1st —> for temporary tablespace autoextend is NO and temporary tablespace […]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |