Procedure documentationImporting Data and/or Information from the Database Catalog Locate this document in the navigation structure

 

Import Types

You can choose between different import types:

  • Import Database

  • Import User

  • Import Schema

  • Import Table

This graphic is explained in the accompanying text.

Import Types

Default Export Directories of Database Studio

  • Microsoft Windows:

    <user_home>\sdb\loader\packages\export\<computer_name>\<database_name>\<time_stamp>

    Example Example

    C:\Users\anna\sdb\loader\packages\export\PARMA\DEMODB\20061220093349

    End of the example.

  • Unix and Linux:

    <user_home>/.sdb/loader/packages/export/<computer_name>/<database_name>/<time_stamp>

Procedure

Importing a Database
Prerequisites

  • The database is in the ONLINE operational state.

  • The data and/or the information from the database catalog was exported using the Export Database function in Database Studio or using transport mode in the Loader. More information: Loader, Transport Mode

  • You are logged in as the database system administrator.

Procedure

  1. In the explorer tree, select the database into which you want to import the table.

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

  3. Select Import Database.

  4. Enter the package file directory that contains the data or the information from the database catalog that is to be imported.

  5. Select the package.

    Choose whether you want to import the data (application data), the information from the database catalog, or both.

  6. To start the import, choose Finish.

Result

After the import, the passwords of all imported users are reset to INITIAL. Assign new passwords after the import.

Importing the Database Objects of Users
Prerequisites

  • The database is in the ONLINE operational state.

  • The data and/or the information from the database catalog was exported using the Export User function in Database Studio or transport mode in the Loader. More information: Loader, Transport Mode

  • You are logged in as a database user who is to be the owner of the imported database objects.

Procedure

  1. In the explorer tree, select the database into which you want to import the table.

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

  3. Select Import User.

  4. Enter the package file directory that contains the data or the information from the database catalog that is to be imported.

  5. Select the package.

    Choose whether you want to import the application data (data), the database catalog (table definitions), or both.

  6. To start the import, choose Finish.

Result

The tables and/or the information from the database catalog is imported into the target database and now belongs to the logged in user.

Importing Schemas
Prerequisites

  • The database is in the ONLINE operational state.

  • The data and/or the information from the database catalog was exported using the Export Schema function in Database Studio or using transport mode in the Loader. More information: Loader, Transport Mode

  • In the source database, you are logged in as the schema owner.

Procedure

  1. In the explorer tree, select the database into which you want to import the table.

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

  3. Select Import Schema.

  4. Enter the package file directory that contains the data or the information from the database catalog that is to be imported.

  5. Enter the name of the target schema.

    Select the package.

    Choose whether you want to import the application data (data), information from the database catalog (table definitions), or both.

    If the target schema name already exists, select whether you want to substitute the existing schema or add the import data to the existing schema.

  6. To start the import, choose Finish.

Importing Tables from a Loader Export Package
Prerequisites

  • The database is in the ONLINE operational state.

  • The data and/or the information from the database catalog was exported using the Export Table function in Database Studio or using transport mode in the Loader. More information: Loader, Transport Mode

  • You are logged in to the database as the user who has exported the table.

Procedure

  1. In the explorer tree, select the database into which you want to import the table.

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

  3. Select Import Table.

  4. Select Use existing export package files for import.

    Enter the name of the target schema.

    Enter the package file directory that contains the data or the information from the database catalog that is to be imported.

    Example Example

    C:\Users\anna\sdb\loader\packages\export\PARMA\DEMODB\20061220093349

    End of the example.

  5. Select the package.

    Choose whether you want to import the application data (data), the database catalog (table definitions), or both.

  6. To start the import, choose Finish.

Importing Tables from Other Sources
Prerequisites

  • The database is in the ONLINE operational state.

  • The data and/or the information from the database catalog was exported using the Export Database function.

  • The data is available in a suitable data format. More information: Loader, Data Stream

  • You are logged in to the database as the user who has exported the table.

Procedure

  1. In the explorer tree, select the database into which you want to import the table.

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

  3. Select Import Table.

  4. Select Use flat files for import.

    Enter the location of the files that contain the data or the information from the database catalog that is to be imported.

  5. Choose your import options.

    Options for Importing Tables from Flat Files

    Option

    Description

    Import table definition

    Specifies whether the table definition is imported from the database catalog

    Import table data

    Specifies whether data (application data) is imported.

    Format

    Export format

    Preview

    Select this option if you want to display a preview in the next step.

    One LOB file per column

    One LOB file per LOB value

    Specifies how LOB files are to be imported

  6. A preview is displayed.

    To switch the column headers of two columns, press the CTRL key and drag one of the column header to its new position.

  7. To start the import, choose Finish.

More Information

For a detailed description of all prerequisites and options, see the Loader documentation: Importing: Loader Commands.