Procedure documentationImporting Data or the Database Catalog Locate this document in the navigation structure

 

You can import application data and the database catalog from files or pipes. They may have been exported from a database on a different operating system or hardware architecture.

Prerequisites

You are logged on to the database as a database user.

Activity

Prerequisites

Import the data exported by a specific user

You have exported the data using the corresponding Export command.

Import the data of a schema

You are the schema owner.

You have exported the data using the corresponding Export command.

Import application data and/or table definitions

You are the owner of the database objects to be imported.

You have either exported the data with the corresponding Export command or the data is available in the specified data format.

Procedure

  1. In the context menu of the database, choose   Export/Import   Import  .

  2. Select the import type.

    Import: Types

    Import Type

    Description

    Import Database

    Import all application data and the entire database catalog of a database

    Import User

    Import the application data and/or the database catalog that a specific database user has previously exported

    Import Schema

    Import the application data and/or the database catalog for the tables of a schema

    Import Table

    Import the application data and/or the database catalog of a table

  3. Enter the required data.

    Import: Options

    Option

    Description

    Database Name

    Name of the database whose data you want to import

    User Name

    Name of the user whose exported data you want to import

    Package Files

    Directory in which the packages to be imported are located (packages exported using Loader transport mode or Database Studio)

    Flat Files

    Directory in which the catalog and data files to be imported are located (they may have been exported or created using Loader, Database Studio, or with other tools)

  4. Select the package (if necessary).

  5. To start the import, choose Finish.

More Information