Posted by Unknown 0 komentar
Download free Oracle Server 9i Quick Reference Guide pdf. This document is nothing official by Oracle Corporation. Oracle holds all rights on its documentation. Certain terms are registered trademarks.

This quick reference guide is some kind of outgrown cheat-sheet for all of us with limited supply of system memory. It enables quick lookup of syntax for statements which one might need less frequently in daily work. So the major goal of this document is compaction, not clarity. Some syntax options only work under certain circumstances, some options exclude each other. This behaviour is intentionally not reflected to avoid proliferation of similar statements. Be aware of your actions! The author disclaims liability for errors within this document and subsequent mistakes that might harm your database. In case of uncertainties please refer to Oracle’s excellent original documentation, which can be found online at the Oracle Technology Network ( – comprising several hundred megabytes meanwhile – or contact Oracle Customer Support. In any quick reference guide there is also no room for discussing concepts and techniques. If you do not know where to start just read the Oracle Database Concepts Guide which is very concise. Advanced discussions can be found elsewhere, my favourite resource being Oracle Guru Thomas Kyte has also written excellent books on techniques and best practices. Other invaluable repositories are the sites of Jonathan Lewis ( and of Steve Adams ( Not to forget that lots of technical whitepapers can be found at Oracle’s Technet.

Table content of Oracle Server 9i Quick Reference Guide
  • Disclaimer
  • Oracle Architecture
  • Instance
  • Database
  • Database Utilities
  • Tablespaces, Datafiles & Segments
  • Logfiles
  • Tables, Constraints & Triggers
  • Views, Synonyms & Sequences
  • Clusters
  • Index-organized Tables
  • Indexes
  • Undo Management
  • Temporary Segments
  • Users, Privileges, Resources & Policies
  • Auditing
  • Net Services
  • Recovery Manager
  • Distributed DB, Replication, Heterogenous Services, Advanced Queuing & Data Warehousing
  • Real Application Clusters
  • Globalization Support
  • SQL*Plus
  • Data Types (PL/SQL & Database)
  • SQL, PL/SQL & Java
  • Embedded SQL
  • SQLJ
  • Label Security
  • Performance

0 komentar:

Post a Comment