Oracle 10g Support

Toad 8 was considered tolerant of Oracle 10g meaning that it could connect and operate essentially as it does for the previous versions of Oracle. Prior versions do not connect to the 10g database.

Toad for Oracle Version 8.5 supports the 10g database further by exploiting many of the new features/functions introduced in 10g.


Rename Tablespace
Tablespaces can be renamed by Right-clicking in the schema browser.

Default Tablespace
The schema browser indicates default temporary and default permanent tablespaces, and they can be changed by right-clicking.

Tablespace Groups
Tablespace groups are supported in the create/alter tablespace windows, and in the create/alter user windows.

Segment Advisor/History
There is a complete screen in TOAD to interface with Oracle’s Segment Advisor.

Globally Hash Partitioned Indexes
These are supported in the Create and Alter index windows, and in ddl extraction.

Datapump Wizard
Toad supports the Oracle datapump in the Quest DBA module, with new data pump import and export wizards, and a data pump job manager.

Online Segment Shrink
Supported in the following screens:

Alter table

Alter snapshot

Alter snapshot log

Alter index

Undo Advisor
There is a complete screen in TOAD to interface with Oracle’s Undo Advisor.

Improved Job Scheduler – Monitoring
New Schema Browser Tabs
New Schema Browser tabs interface with the Oracle 10g Scheduler.

Scheduler Jobs

Job Classes

Schedules

Programs

Windows and Window Groups

Create/Alter windows
There are create and alter windows for all of the new Schema Browser tabs.

Support in Generate Schema Script and Compare Schemas
All of the new Oracle scheduler tabs are supported within Generate Schema script and compare schemas.

Recycle Bin
New schema browser tab with full support for recycle bin operations including flashback table and purging of recycle bin.

New Data Types
DOUBLE, FLOAT, BINARY_DOUBLE, BINARY_FLOAT Supported in data grids and create/alter screens.

Big File Tablespaces
Supported in create/alter tablespace screen.

Global Partitioned Indexes - Hash Partitioning
Supported in create/alter index screen and in script generation.

Instant Client
TOAD can connect using this client.

New Row Timestamp pseudo-column
Supported in data grids.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.