Toad Pocket Reference for Oracle, 2nd Edition

Database Administration

|

97

Database ➝ Export ➝ Source Code

The Source Code function exports the code for your

selected schema’s stored programs as SQL script files.

The Source Code Export window includes selection

options for choosing all the objects for a designated

schema. You can also limit the selection to source code

for all programs of a type—for example, all packages, all

procedures, all functions, all triggers, or all views. You

also can select from the options Create one file for all

objects or Each object to a separate file.

If you choose Group objects in the following files, Toad

will create separate files for all procedures, all triggers,

and so on.

If you select a single object type, an additional tab opens,

allowing you to choose specific objects to include or

exclude from the export. If you select all objects, tabs for

selecting and unselecting individual stored programs do

not display.

Database

➝ Export ➝ Table as Flat File

This function creates a flat file. By definition, a flat file is

a file that does not contain TAB characters or comma

characters (,) between values. A flat file also requires the

creation of a companion Specifications file, which defines

the table name, the table owner, how many lines in the

output file will be covered by a single record of data, the

columns of data, the line on which they will appear, the

starting column, and the length of each column of data.

This function ...