Database Import (ORCL)

From DBArtisan
Jump to: navigation, search

Go Up to Data, Schema, and Miscellaneous Utilities

DBArtisan provides comprehensive graphical support for the Oracle Import Utilities. DBArtisan offers a simple wizard that guides you through the process of extracting object definitions from an Oracle Export file and inputting them into the database. The Oracle Import utility only reads export files created with the Oracle Export utility. DBArtisan's Import Wizard ensures that the proper parameters and privileges are used, provides access to desired database information and resolves version compatibility differences.

The Import Wizard supports all four import modes:

  • Table
  • Users
  • Full Database
  • Point-in-time Recovery (available in Oracle8)

The Oracle Import utilities build database objects in the proper sequence to avoid dependency problems. Tables are created first, then table data is input into the proper tables, next indexes are built, then triggers are imported and finally integrity constraints are built.

Note: If you do not have the EXP_FULL_DATABASE role assigned to you, you may not be able to access all the functionality of the import wizard.

Starting the Import Wizard

  1. Ensure that the path and name for the Oracle Import utility is specified in the Oracle Utilities tab of the Options Editor. For details, see Oracle Utilities Options.
  2. Connect to the datasource where the database to be imported is located and ensure that it is the selected datasource. For details, see Connected/Selected Datasource options.
  3. Select Utilities > Database Import. The Data Import Wizard opens.
  4. Use the topics below as a guide to providing information as you walk through the pages of the wizard:
  5. When ready, click Execute.

Database Import Wizard - Panel 1

The first panel of the Import Wizard asks you to specify the target datasource and to name an existing import parameter file or use the existing Oracle default parameter file.

The table below describes the options and functionality on the first panel of the Data Import Wizard:

Option Description

Into which database would you like to import data?

Click the list, and then click the database.

Edit an existing parameter file

Type the location and name of the parameter file or click the browse button to find the file.

Default values

To use the Oracle default values for the parameter file, leave this box blank.

Database Import Wizard - Panel 2

The second panel of the Import Wizard lets you specify the export file from which the data should be imported. You must also select the import mode you want to use which determines the database objects that DBArtisan imports. The table below describes the objects, related objects and structures that are imported for each mode:

Mode Object Types and Structures

Table

Table definitions, object types defined on the table, table data by partition, nested table data, indexes defined on the table, table constraints, table permissions, column and table comments, table analysis information, triggers that refer to the table, and auditing information.

User

Libraries, object types, database links, sequence numbers, cluster definitions, table definitions, object types defined on the table, table data by partition, nested table data, indexes defined on the table, table constraints, table permissions, table analysis information, column and table comments, private synonyms, stored procedures, functions, packages, auditing information, views, cluster analysis information, referential constraints, triggers, snapshots, and snapshot logs.

Full Database

Tablespace definitions, tablespace quotas, profiles, user definitions, roles, role privileges, system privileges, resource costs, rollback segment definitions, database links, sequence numbers, directories, libraries, object types, cluster definitions, password information, default and system auditing, object type tables, table definitions, table data by partition, nested table data, table indexes, table constraints, table privileges, table analysis information, column and table comments, auditing information, synonyms, views, stored procedures, functions, packages, triggers, cluster analysis information, snapshots, snapshot logs, refresh groups and children.

Point-In-Time (available in Oracle8)

Tablespaces.

The table below describes the options and functionality on the second panel of the Data Import Wizard:

Option Description

Specify the export file from which you want to import data?

Lets you type the location and name export file to be used in the import operation, or find the file by clicking the Browse button.

Which database was used to create this export file?

Lets you choose the database used for export file creation from the list.

Which mode would you like to use for this export?

Lets you click the option button that corresponds to the import mode you want to implement. Table User Full Database Point-In-Time

Database Import Wizard - Panel 3

The third lets you specify which objects you want to import based on the mode you selected in the second panel of the Import Wizard.

The table below describes the options and functionality on the third panel of the Data Import Wizard for Table mode:

Option Description

Select the tables and/or partitions you would like to import

Displays a list of available tables. Lets you click the Owner list, and then click the owner.

Tables

To In the box, select the check boxes that correspond to the tables you want to import. If a table has partitions, click the check boxes that correspond the partitions you want to import. To select all tables, click the Select All button.

The table below describes the options and functionality on the third panel of the Data Import Wizard for User mode:

Option Description

Select the users whose objects you would like to import

To display list of available users, select the check boxes that correspond to the objects you want to import. To select all objects, click the Select All button.

The table below describes the options and functionality on the third panel of the Data Import Wizard for Full Database mode:

Option Description

Would you like to perform an incremental import

An incremental operation imports all database objects that have changed since the last incremental, cumulative, or complete export operation.

Database Import Wizard - Panel 4

The fourth panel lets you specify options to import dependent objects, privileges and table data, and to create a file for index-creation commands.

The table below describes the options and functionality on the fourth panel of the Data Import Wizard:

Option Description

Check the objects you would like to import

Select the check box that corresponds to the object(s) you want to export. To import object privileges, click the Grants check box. To import table data, select the Rows check box.

To import indexes associated with the tables, select the Indexes check box.

Would you like to skip unusable indexes?

Lets you click the Yes or No option button.

Would you like specify a file to receive index-creation commands?

When this parameter is specified, index-creation commands for the requested mode are extracted and written to the specified file, rather than used to create indexes in the database. Tables and other database objects are not imported. If you clicked the Yes option button, type the location and name of the file or find the file by clicking the Browse button.

Database Import Wizard - Panel 5

The fifth panel of the Import Wizard lets you:

  • Set the data rows transfer buffer size.
  • Indicate if the import operation should commit after each array insert.
  • Specify the option to re-use existing data files.
  • Specify the option to ignore creation errors.

The table below describes the options and functionality on the fifth panel of the Data Import Wizard:

Option Description

Would you like to accept your platform's default value for buffer size used to fetch rows?

If you select the No option button, in the Specify length box, type the KB value of the length. The highest value you can specify is 64 KB.

Should Import commit after each array insert?

Lets you select the No or Yes option button.

Would you like to reuse the existing datafiles making up the database?

Select Yes to set the reuse option in the datafile clause of the CREATE TABLESPACE command.

Should Import ignore object creation errors when attempting to create database objects?

Select Yes if you selected Table as your mode of import in panel 2, and the tables exist in the database in the target database.

Database Import Wizard - Panel 6

The sixth panel of the Import Wizard lets you specify:

  • The length of the file record.
  • How you want to implement SQL Analyze statements contained in the export file.
  • To view the contents of the export file rather than import the database information.
  • To view the progress meter.

The table below describes the options and functionality on the sixth panel of the Data Import Wizard:

Option Description

Would you like to show the contents of the export file rather than import them?

Lets you select the No or Yes option button.

Would you like to view the progress meter as rows are imported

Lets you enter the number of rows per dot displayed in the meter box, type the value of the number of rows per dot you want displayed in the meter.

Would you like to accept your platform's value for BUFSIZ as the length of the file record?

If you select the No option button, in the Specify length box, type the KB value of the length; the highest value you can specify is 64 KB.

Would you like to accept your platform's default value for the buffer size used to fetch rows?

Note: This option is only valid if you are performing a conventional path export. If you click the No option button, in the Specify Size box, type the KB value of the length; the highest value you can specify is 64 KB.

Would you like Import to execute SQL Analyze statements found in the export file?

Lets you select the No or Yes option button.

Database Import Wizard - Panel 7

The seventh panel of the Import Wizard lets you specify names and locations for the parameter and logfiles. If you importing from an Oracle 6 export file, you can define the character set of the original file.

The table below describes the options and functionality on the seventh panel of the Data Import Wizard:

Option Description

Character Set

For Oracle 6 export files, type the character set of the original file.

Logfile Button

Click to capture informational and error messages, and then type the location and name of the logfile in the corresponding box. Export logfile names use the *.logfile extension. (for example, C:\Temp\EXPLOGBerlin.log).

None Button

Click if you do not want to capture informational and error messages.

Parameter File

If you expect to perform the same export operation again, type the location and name of the parameter file in the corresponding box. Parameter files are stored as .txt files. (for example, C:\Temp\EXPPARBerlin.txt).

Database Import Wizard - Panel 8

Review the data import operation description to verify its accuracy.

Completing Panel 8

Review the import operation description to verify its accuracy.

  1. If you need to make any changes, click Back to scroll back to the appropriate panels of the wizard to make your corrections.
  2. If you are satisfied with the import operation, click Execute.
    DBArtisan starts the Import operation.
Retrieved from "https://docwiki.embarcadero.com/DBArtisan/170/e/index.php?title=Database_Import_(ORCL)&oldid=4537"