| |
| |
| Forward | |
| |
| |
| Introduction | |
| |
| |
| Why This Book Makes Sense | |
| |
| |
| Some Basic Assumptions | |
| |
| |
| Quickie Overview of This Book | |
| |
| |
| Of Mice and Sven (Mouse Moves and Special Text) | |
| |
| |
| Icons Used in This Book | |
| |
| |
| |
| Road Map | |
| |
| |
| |
| A Quick Tour of Oracle8i | |
| |
| |
| Discovering Oracle8i: The Program That Runs It All | |
| |
| |
| The Oracle8i core package | |
| |
| |
| The Oracle8i newest stars: XML and Enterprise Java Beans | |
| |
| |
| The new look of Enterprise Manager | |
| |
| |
| DBA Studio packs four all-star components | |
| |
| |
| Starting Up Oracle8i | |
| |
| |
| Starting the database with the Instance Manager | |
| |
| |
| Starting Oracle8i using SVRMGRL | |
| |
| |
| Looking Around with DBA Studio | |
| |
| |
| The Object/Object Contents window | |
| |
| |
| The other Schema Manager elements | |
| |
| |
| Other Elements: The Main Menu and Button elements | |
| |
| |
| Getting Acquainted with SQL: The Messenger Priestess of Oracle8i | |
| |
| |
| Starting and stopping SQL*Plus on a desktop | |
| |
| |
| Using SQL*Plus in line command mode | |
| |
| |
| Initializing the Enterprise Manager Console | |
| |
| |
| Creating a repository for Enterprise Manager Version 2.1 | |
| |
| |
| Starting the Agent | |
| |
| |
| Starting the Enterprise Management Service | |
| |
| |
| Setting up a Web-based Console and DBA Studio | |
| |
| |
| Taking a quick tour of Enterprise Manager Console | |
| |
| |
| Getting Help: Let Your Mouse Do the Walking | |
| |
| |
| Shutting Down Oracle8i | |
| |
| |
| Shutting down Oracle8i on a desktop | |
| |
| |
| Starting the database with the Instance Manager | |
| |
| |
| Shutting down Oracle8i on a mainframe or a network | |
| |
| |
| |
| Data Whaaat? A Database Primer | |
| |
| |
| Dataspeak Definitions for the Techno-Impaired | |
| |
| |
| Relational Database Concepts | |
| |
| |
| Users and roles | |
| |
| |
| Tables | |
| |
| |
| Columns and rows | |
| |
| |
| Relationships | |
| |
| |
| Object-Relational Database Concepts | |
| |
| |
| An object defined | |
| |
| |
| The scoop on object types | |
| |
| |
| The connection of relational tables with objects | |
| |
| |
| Object reference | |
| |
| |
| Methods to their madness | |
| |
| |
| Nested tables | |
| |
| |
| Arrays | |
| |
| |
| The Kinds of Database Things That You Can Do with Oracle8i | |
| |
| |
| Keeping track of a fishbowl (the easy example) | |
| |
| |
| Running a pet shop (the medium example) | |
| |
| |
| Tracking endangered species globally (the hard example) | |
| |
| |
| |
| SQL Nuts and Bolts | |
| |
| |
| Starting Up SQL*Plus | |
| |
| |
| Asking a Question in SQL | |
| |
| |
| The basic SQL query | |
| |
| |
| Some sample queries | |
| |
| |
| Some tips to help you write good queries | |
| |
| |
| Using an Editor While Running SQL*Plus | |
| |
| |
| Pulling Out Data without Breaking Anything | |
| |
| |
| Combining Tables: The Meat and Potatoes of SQL | |
| |
| |
| Basic join query structure | |
| |
| |
| Examples of join queries | |
| |
| |
| Using the Built-In Functions of Oracle8i | |
| |
| |
| Reformatting a date with TO_CHAR | |
| |
| |
| Concatenating columns with CONCATENATE (11) | |
| |
| |
| Grouping and Summarizing Data | |
| |
| |
| Making Power Changes in the Data | |
| |
| |
| Modifying data with the UPDATE command | |
| |
| |
| Inserting new rows with grace and style | |
| |
| |
| Deleting rows with distinction | |
| |
| |
| Fixing Mistakes, or Where's the Brake?! | |
| |
| |
| The COMMIT and ROLLBACK commands | |
| |
| |
| Commands that can't be undone, even with ROLLBACK | |
| |
| |
| |
| Object SQL: The New Stuff | |
| |
| |
| Starting Up SQL*Plus | |
| |
| |
| Querying Object Tables in SQL | |
| |
| |
| The basic object-oriented SQL query | |
| |
| |
| Queries using a nested table | |
| |
| |
| Queries using an array | |
| |
| |
| Making Changes to Object Table Data | |
| |
| |
| Updating an object | |
| |
| |
| Updating one row in a nested table | |
| |
| |
| Inserting rows into an object table | |
| |
| |
| Inserting rows into an array | |
| |
| |
| Inserting rows into a nested table | |
| |
| |
| Deleting rows from an object table | |
| |
| |
| Deleting a row from a nested table | |
| |
| |
| |
| Using the Enterprise Manager DBA Tools | |
| |
| |
| The New Look of Enterprise Manager | |
| |
| |
| Exploring Four Cornerstone Tools | |
| |
| |
| Storage Manager: The external viewpoint | |
| |
| |
| Security Manager: The keeper of the gate | |
| |
| |
| Schema Manager: The builder of tables | |
| |
| |
| Instance Manager: The activity monitor | |
| |
| |
| |
| Getting Started | |
| |
| |
| |
| The Relational Model and You | |
| |
| |
| Redundant Relational Database Redundancy | |
| |
| |
| Keys Rule | |
| |
| |
| Considering types of keys | |
| |
| |
| Importing foreign keys | |
| |
| |
| The Key, the Whole Key, and Nothing but the Key | |
| |
| |
| One Too Many: The Bread and Butter of Relational Databases | |
| |
| |
| Objects and the Oracle8i Database | |
| |
| |
| Defining an object | |
| |
| |
| Connecting relational tables with objects | |
| |
| |
| |
| Diagramming Your World | |
| |
| |
| Getting Something Down on Paper | |
| |
| |
| Using Tree Diagrams: Easy When You Know the Lingo | |
| |
| |
| Hooking Up with Objects | |
| |
| |
| Understanding the Basic UML Type Model Diagram | |
| |
| |
| |
| Getting Familiar with Oracle8i Data-Dictionary Views | |
| |
| |
| Viewing the Oracle8i Data-Dictionary Views | |
| |
| |
| Using Data-Dictionary Views | |
| |
| |
| Looking at Data-Dictionary Views with SQL*Plus | |
| |
| |
| |
| Oracle's User | |
| |
| |
| Playing a Role | |
| |
| |
| What kinds of users are there? | |
| |
| |
| What kind of user are you? | |
| |
| |
| Creating a New User from Scratch | |
| |
| |
| Changing Your Password | |
| |
| |
| Changing your password in SQL*Plus | |
| |
| |
| Changing any user's password in Security Manager | |
| |
| |
| Changing User Identity | |
| |
| |
| |
| Putting Oracle8i to Work | |
| |
| |
| |
| Defining Tables, Tablespaces, and Columns | |
| |
| |
| Tablespace: The Final Frontier | |
| |
| |
| A Word or Two about Columns | |
| |
| |
| Defining columns in Oracle8i | |
| |
| |
| Allowing nulls or not | |
| |
| |
| A Table of Your Own with SQL | |
| |
| |
| Schema Manager's Spreadsheet for Tables | |
| |
| |
| |
| Creating Object Types, Objects, and References | |
| |
| |
| Types Need No Space | |
| |
| |
| Defining an object type | |
| |
| |
| Making a table type | |
| |
| |
| Creating an array type | |
| |
| |
| Objects Still Sit inside Tablespaces | |
| |
| |
| Making an object table | |
| |
| |
| Making a hybrid table | |
| |
| |
| |
| Security Options: Roles and Grants | |
| |
| |
| Security Blanket Included | |
| |
| |
| Roles Meet the Real World | |
| |
| |
| Roles and Privileges with Security Manager | |
| |
| |
| Creating a role and assigning object privileges | |
| |
| |
| Assigning users to a role | |
| |
| |
| Assigning privileges to roles with SQL*Plus | |
| |
| |
| Roles and Privileges with SQL | |
| |
| |
| |
| Views and Synonyms: Do You See What I See? | |
| |
| |
| Views: Like a Table--Almost | |
| |
| |
| Views that narrow | |
| |
| |
| Views that tie everything together | |
| |
| |
| Views with Schema Manager | |
| |
| |
| Object views with Schema Manager | |
| |
| |
| Synonyms: Nicknames for Tables and Views | |
| |
| |
| Good uses for synonyms | |
| |
| |
| A grant and a synonym combined | |
| |
| |
| Materialized views--pros and cons | |
| |
| |
| |
| Oracle Portal: The Best New Tool for the Internet | |
| |
| |
| Exploring Oracle Portal | |
| |
| |
| Assigning WebDB Developers | |
| |
| |
| Creating a Web Report | |
| |
| |
| Going for a Form | |
| |
| |
| |
| Java and the Internet Database | |
| |
| |
| Discovering Java Virtual Machine (JVM) | |
| |
| |
| Using the Oracle8i JVM--some benefits | |
| |
| |
| Introducing SQLJ | |
| |
| |
| Creating a Stored Database Procedure with Java and SQLJ | |
| |
| |
| |
| Writing Java code with embedded SQLJ | |
| |
| |
| |
| Loading the Java into the database | |
| |
| |
| |
| Creating a SQL wrapper for the Java code | |
| |
| |
| |
| Using the SQL wrapper in a SQL query | |
| |
| |
| Running a Java Applet that Queries the Database | |
| |
| |
| |
| XML and Enterprise Java Beans | |
| |
| |
| What is XML? | |
| |
| |
| A Sample XML XSQL Servlet | |
| |
| |
| Anyone for EJB? | |
| |
| |
| |
| The Five Ws of Safeguarding Your Data | |
| |
| |
| Why Back Up--Onward and Upward! | |
| |
| |
| What to Back Up | |
| |
| |
| When to Back Up (Before You Go Off the Cliff) | |
| |
| |
| How to Back Up (Choosing Your Backup Weapon) | |
| |
| |
| Data Manager | |
| |
| |
| EXP and IMP commands | |
| |
| |
| Where to Hide Your Backup Files | |
| |
| |
| |
| Tuning Up and Turbocharging | |
| |
| |
| |
| What's Slowing Down Your Query? | |
| |
| |
| Helping the Optimizer Do Its Job | |
| |
| |
| Moods and modes of the Optimizer | |
| |
| |
| One command to analyze your entire schema | |
| |
| |
| Personal attention: Analyzing one table at a time | |
| |
| |
| A hint ... you're getting warmer | |
| |
| |
| Getting Ahead While Testing and Tuning | |
| |
| |
| Using EXPLAIN PLAN to see your query's plan | |
| |
| |
| |
| Speeding Up Queries with Keys and Indexes | |
| |
| |
| Why Create an Index? | |
| |
| |
| Adding and Removing a Primary Key | |
| |
| |
| Adding a primary key | |
| |
| |
| Removing a primary key | |
| |
| |
| Creating and Dropping Foreign Keys | |
| |
| |
| Adding a foreign key | |
| |
| |
| Removing a foreign key | |
| |
| |
| Creating Your Own Indexes | |
| |
| |
| Adding an index | |
| |
| |
| Removing an index | |
| |
| |
| Using Indexes with Object Tables and Nested Tables | |
| |
| |
| Creating an index on an object table | |
| |
| |
| Creating an index on a nested table | |
| |
| |
| Removing an index on an object table or a nested table | |
| |
| |
| The New Oracle Tuning Pack | |
| |
| |
| Watch the Index Tuning Wizard work its magic | |
| |
| |
| Let SQL Analyze help tune queries | |
| |
| |
| |
| Correcting Flaws | |
| |
| |
| Categories of Column Changes | |
| |
| |
| Baby Bear: Easy as Porridge | |
| |
| |
| Mama Bear: A Few Medium Steps | |
| |
| |
| If the column must be null ... | |
| |
| |
| Column must not have nulls | |
| |
| |
| Papa Bear: A Lotta Steps | |
| |
| |
| Modification of Object Tables in Schema Manager | |
| |
| |
| The Oracle Change Management Pack--Something New to Try! | |
| |
| |
| |
| The Part of Tens | |
| |
| |
| |
| Ten Tips for Good Design | |
| |
| |
| Name Tables and Columns Creatively and Clearly | |
| |
| |
| Look Before You Leap (Design Before You Build) | |
| |
| |
| Go Ahead, Leap! (Build a Prototype) | |
| |
| |
| Share--Don't Reinvent the Wheel | |
| |
| |
| Remember that Primary Keys Are Your Friends | |
| |
| |
| Small keys take up less room | |
| |
| |
| Nonintelligent keys are easy to maintain | |
| |
| |
| Use Caution When Modifying Table Definitions | |
| |
| |
| Handle Derived Data Efficiently | |
| |
| |
| Approach Internet Security in Practical Ways | |
| |
| |
| Low security--application proxy | |
| |
| |
| Medium security--application context | |
| |
| |
| High security--SSL | |
| |
| |
| Be Smart about Test Data | |
| |
| |
| Talk to Non-Techie-Type Humans | |
| |
| |
| |
| Ten Handy Oracle8i Internet Features | |
| |
| |
| Intermedia | |
| |
| |
| Net8 with SSL | |
| |
| |
| PL/SQL on the Web | |
| |
| |
| Internet File System (iFS) | |
| |
| |
| JDeveloper | |
| |
| |
| JDBC | |
| |
| |
| Java Stored Procedures | |
| |
| |
| Web Assistant | |
| |
| |
| Visual Information Retrieval (VIR) | |
| |
| |
| Portal to Go | |
| |
| |
| |
| Appendix | |
| |
| |
| |
| Glossary | |
| |
| |
| Index | |
| |
| |
| Book Registration Information | |