[Laskey99] Chapter 9. Oracle Tools

来源:百度文库 编辑:神马文学网 时间:2024/04/25 23:03:37

Chapter 9. Oracle Tools

Oracle databaseadministration is like most other professional endeavors: the qualityof job performance is often related to the tools available. Oracledatabase administrators are fortunate to have a variety of toolsavailable to aid them in the day-to-day administration of the Oracledatabase. This chapter provides an overview of the most popular anduseful Oracle tools, and shows how each tool can make the DBA'sjob a bit easier.

Tools provided run in either GUI (Graphical User Interface) mode,usually on Windows or Motif platforms, or in the more traditionalcharacter mode. Since GUI tools are designed to operate intuitivelyand have complete online help files, we only briefly describe theircapabilities. Character mode tools, on the other hand, typically relyon command-line parameters or parameter files and have little or noonline help. For these tools, we give information on usage here, andwe supply more detailed information on specific character mode syntaxin Chapter 16.

9.1. About the Tools

Oracle has long recognized that without appropriate tools, a databaseis just a collection of bits and bytes, of little use to anyone.While some vendors assume that tools will be built by the user orpurchased from another vendor, Oracle provides a powerful set oftools with the base distribution of the database that are useful foradministration and configuration of the database as well as forapplication development. In fact, it is entirely possible to designand build a functioning database application using just this set ofincluded tools. Table 9.1 provides a quick guideto selecting appropriate Oracle-supplied tools. Note that Import andExport are described in Chapter 4.

Table 9.1. Oracle-Supplied Tools
If You Want to Use This Tool Administer one or more Oracle databases Oracle Enterprise Manager Configure Net8 (Oracle8) Net8 Assistant Configure SQL*Net (Oracle7) Oracle Network Manager Create a database object SQL*Plus Create a formatted report of data from the database SQL*Plus Create or modify physical database structures SQL*Plus, Server Manager, or Oracle Enterprise Manager Export a copy of all or part of the database Export Generate SQL statements using SQL SQL*Plus Insert, update, or delete data in the database SQL*Plus Load data into a database SQL*Loader Modify a database object SQL*Plus, Server Manager, or Enterprise Manager Monitor the database Oracle Enterprise Manager or Server Manager (GUI mode) Perform DBA tasks in a GUI environment Oracle Enterprise Manager or Server Manager (GUI mode) Perform DBA tasks in line mode Server Manager Reload all or part of the database from a previous export Import
  • Create Bookmark (Key: b)Create Bookmark
  • Create Note or Tag (Key: t)Create Note or Tag
  • Download (Key: d)Download
  • Email This Page (Key: e)Email This Page
  • PrintPrint
  • Html View (Key: h)Html View
  • Zoom Out (Key: -)Zoom Out
  • Zoom In (Key: +)Zoom In
  • Toggle to Full Screen (Key: f)
  • Previous (Key: p)Previous
  • Next (Key: n)Next

Related Content

Oracle
From: Introduction to the New Mainframe: Security

Oracle and Security
From: Oracle Security

Oracle Warehousing Tools
From: Oracle Database 10g Data Warehousing

The Oracle Data Provider
From: ADO.NET Programming in Visual Basic™ .NET

Oracle CREATEs
From: Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Oracle
From: Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Oracle databases
From: Database Performance Tuning on AIX

Oracle Performance
From: Oracle Essentials, 4th Edition

Oracle Database Examples
From: Beginning Oracle Database 11g Administration: From Novice to Professional

Managing Oracle Application Servers
From: Oracle Application Server 10g Essentials