Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

™ USER’S GUIDE This guide contains proprietary information, which is protected

™ USER’S GUIDE This guide contains proprietary information, which is protected by copyright. The information in this guide is subject to change without notice and does not represent a commitment on the part of Quest Software. The software described in this guide is furnished under a license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of this agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording, for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc. © 2000 Quest Software, Inc. All Rights Reserved. Quest™ is a trademark of Quest Software, Inc. Quest Software, Inc. 8001 Irvine Center Drive Irvine, CA 92618 USA Tel. 949-754-8000 / Fax 949-754-8999 support@quest.com info@quest.com www.quest.com TOAD™ is a trademark of Quest Software, Inc. Other trademarks and registered trademarks used in this guide are the property of their respective owners. Contents C O N T E N T S TOAD User’s Guide INTRODUCTION.............................................................................................................................................7 LOGON/LOGOFF............................................................................................................................................9 LOGON OPTIONS ............................................................................................................................................12 CONNECTING TO PERSONAL ORACLE.............................................................................................................17 END CONNECTION..........................................................................................................................................17 SCHEMA PREPARATION...........................................................................................................................19 BASIC NAVIGATION ...................................................................................................................................21 MOUSE...........................................................................................................................................................21 KEYBOARD ....................................................................................................................................................26 HOTKEYS – ADDING/ALTERING......................................................................................................................28 RIGHT-CLICK MENUS ....................................................................................................................................30 Location of Right-Click Menus .................................................................................................................31 MAIN TOAD WINDOW TOOLBAR...........................................................................................................35 SQL EDITOR..................................................................................................................................................37 TOOLBAR BUTTONS........................................................................................................................................38 SHORTCUT KEYS............................................................................................................................................40 USING THE SQL EDITOR................................................................................................................................44 Selecting a table to edit.............................................................................................................................44 Commit......................................................................................................................................................47 Explain Plan..............................................................................................................................................49 Offline Text Editor.....................................................................................................................................52 Recall and Add SQL..................................................................................................................................55 OPTIONS FOR THE SQL EDITOR .....................................................................................................................60 EXECUTING STATEMENTS..............................................................................................................................65 Execute SQL Scripts..................................................................................................................................66 Table/View Aliases....................................................................................................................................67 CONFIGURING THE EDITOR ............................................................................................................................69 EDITOR OPTIONS............................................................................................................................................78 General Options........................................................................................................................................79 Highlighting ..............................................................................................................................................89 Key Assignments........................................................................................................................................95 4 TOAD User’s Guide Auto Replace ............................................................................................................................................ 97 Code Templates........................................................................................................................................ 99 RIGHT-CLICK MENU ................................................................................................................................... 101 SQL RESULTS GRID.................................................................................................................................... 102 Results Grid Right-Click Menu .............................................................................................................. 104 OPTIONS FOR THE DATA GRIDS................................................................................................................... 117 LONG AND LONG RAW........................................................................................................................... 121 TIME VALUES.............................................................................................................................................. 124 SQL TEMPLATES ........................................................................................................................................ 125 DBMS_OUTPUT TO DEBUG PL/SQL CODE............................................................................................. 127 MAKE CODE STATEMENT AND STRIP CODE STATEMENT............................................................................ 128 OPTIONS FOR THE EDITORS......................................................................................................................... 131 SQL EDITOR TASKS.................................................................................................................................... 134 PROCEDURE EDITOR.............................................................................................................................. 147 TOOLBAR BUTTONS .................................................................................................................................... 148 SHORTCUT KEYS......................................................................................................................................... 151 USING THE PROCEDURE EDITOR ................................................................................................................. 153 NAVIGATOR LIST ........................................................................................................................................ 162 Navigator buttons................................................................................................................................... 162 OPTIONS FOR THE PROCEDURE EDITOR....................................................................................................... 163 RIGHT-CLICK MENU ................................................................................................................................... 168 SOURCE CODE MANAGEMENT .................................................................................................................... 169 PROCEDURE EDITOR TASKS ........................................................................................................................ 171 PL/SQL DEBUGGER.................................................................................................................................. 183 REQUIREMENTS........................................................................................................................................... 185 To run the PL/SQL Debugger ................................................................................................................ 188 To Activate the PL/SQL Debugger Registration Key ............................................................................. 188 DEBUG TOOLBAR BUTTONS......................................................................................................................... 189 DEBUG SHORTCUT KEYS............................................................................................................................. 194 USING THE DEBUGGER................................................................................................................................ 195 THE STATUS PANEL INDICATORS................................................................................................................ 197 OPTIONS MENU FOR DEBUGGING ................................................................................................................ 198 THE DOCKABLE WINDOWS ......................................................................................................................... 202 Breakpoints ............................................................................................................................................ 204 Watches .................................................................................................................................................. 210 Call Stack ............................................................................................................................................... 216 DBMS_OUTPUT.................................................................................................................................... 217 DEBUG FUNCTIONS ..................................................................................................................................... 221 PREPARING PL/SQL CODE FOR PRODUCTION............................................................................................. 229 SCHEMA BROWSER................................................................................................................................. 231 TOOLBARS .................................................................................................................................................. 232 RIGHT-CLICK MENUS ................................................................................................................................. 235 Contents 5 USING THE SCHEMA BROWSER ....................................................................................................................237 OPTIONS FOR THE SCHEMA BROWSER .........................................................................................................241 TABLES........................................................................................................................................................251 INDEXES.......................................................................................................................................................283 PROCEDURES ...............................................................................................................................................287 TRIGGERS.....................................................................................................................................................293 SEQUENCES..................................................................................................................................................296 VIEWS..........................................................................................................................................................299 SYNONYMS ..................................................................................................................................................307 CONSTRAINTS ..............................................................................................................................................310 DB LINKS.....................................................................................................................................................314 JAVA ..........................................................................................................................................................316 SCHEMA BROWSER TASKS...........................................................................................................................317 OTHER TOAD OPTIONS AND FEATURES ...........................................................................................321 SQL MODELER............................................................................................................................................322 OBJECT SEARCH...........................................................................................................................................341 DDL REPORTS.............................................................................................................................................343 MASTER/DETAIL RECORD BROWSER............................................................................................................345 PRIVILEGES..................................................................................................................................................347 REBUILD TABLE...........................................................................................................................................349 TOAD SECURITY.........................................................................................................................................351 VIEW MENU.................................................................................................................................................358 OPTIONS MENU............................................................................................................................................359 General Options......................................................................................................................................360 Oracle Options........................................................................................................................................362 Startup Options .......................................................................................................................................365 Files Options...........................................................................................................................................367 Source Control Options...........................................................................................................................369 Printing Options......................................................................................................................................371 TUNING SERVER STATISTICS........................................................................................................................372 SGA TRACE OPTIMIZATION.........................................................................................................................375 ESTIMATE TABLE SIZE.................................................................................................................................377 ESTIMATE INDEX SIZE..................................................................................................................................379 PROFILER ANALYSIS (ORACLE 8I ONLY)......................................................................................................380 OBJECT BROWSER (ORACLE 8 OR 8I ONLY) .................................................................................................392 Objects Panel ..........................................................................................................................................392 Details Panel...........................................................................................................................................395 TROUBLESHOOTING................................................................................................................................403 FREQUENTLY ASKED QUESTIONS ................................................................................................................403 SQL*NET/NET8 INSTALLATION PROBLEMS................................................................................................404 UPGRADES...................................................................................................................................................407 TOAD ADD-ON MODULES .......................................................................................................................409 6 TOAD User’s Guide QUEST SOFTWARE SQLAB TUNER/XPERT .................................................................................................. 410 QUEST SOFTWARE SQL IMPACT................................................................................................................. 411 REVEALNET PL/FORMATTER...................................................................................................................... 412 REVEALNET KNOWLEDGE BASE................................................................................................................. 413 QUEST SOFTWARE PRODUCTS AND SOLUTIONS.......................................................................... 415 DEVELOPMENT & DEPLOYMENT................................................................................................................. 416 SQL Development................................................................................................................................... 416 Deployment ............................................................................................................................................ 416 Application Change Management.......................................................................................................... 417 PRODUCTION SUPPORT................................................................................................................................ 417 High Availability .................................................................................................................................... 417 Enterprise Monitoring............................................................................................................................ 418 Database Management........................................................................................................................... 418 INFORMATION AVAILABILITY ..................................................................................................................... 419 Enterprise Report Management ............................................................................................................. 419 Output Management............................................................................................................................... 419 QUEST SOFTWARE INFORMATION.................................................................................................... 420 TECHNICAL SUPPORT.................................................................................................................................. 421 INDEX........................................................................................................................................................... 422 Introduction TOAD TOAD is a powerful low-overhead tool built around an advanced SQL and PL/SQL editor. It was designed from the developer’s perspective, and the result is an easy to use, fast, and effective interface. The GUI object browsers provide quick access to database objects. You don’t have to be a PL/SQL expert to access database objects when you’re using TOAD. You can view the Oracle Dictionary, tables, indexes, stored procedures, and more-- all through a multi-tabbed browser. PL/SQL script writers can use the advanced editing features to save time and increase productivity. Code can be created from shortcuts and code templates. Even create your own code templates. Use TOAD to Create, browse, or alter objects (tables, views, indexes, etc.) including Oracle8 TYPE objects Graphically build, execute, and tune queries Edit, debug, and profile “stored procedures” including procedures, functions, packages, and triggers Search for objects Find and fix database problems with constraints, triggers, extents, indexes, and grants 8 This guide is a how-to and reference for new users and users already familiar with TOAD. The guide does not cover every TOAD Window, Option, and Function. The guide covers the following windows: SQL Editor Procedure Editor Schema Browser PL/SQL Debugger (an optional feature) Once you are comfortable navigating around a few of these windows you’ll discover that the other TOAD windows have a similar design. The manual also covers the following major topics: logon/logoff navigation and shortcuts additional options in other TOAD windows optional add-on modules Note that this User Guide was prepared in February, 2000. New or changed TOAD features since February, 2000, are not reflected in this version of the TOAD User Guide. Note that colors are presented in the .PDF, which commercial TOAD users can download from www.quest.com. The printed version of the TOAD User Guide manual is printed in black and white, so the color differences are not always distinguishable. For details on installing and uninstalling TOAD, refer to the TOAD Getting Started Guide. Remember, you can always access TOAD Help while in TOAD by pressing the F1 Key. Logon/Logoff When you Start TOAD a Login screen displays. The screen lists your previous connections (server, user, and the date and time of the connection). You can create a new connection to Oracle or select from a list of previous connections. If the Build Oracle Alias List checkbox is checked, TOAD will fill the database dropdown with the database aliases listed in the TNSNAMES.ORA file. If you double-click to select a previous logon from the list of previous logons, the default password is the same as the username. So, if this is your first time running TOAD, your password is your Username. Here, BEQ-LOCAL is the database, the Username is SCOTT and the password entered is TIGER. 10 The previous connections list can be sorted by clicking on the Server, User, or Last Connect column header. Click once on a header and the associated list is sorted chronologically or in ascending order. Click twice on a header, and the associated list is sorted in descending order. The date format comes from the workstation setting in Settings > Control Panel > Regional Settings > Date > Short date style option. Logon You can use Oracle usernames without passwords in TOAD. Whatever you enter in Database, Username, and Password boxes are passed to the database. If the database permits default passwords, then you can connect. Server Login You get to this dialog via the File > New Connection menu item, or when TOAD starts up. You can create a new connection to Oracle or select from a list of previous connections. TOAD will fill the database dropdown with the names of previous sessions and any aliases in TNSNAMES.ORA. To create a new connection 1 Type the name of the database in the dropdown combo box labeled Database. The server name you use must have an entry in the TNSNAMES.ORA file. 2 Type the name of the USER in the textbox labeled User/Schema. 3 Type the PASSWORD for the user in the textbox labeled Password. The characters will not display as you type, asterisks will display instead. 4 Click OK OR Press <ENTER>. Chapter 2 Logon/Logoff 11 To use a previous connection 1 Select a User/ Database combination from the dropdown combo box OR Double-click the previous connection from the list in the left panel. TOAD will copy the user name into the Password textbox and will place the cursor in the Password textbox. 2 If the PASSWORD is not the same as the USER, type the PASSWORD. 3 Click OK or press <ENTER>. 4 TOAD saves the USER/DATABASE combinations between TOAD sessions but does NOT save the password. There is an option under View > Options, General tab, to Save passwords for Oracle connections and Encrypt saved passwords. DO NOT ENABLE THESE OPTIONS UNLESS YOU HAVE A SECURE ENVIRONMENT. To delete a previous connection 1 Select a connection from the Server, User, Last Connect list. 2 Press the <DELETE> key. To run TOAD offline 1 Click the <Cancel> button on the Server Login window. 2 Open the uploads/S4/ toad-users-guide 1 .pdf