Oracle 8i DBA's For Dummies - Softcover

New Internet functionality and support for Linux make Oracle8i a milestone release, and this authoritative guide explains all the tools and techniques administrators need to master this potent new database. Some of the new features covered include an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. You'll discover SQL Plus basics and tools on your way to finding out more about fine-tuning performance and WebDB strategies. The CD-ROM includes a sample Oracle 8i database, sample scripts, and SQLPlus references.

If Oracle8I can do it, you can do it too?

Oracle8I is packed with new features, including an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. This comprehensive guide shows you step-by-step how to make the most of this improved functionality — and master the day-to-day tools and challenges of Oracle database administration. From SQL*Plus basics and performance-tuning options to recovery tips and WebDB strategies, Oracle8I DBA Bible is all you need to optimize a database and keep it running smoothly.

Inside, you'll find complete coverage of Oracle8I database administration

• Install Oracle8I and configure Net8 and the password file
• Use SQL*Plus, Import, SQL*Loader, and other DBA tools, including the new wizards
• Create and manage users as well as tables, materialized views, and other database objects
• Boost performance using the rules- or cost-based optimizer, SQL statement tuning, and instance tuning
• Master advanced topics, from PL/SQL programming and the enhanced Resource Management tools to auditing and partitioning
• Harness the new Internet functionality of 8I using WebDB, the HTML server, Java, and more
• Get complete syntax references for SQL, PL/SQL built-in functions, and SQL*Plus

All this on the Companion CD-ROM

• Scripts to create and populate the sample tables in the book
• Scripts containing code examples from the book
• Oraxel Lite, which enables you to access Oracle data from Excel

Master Oracle8I administration, from data warehousing to resource management

Harness the power of PL/SQL and the Oracle8I DBA tools and utilities

Capitalize on the new Internet and e-commerce functionality