What is Toad schema and its objects used for and how to create these objects?
The Toad schema and its objects are created in order to use the following features in Toad. These objects are referred to as "Server-Side Objects".
- CodeXpert: Analyzes the code against a set of rules for best practices
- Data Generation: Generates test data from the Schema Browser, Database Browser and ER Diagram windows
- Explain Plan: Executes Explain Plan statement using Toad's Plan table
- Profiler: Used with Oracle's Probe Profiler API to profile existing PL/SQL applications and to identify performance bottlenecks
- Team Coding - Source control feature which can be used as Toad's Team Coding alone or in conjunction with a third-party version control system
- Space Manager - Part of the View Tablespaces window to collect data from tablespaces (required DB Admin license key)
- Security - Restricts Toad users from having access to specific Toad features.
In Toad for Oracle 10.x and older, each set of Server-Side Objects can be installed by running the Server Side Object Wizard via the Database | Administer menu of Toad. In addition to automatically creating these objects, this wizard also generates background SQL scripts which can be executed manually.
In newer versions of Toad for Oracle (11.x and higher), there is no specific Server Side Object Wizard.Each feature that requires server-side objects and/or the Toad user will run a check when the specific feature is launch. If the needed objects are note found, then Toad will prompt accordingly to set it up at that time. The create script can be reviewed at the end of any particular wizard.
