Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page