Oracle in a Nutshell

Export prompts

The interactive prompts for the Export utility follow. In contrast to several other chapters in this book, we’ve shown the defaults between the prompt and the entry marker (>) as they appear during the interactive session. For clarity, the defaults are shown in bold type (e.g., SYSTEM is the default username).

Username: SYSTEM >

Username for this export session.

Password:

Password for the username supplied.

Enter array fetch buffer size: 4096 >

Size of the array fetch buffer, which can affect performance. For more information about this prompt, see the BUFFER keyword in Section 13.2 later in this chapter.

Export file: expdat.dmp >

Name of the export file.

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Choice of the type of export. If you select U or T, Export will display additional prompts.

Export grants (yes/no): yes >

Specifies whether to export security grants with the export.

Export table data (yes/no): yes >

Specifies whether to include the actual table data in the export. If you do not include the table data, the export will simply export the definitions of the tables you specify.

Compress extents (yes/no): yes >

Specifies whether to compress the extents while performing the export. For more information about this prompt, see COMPRESS in Section 13.3 later in this chapter.

Export may not necessarily display all of these prompts in all types of exports. For example, if you do not supply the username and password, the program will prompt you for this information. ...