Part III. Tools and Utilities

This part of the book summarizes the commands and file specifications for a variety of tools and utilities used to manage and interact with the Oracle database. It consists of the following chapters:

Chapter 12, summarizes the commands and formatting elements available with SQL*Plus, the command-line interface to the Oracle database that you use to enter SQL statements and PL/SQL code and execute script files.

Chapter 13, summarizes the commands available with the Export utility (which copies data from the database into a binary file) and the Import utility (which bring data into the Oracle database from a binary file). You can use these utilities to capture both the structures and the data in an Oracle database.

Chapter 14, summarizes the commands available with SQL*Loader, a utility that allows you to load data in standard operating system file formats into an Oracle database and to perform a variety of data manipulation and transformation operations during the load.

Chapter 15, briefly describes Oracle backup and recovery concepts, outlines the procedures you can follow to perform user-managed backup and recovery, and summarizes the commands available with the Recovery Manager (RMAN), the Oracle backup and recovery utility.

Chapter 16, summarizes the features of Enterprise Manager, a graphical user interface console that allows you to manage Oracle databases.

Chapter 17, summarizes the main Oracle tools that help you examine and improve Oracle performance. ...

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.