Toad for Oracle Unleashed

Generate Schema Script

A fairly common database administrative task is to generate a script for all the schema-level database objects (that is, those owned by a schema, and not by the database or PUBLIC). For example, you might want to copy the SCOTT tables, indexes, sequences, views, procedures, functions, and packages from the development environment to the test environment. To do so, you want an easy way to generate the DDL for that collection of schema-level objects. Toad offers the Generate Schema Script screen for that purpose.

To launch the Generate Database Script screen, choose Main Menu → Database → Export → Generate Schema Script. The screen shown in Figure 9.25 appears.

FIGURE 9.25 Generate Schema Script—Source and Output

This ...