Oracle9i For Dummies

This revised edition introduces you to Oracle9i, which offers many improved features for managing and monitoring databases, and also covers the companion tool Oracle Enterprise Manager (OEM version 2.x). In Oracle9i For Dummies, author Carol McCullough-Dieter takes the complexity out of the features available in Oracle9i and Enterprise Manager version 2.2 and makes them easy to understand. She covers the most important features of Oracle9i, including how to: * Change a table's structure more easily and convert LONG datatype columns to LOB datatype quickly with the ALTER TABLE command * Configure and schedule backup and recovery more easily through new features of the Recovery Manager tool * Fix mistakes with self-service error recovery (supported through a new feature of SQL itself) * Use Flashback query, a tool to query past states of the database * Get the most out of the Virtual Private Database, a concept that was introduced in Oracle8i and is expanded upon with the introduction of Oracle Internet Directory -- a web-based tool displaying files and directories. It includes a web-based Self-Service Administration Servlet with which users administer their own personalized data over the Web * Create XML documents quickly. XML has two new built-in tools in Oracle9i: XML Developer Kit and XML Database Support * Automate file space for the database. Oracle9i has a new method for managing data files, called Oracle Managed Files.