Show TOC

Importing Data and/or Information from the Database CatalogLocate this document in the navigation structure

Context

Import Types

You can choose between different import types:

  • Import Database

  • Import User

  • Import Schema

  • Import Table

Figure 1: Import Types

Default Export Directories of Database Studio

  • Microsoft Windows:

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

    Example

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

  • 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.

    • 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 Start of the navigation path Export/Import Next navigation step Import End of the navigation path.

    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.

    • 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 Start of the navigation path Export/Import Next navigation step Import End of the navigation path.

    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, the database catalog, 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.

    • 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 Start of the navigation path Export/Import Next navigation step Import End of the navigation path.

    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, information from the database catalog, 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.

    • 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 Start of the navigation path Export/Import Next navigation step Import End of the navigation path.

    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

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

    5. Select the package.

      Choose whether you want to import the application data, the database catalog, 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 Start of the navigation path Export/Import Next navigation step Import End of the navigation path.

    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.

      Option

      Description

      Import catalog

      Specifies whether the table definition is imported from the database catalog

      Import 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.

Next Steps

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