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 […]
For many Types of Database files, sometimes I feel more confused, but you have to be aware of block size, decomposite, 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 tablespace autoextend is NO and tablespace size […]
User Oracle Database doesn’t drop users whose schemas contain objects unless you specify CASCADE. CASCADE Specify CASCADE to drop all objects on the user’s(schemas) before dropping the user. You must specify this clause to drop a user whose schema contains any objects. If the user’s schema contains tables, then Oracle Database drops the tables and […]
Plan Migration Oracle Database 10g from M8000 to Oracle Database 11R2 on EXADATA I would like to share the knowledge workshop that I did, I hope this knowledge, it’ll be helping somebody, neither more nor less. Migration Database No. Task Detail (M8000) Task Detail (EXADATA) 1 create database 11g(11.2.0.4) 2 gen script creates tablespace 3 […]
Create Databases 12c PDB (Advance) with DBCA After installing Oracle Database 12c software, We have to create a database with dbca command with GUI Actually, you can create the database together, when you install the software, but I need to manage the necessary database files to the location that I prepared. log in to oracle […]
Create Databases 12c (Typical) with DBCA After installing Oracle Database 12c software, We have to create a database with dbca command with GUI Actually, you can create the database together, when you install the software, but I need to manage the necessary database file to the location that I prepared. log in to oracle user […]
| 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 | 31 | ||||