Creating the All-Important TOAD Schema
Strictly speaking, you do not have to create any database server-side objects in order to use TOAD. You can simply install TOAD on your PC and go on your merry way. But there are screens where a developer will require access to an Oracle explain plan table. For example, the SQL Editor window has a tab for displaying the explain plan for the current SQL statement. Thus TOAD will need access to a plan table in order to process and then display the resulting explain plan. You have three options here.
First, sometimes DBAs prefer to create a DBA schema-owned, general-purpose and shared explain plan table using Oracle’s scripts. So the steps to implement might look something like this:
- Connect as SYSTEM (or ...