Oracle in a Nutshell

Import prompts

The interactive prompts for the Import utility follow, with the defaults between the prompt and the entry market (>). As with the Export prompts, 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 import session.

Password:

Password for the username supplied.

Import file: expdat.dmp >

File to be imported.

Enter insert buffer size (minimum is 4096): 30720>

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.

List contents of import file only (yes/no): no >

Can be used to determine the contents of an import file without actually importing any of the data.

Ignore create error due to object existence (yes/no): no >

If an object being imported already exists, this setting controls how the Import utility responds. If the setting is ‘no', the default, the create error is reported, and rows for the object are not imported. If the setting is ‘yes', the create error is not reported, and the rows are imported. The object is never replaced if it already exists.

Import grants (yes/no): yes >

Specifies whether to import the grants in the export file.

Import table data (yes/no): yes >

Specifies whether to import the table data in the export file.

Import entire export file (yes/no): no >

Specifies whether ...