Sunday, April 30, 2006
Oracle 9i - Index of notes
Credits & Disclaimer : The following are my Oracle 9i SQL notes prepared during the course of my preparation for Oracle DBA 9i Exam 1Z0-007 and mostly referenced from various Oracle publications. These are meant for my personal use.
In past I have prepared notes on paper many times but seldom have i been able to use them. As layers of dust settle on them, it gets kind of messy to touch them :) This blog, an online notebook, seems like an ideal solution to me, to be referenced on the move without need to carry bulky books.
In past I have prepared notes on paper many times but seldom have i been able to use them. As layers of dust settle on them, it gets kind of messy to touch them :) This blog, an online notebook, seems like an ideal solution to me, to be referenced on the move without need to carry bulky books.
Part I :
- Data Query
- Logical Operators (AND, OR, NOT etc) & Single row Functions
- DML & Locks
- DDL & Constraints
- Views & Top-N Analysis
- Sequences
- Database Link (note : scoll to bottom of privilege notes)
Part II:
- Creating Database manually / Restoring backed-up database
- Password authentication setup : Operating System authentication / password file authentication
- Control Files
- Redo Log Files
- Segments & Data Blocks - INITRANS-MAXTRANS / PCTFREE-PCTUSED-FREELIST
- Tablespaces
- Managing User (Create-Alter-Drop)
- Profiles
- Privileges (Grant-Revoke) & Database Link
- Roles(Create-Alter-Set-Drop)
- Auditing(Audit-Noaudit)
- Password Management script utlpwdmg.sql
- Views : Storage relationships (Segments & Extents)
- Views : Users-Quota-Profile-Resource cost-Resource Limit-Privileges
