Oracle Toad 10.1.1操作手册：全面指南

需积分: 48 115 浏览量更新于2024-07-21 收藏 11.72MB PDF 举报

身份认证购VIP最低享 7 折!

30元优惠券

"Toad for Oracle 10.1.1 用户指南"是一份由 Quest Software 公司于2010年发布的全面教程，专为 Oracle 数据库管理员和开发者设计。该手册详尽介绍了如何高效地使用 Toad 这一强大的数据库管理工具，以优化Oracle数据库的管理和开发工作。作为一款备受推崇的工具，Toad 提供了直观的界面，支持各种数据库操作，包括数据浏览、查询构建、数据导入导出、性能分析、SQL调试等。在本用户手册中，版权信息至关重要，强调了软件的专属性，并规定了使用许可的严格限制。只有在遵循软件许可协议或非披露协议的前提下，用户才能合法复制或传输此软件，且仅限于个人用途。未经 Quest Software 公司书面许可，不得进行任何形式的复制或传播。手册的核心内容涵盖了以下几个方面： 1. 软件概述：介绍了Toad for Oracle 的功能特性，如其易用性、可视化查询构建器、数据导航工具、以及对PL/SQL和SQL*Plus的增强支持。 2. 安装与配置：详细说明了如何在特定平台上安装和配置Toad，包括系统需求、许可证管理及初始化设置。 3. 数据管理：这部分包括数据查看、编辑、排序、分组和过滤，以及数据备份和恢复的操作指南。 4. SQL开发：指导用户如何编写、测试和优化SQL语句，以及利用Toad的代码提示和语法检查功能。 5. 性能分析：介绍如何使用Toad的性能分析工具，如SQL Tuning Advisor和Explain Plan，来识别并改进数据库查询效率。 6. 安全与权限管理：讲解如何处理用户认证、角色管理和访问控制，确保数据的安全性。 7. 高级功能：涉及Toad的高级特性，如脚本自动化、数据模型视图、数据字典浏览等，提升工作效率。 8. 故障排查与支持：包含了常见问题的解决方案和联系技术支持的途径，帮助用户解决遇到的问题。 9. 法律声明：明确指出 Quest Software 对其产品的责任范围，强调产品不附带任何默示保证，包括适销性和适合特定目的的保证。 Toad for Oracle 10.1.1 用户指南是一份极其实用的参考材料，无论是新手还是经验丰富的Oracle用户，都能从中找到所需的信息，提升数据库管理和开发技能。通过严格的版权保护，Quest Software 旨在保护其知识产权，同时也鼓励用户在其授权范围内合理使用这款软件。

资源详情

资源推荐

Toad for Oracle User Guide

Introduction

l Action Parameter files

l Actions can now accept parameter files. They are in INI format. Right click on an

Action/App in Automation Designer and choose "Create Parameter file" to build

an INI file based on the current Action properties. It will create property=value

pairs for the things which can be overridden. This parameter file can then be used

in the Automation Designer ('Run with parameter file') or on the command line by

using a pipe to separate the Action/App name from the filename. For example:

toad.exe -a "App->Export Dataset1 | c:\data

files\exportDataset1.ini"

l You will know which Actions can generate/read an INI file by whether or not the

'Create parameter file' popup menu item in Automation Designer is enabled.

Here is a sample section from an INI file which shows an Execute Script Action:

[47]

Name=Execute Script1

Type=Execute Script

ItemCount=2

Item0=c:\try1.sql

Item1=c:\try2.sql

Output=1 {1=SingleFile, 2=SeparateFile, 3=Clipboard, 4=Discard}

Output Location=C:\some folder\output.txt

ConnectionCount=2

Connection_1=mlerch@ora10gr2.world

Connection_2=scott@ora2gr2.world

[47] is an internal identifier. "Name" and "Type" are only for your use, to find your

Action within a longer App INI file. Each Actions INI section will be unique to

that Action, and in the case of things like enumerated types, will include

explanatory notes embedded within the line itself. In this example of 'Execute

Script,' two connections are specified. This will override the bound connection of

the Action. If that line wasn't there, the bound connection would be used.

The order of precedence for which connections get used:

1. Those specified on command-line always override everything else

2. If 1 is not present, those specified in an INI file are considered next

3. Finally, the connection bound to the Action is used if none are in 1 or 2

Alter Type

Altering a Type in the Schema Browser now loads the object in the Editor.

Toad for Oracle User Guide

Introduction

Application Data Folders

l The default installation directory for new installs enables roaming profile support. In the

View | Toad Options |General | Application Data Directory, the Use Default button now

points to your main application data folder. The Use Local Default button points to the

user's local application data folder, which does not support roaming profiles.

l You must restart Toad for a change in this option to become active.

Editor

l New menu item added to the main Toad Editor menu. "Split Size Horizontally" This item

will auto size the Editor so that there is equal space allocated for the edit control and the

bottom docking panels. The default shortcut is CTRL+F2. You will need to manually

add the item to the toolbar or reset your toolbar to see this if upgrading.

ERDiagram

l The ER Diagram has been expanded in Toad 10. This functionality is based on, and

works with, the Toad Data Modeler. Toad's ER Diagrammer is not meant to be a

modeling tool, but it can help you visualize complicated database structures.

l You can now see the objects included referentially when you add objects using

Referential Integrity:

l In addition, you can now subdivide your diagram into multiple workspaces.

l Separate objects into categories, and color code them, and add Model information to

the diagram.

l Use the Zoom and Snap to Grid features to organize your diagram.

l Create detailed reports in several formats, zip, and email them.

l Export diagrams to several different graphics files.

l With the appropriate Toad Edition, you can also create random test data for

selected objects.

l Create a diagram and send it to Toad Data Modeler for detailed modeling.

Grids

l Grids are now consistent throughout Toad. Some new features include:

Grids now share a single popup menu.

Reset Grid View restores the grid to the original configuration so you can undo

any groupings, bookmarks and so on with one selection.

Grids can handle block selection if row select is unchecked and multi-

select is checked.

Grids can be grouped by a column header by dragging the header into the Group

By area at the top of the grid. This feature can be toggled on the right-click menu.

Grids that had special functionality now have an upper toolbar containing that

Toad for Oracle User Guide

Introduction

l Variables can now be added within definition filenames in several of the Compare and

Generate windows. For example %DATEFILE% and %TIMEFILE% can be used to stamp

the date and time of creation (These are included in the default filename). Other user-

defined variables may also be added.

In the Professional, Xpert, Development Suite, and DBA

Suite Editions

Code Xpert

l Command line XML output now has an additional tag called comment_count to list the

number of comments in the code being analyzed.

Data Generation

l Enhanced data generation ability can now create more realistic data. Generators were

added to create various address, geographical, personal, and business data formats. Also

included is the ability to reference a foreign field, a hard-coded value, and the ability to

enter a custom SQL statement. Straight random and Unicode data are present.

l Three generator engines are supported:

Internal: This will create a script with "n" INSERT statements per table

(depending on the individual table's settings). An option is also available to

commit every "x" rows.

Caution: This will create a very large SQL script, which will take longer to

execute, but does not require any packages installed on the database server.

DBMS_RANDOM: This will use the DBMS_RANDOM package to generate

data, and is similar to the behavior in Toad 9.7. DBMS_RANDOM will need to

be installed on the database server for this option to be available.

TOAD_DATAGEN: This will use a TOAD-specific package to generate data on

the server. The advantage is that this will generate a much smaller SQL script, and

will perform faster.

Note: You will need to install the TOAD_DATAGEN package through Server

Side Object Wizard in order to use this feature. This package can be installed

locally, or in the global TOAD schema.

l Using Toad 10 you can create more meaningful random data for your tables. One way of

doing this:

In the Schema Browser, select the tables for which you want to generate data.

Right-click and select Generate Data.

Set General options, including Data Generation Engine.

Click on a table or column node and set options specific for that node. All options

剩余1072页未读，继续阅读

Lylonsan

粉丝: 1
资源: 1

Oracle Toad 10.1.1操作手册：全面指南

toad中文操作手册

TOAD for ORACLE 的使用说明

toad使用手册-toad使用手册-toad使用手册

toad data modeler中文手册怎么

toad for oracle使用手册

toad包 安装报错，ModuleNotFoundError: No module named 'toad.merge' ？

pycharm怎么安装toad

toad.selection.select报错no model named toad.merge

python toad mac 安装

toad for db2 6.3

toad compare data wizard

TOAD使用.doc

toad for oracle 汉化包

toad配置oracle客户端

toad for oracle 12 汉化包

toad for oracle 12.5

toad for oracle使用教程

toad for Oracle怎么使用

Toad for DB2 安装

toad for oracle安装教程

最新资源

toad包安装报错，ModuleNotFoundError: No module named 'toad.merge' ？