본문 바로가기

카테고리 없음

Toad For Oracle Versions



Quick Links:Key Benefits I Getting Started I More How-to

The Toad for Oracle (Quest) solution for departments gives faculty and staff the ability to minimize risks associated with database changes, maintain quality, and redirect time to more strategic tasks. Create high-quality, bug-free applications that are built to perform and scale in production while automating the routine tasks that can make you less proactive and productive.

Toad Pocket Reference for Oracle plsql 1st Edition by Jim McDaniel and Patrick McGrath, O'Reilly, 2002 (ISBN, ISBN 978-0-596-00337-1) Toad Pocket Reference for Oracle 2nd Edition by Jeff Smith, Bert Scalzo, and Patrick McGrath, O'Reilly, 2005 ( ISBN, ISBN 978-0-596-00971-7 ). Toad for Oracle's 64-bit version now lets you connect using 64-bit Oracle clients. Internet-free Toad Installation. Toad 11.6 introduces a secure, Internet-free Toad installation with a restrictive parameter used when installing Toad silently. The 'i' parameter of the RESTRICTIONS option ensures Toad does not access the Internet.

Licensed users can make use of tools used for application development, database development, or business intelligence and assist developers in deploying Oracle-based applications and web services on the Windows platform.

Key Benefits

  • Shorten development cycles by producing higher-quality code with fewer defects
  • Define, find, and protect sensitive data across all your Oracle databases
  • Implement consistent and repeatable processes and best practices
  • Pinpoint and resolve database performance inefficiencies quickly
  • Automate SQL optimization tasks, complex and routine database admin tasks, and scalable performance testing.

Get Started

Toad for Oracle products are available for purchase from PantherExpress. They are not available for personal purchase. To get started:

For

Choose the Toad for Oracle Product that is Right for You:

  1. Toad Data Point Professional Edition – $250/year* (Windows only)

    Seamlessly access more than 50 data sources—both on premises and in the cloud—and switch between these data sources with near-zero transition times. Connect, query, and prepare data for faster business insights. Easy data profiling and cleansing; simplified data federation slashes up to 50 percent of your time to routine data delivery and enables you to take a huge leap in being more data driven.

  2. Toad for SQL Server Development Suite – $300/year* (Windows only)

    With Toad for SQL Server, you get extensive automation, intuitive workflows, and built-in expertise to maximize productivity and reduce risk. This comprehensive toolset complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage many databases.

    Toad for SQL Server includes these features:

    • Compare and sync: Easily identify differences by comparing and syncing servers, schemas and data.
    • Group Execute: Enable a number of scripts to be executed against different servers at the same time.
    • Log Reader: Roll back transactions in the transaction log without restoring from a backup.
    • Job Manager: Manage the load on your database to improve efficiency.
    • SQL Optimizer: Conduct application performance tuning with automated query rewrites and optimization.
  3. Toad for Oracle Xpert Edition – $500/year* (Windows only)

    Toad for Oracle Xpert Edition provides you with all of Toad’s development, editing, debugging, and project management features, plus SQL Optimizer for Oracle. SQL Optimizer validates your database code to ensure the best-possible performance. It also enables you to proactively identify potential issues and optimize SQL automatically.

    Easily manage database changes, including configuration, upgrades, migrations, index creation, and more. Analyze and compare execution plans for multiple SQL statements in different database environments. This Oracle database tool helps you proactively identify SQL performance variations, perform SQL tuning, and pinpoint potential performance degradation.

  4. Toad for Oracle DBA Suite – $1,500/year* (Windows only)

    Simplify database administration with Toad DBA Suite for Oracle. This powerful solution solves a wide range of challenges related to general database administration, performance diagnostics, and performance tuning. Toad for Oracle DBA includes these additional features:

    • Simplify administrative tasks, including management of users, roles, infrastructure, and utilities
    • Diagnose and resolve database performance issues in real time
    • Identify problematic SQL statements directly from source code or execution in Oracle
    • Optimize SQL statements automatically through SQL rewrite and indexing
    • Automate many routine tasks, including schema compare, script execution, and reporting
    • Schedule and perform more than 200 checks of database health, performance, and security
    • Replay database workload to simulate production environment
    • Manage, synchronize, and deploy schema changes
    • Analyze and report on Recovery Manager (RMAN) backups for better control over your backup strategy
    • Connect to Toad World—without leaving Toad—to get answers from industry experts and interact with your peers

* Annual licenses must be renewed on July 1 of each year; includes home use rights.

Version

Purchase the Software:

This title is only available through an authorized purchaser for PantherExpress in your department or area:

  1. Go to my.pitt.edu, login using your University Computing Account username and password, then access the PantherExpress task on the right-hand side.
  2. Search for Toad for Oracle, then select your product form the list.
  3. Click Add to Cart.
  4. Enter each user's information, one user per line in the requested format (last name, first name, University Computing Account username), then click Add to Cart.
  5. A receipt is emailed to the user which contains download instructions and the license key to complete the installation process.

Trial versions of these Toad for Oracle products are available for first-time users at www.quest.com.

Watch a quick video overview to learn how Toad for Oracle works:

.

More Ways to Get the Most from Toad for Oracle:

Product Support

Where can I get additional information about Toad for Oracle?

Visit the Toad for Oracle website for complete information.

If I have a Toad for Oracle license, can I access additional learning resources?

Toad

Connect with the Toad user and developer community via Toad World.

Are there hardware requirements to run the Toad for Oracle applications?

Hardware requirements are located here.

How do I renew my license?

Pitt Information Technology will send departments a reminder with renewal costs. In order to receive upgrades, maintenance payments must be received by Sept 30.

Toad®for Oracle Editions

Version 10.1

Release Notes

November 11, 2009

Toad for Oracle is available in several different editions. Each of these comes packaged with additional Quest Products to expand your Oracle experience. In addition to these editions, the DB Admin module for the Toad executable may be added to any Toad Edition where it is not included. This document contains information regarding all of these components. Please refer to the components contained in the edition covered by your license.

Toad for Oracle Base Edition
  • Toad for Oracle
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad Data Modeler
  • Toad for Data Analysts

Toad for Oracle Professional Edition

  • Toad for Oracle – Professional
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad Data Modeler
  • Toad for Data Analysts

Toad for Oracle Xpert Edition

  • Toad for Oracle - Professional
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad Data Modeler
  • Toad for Data Analysts
  • Quest SQL Optimizer for Oracle

Toad Development Suite for Oracle

  • Toad for Oracle - Professional
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad Data Modeler
  • Toad for Data Analysts
  • Quest SQL Optimizer for Oracle
  • Benchmark Factory for Databases - Oracle Edition
  • Quest Code Tester for Oracle

Toad DBA Suite for Oracle

  • Toad for Oracle - Professional
  • DB Admin Module Add-on
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad Data Modeler
  • Toad for Data Analysts
  • Quest SQL Optimizer for Oracle
  • Benchmark Factory for Databases - Oracle Edition
  • Spotlight on Oracle

Toad DBA Suite for Oracle - RAC Edition

  • Toad for Oracle - Professional
  • DB Admin Module Add-on
  • Toad Group Policy Manager
  • Knowledge Xpert for PL/SQL
  • Knowledge Xpert for Oracle Admin
  • Toad Data Modeler
  • Toad for Data Analysts
  • Quest SQL Optimizer for Oracle
  • Benchmark Factory for Databases - Oracle Edition
  • Spotlight on Oraclewith RAC Option

To see what is new in each product, visit our Toad Editions page on ToadWorld, or view the release notes for each individual product.

To read the release notes for each product, click the links below:

  • Toad Group Policy Manager - Please note that while Toad Group Policy Manager is installed separately using the Quest Installer, it is a freeware component of Toad for Oracle, and therefore any Release Notes are included within the Toad for Oracle documentation.
Platform
  • 1 GHz Processor (Spotlight requires 1.2 GHz Processor)
Hardware
  • CD-ROM drive or internet connection (needed for installation only)
  • Mouse pointing device
  • VGA monitor, 1024x768 resolution, small fonts (Spotlight requires 1280x1024 or larger)
Memory
  • 512 MB RAM required, 1 GB recommended
Hard Disk Space

By Toad Edition

Edition
460
Toad for Oracle Base Edition
Toad for Oracle Professional Edition
550
Toad for Oracle Xpert Edition
Toad Development Suite for Oracle
820
Toad DBA Suite for Oracle
Toad DBA Suite for Oracle - RAC Edition

By Product

MB
Product
Toad for Oracle
4
Toad Group Policy Manager
Knowledge Xpert for PL/SQL and Knowledge Xpert for Oracle Admin
100
Toad Data Modeler
Toad Data Analysts
90
Quest SQL Optimizer for Oracle
Quest Code Tester for Oracle
120
Benchmark Factory for Databases - Oracle Edition
Spotlight on Oracle
Operating System
  • Windows 2000
  • Windows XP (32-bit and 64-bit)
  • Windows 2003 (32-bit and 64-bit)
  • Windows Vista (32-bit and 64-bit)
  • Windows 2008 (32-bit and 64-bit)
  • Windows 7 (32-bit and 64-bit)

Note: When running on a 64-bit operating system, you must use the 32-bit Oracle Client.

Note: In Windows Vista, you must use a logon with the Admin privilege or if you are logged on as a normal user, you must have the Universal Access Control (UAC) turned OFF.

ProductException Requirements
Toad Data Analysts

Does not support

  • Windows 2000
  • Windows 2003 (64-bit)
Spotlight on Oracle

Requires

  • Windows 2000: Service Pack 4 (or later)
  • Windows XP: Service Pack 1 (or later)
Toad Data Modeler

Requires

  • Windows 2000: Service Pack 4 (or later)

Does not support

  • Windows 2003 (32-bit and 64-bit)
  • Windows 2008 (32-bit and 64-bit)
  • Windows 2007 (32-bit and 64-bit)
Additonal Software
ProductSoftware
Quest SQL Optimizer for Oracle

For Windows 2000, 2003, or XP Professional, Microsoft’s .NET Framework 2.0 SP1 or SP2, or 3.5 is required. You must have either SP1 or SP2 for .NET Framework 2.0 installed. If you have only .NET Framework 3.0 installed, you must still install .NET Framework 2.0 and the service pack or you must install .NET Framework 3.5 (which includes .NET 2.0 SP1).

For Windows Vista, Windows 2008 and Windows 7, Microsoft’s .NET Framework 3.0 is required.

Toad Data Analysts

Microsoft .NET Framework 3.5 (Service Pack 1)

Note: The following conditions apply:

  • The .NET Framework Client Profile is not supported.
  • To run Toad Data Analysts, the .NET security policy must be set to unrestricted.
Database Software

Oracle Client

You must use the 32-bit Oracle client.

  • Oracle v8i Client (Net 8)
  • Oracle v9 Client (Net 9)
  • Oracle v10 Client (Net 10) or Instant Client v10
  • Oracle v11 Client (Net 11) or Instant Client v11.1.0.7

Server

  • Oracle versions 8.0.6; 8.1.7; 9i; 9iR2; 10gR1; 10gR2; 11gR1, 11gR2

Note: It is recommended that your client version be of the same release (or higher) as your database version. In addition, to take advantage of Toad for Oracle's new Unicode support, you must be working with Oracle client/server 9i or above.

Product Exception Requirements
Toad Data AnalystsRequires 9i or later
Quest Code Tester for Oracle Requires 9.2.0.4 or later
Spotlight on Oracle

Requires 9.2.0.4 or later

Requires SQL*Net 2.3.4 or later

Oracle Client/Server CompatibilityAll versions of the Oracle client are not necessarily compatible with all versions of the Oracle Server. If the version of the Oracle client you are currently using is not compatible with the version of the Oracle server where your database resides, the incompatibilities may cause errors within Toad for Oracle. For more detailed information about possible compatibility issues, see Oracle’s Metalinkarticle 207303.1 'Client / Server / Interoperability Support Between Different Oracle Versions'.

Get the latest product information, find helpful resources, and join a discussion with the Toad Quest team and other community members. Join the Toad World community at www.toadworld.com

Contacting Quest Software:

Emailinfo@quest.com
MailQuest Software, Inc.
World Headquarters
5 Polaris Way
Aliso Viejo, CA 92656
USA
Web
ToadWorldhttp://ToadWorld.com

Refer to our web site for regional and international office information.

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

Toad For Oracle 64 Bit

From SupportLink, you can do the following:

  • Quickly find thousands of solutions (Knowledgebase articles/documents).
  • Download patches and upgrades.
  • Seek help from a Support engineer.
  • Log and update your case, and check its status.

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.

The guide is available at: http://support.quest.com/pdfs/Global%20Support%20Guide.pdf.

©2009 Quest Software, Inc.

Oracle

ALL RIGHTS RESERVED.

Toad For Oracle Latest Version

This document contains proprietary information protected by copyright. The software described in this document is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable 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.

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656

Email: legal@quest.com

Refer to our web site for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, Aelita, Akonix, Akonix, AppAssure, Benchmark Factory, Big Brother, ChangeAuditor, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

Disclaimer

Toad For Oracle Free Version

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

Toad For Oracle Version Comparison

Tutorial