Load Data from an Oracle Database into a TimesTen Database

SQL Developer allows you to load data from an Oracle database into a TimesTen database without creating a cache grid, cache group, or cache table.

Before attempting to load data from an Oracle database into a TimesTen database:

To load data from an Oracle database into a TimesTen database, make sure you are on the main SQL Developer page and that your TimesTen connection is expanded.

  1. Right-click the Tables option and select Load Oracle Tables.

    The Load Tables from Oracle dialog displays. Locate your Oracle database schema name from the navigation tree on the left of the Load Tables from Oracle dialog.

  2. Click the + located next to your Oracle database schema name to expand the Oracle database tables list.

    Your Oracle database schema expands showing a list of available Oracle database tables. Locate the Oracle database tables you want to load into the TimesTen database.

  3. Right-click the name of the Oracle database table that you want to load into the TimesTen database and select Load. You can repeat this step, including for the same Oracle database table, to load multiple Oracle database tables.

    If you want to load all of the Oracle database tables, right-click the Oracle database schema name and select Load All.The TimesTen Username dialog displays. Enter the TimesTen user for which you want to create the tables and click OK.

    Your selected tables are added to the right pane and are displayed in a table format.

  4. Review the selected Oracle database tables and edit any necessary fields. You can edit a field by double clicking it. A description of each column follows:

    • TimesTen Username

      The owner of the TimesTen table that you are creating. By default, this is the TimesTen connection user. You can edit this column. An error message is displayed if the specified table owner does not exist or the TimesTen connection user does not have privileges to access the specified table owner.

    • TimesTen Table Name

      The name of the TimesTen table that you are creating. By default, this is the same table name as the Oracle database table. You can edit this column.

    • Query to Run on Oracle

      The SQL query executed on the Oracle database to generate the desired result set. By default, this is a SELECT * FROM oracledb_tbl query, where oracledb_tbl is the Oracle database table from which you are loading data. This field is editable. For more information on valid Oracle Database SQL queries, see Oracle Database SQL Language Reference.

    • Row Count

      The number of rows that TimesTen loads from the Oracle database table. By default, this value is empty.

      To load Row Count for a specific Oracle database table, right-click on the Row Count field for your table, then select Count.

      To load Row Count for all the selected Oracle database tables, right-click on a Row Count field of any table, then select Count All. A confirmation dialog displays. Click Yes to continue with the row count of all of your previously selected Oracle database tables.

    • Create Table Statement

      The SQL statement that TimesTen uses to create the table to load your Oracle database data. You cannot edit this column. Review the CREATE TABLE statement by double clicking on the Create Table Statement field.

      If a TimesTen table with the same name already exists in the TimesTen database, the data from the Oracle database table is appended to the existing TimesTen table. TimesTen does not load table constraints from the Oracle database table. An error dialog displays if a TimesTen table with the same name but different table structure already exists in the TimesTen database.

    • Number of Parallel Threads

      The number of parallel threads that will be used to load the Oracle database table into the TimesTen database. By default, the value is four. You can edit this column. An error dialog displays if you attempt to use a number of parallel threads that is less than two.

    • Status

      The status of the data loading operation from the Oracle database to the TimesTen database. This value is empty before starting the load operation. Once you start the load tables from the Oracle database operation, this value can be IN PROGRESS, DONE, or FAILED.

    Locate the Load button in the bottom right of the Load Tables from Oracle dialog.

  5. Once you edit all of your desired fields, click the Load button.

    A progress dialog displays. Verify that each field of the Status column of the Load Tables from Oracle dialog is marked as DONE.

    If any Status field is marked as FAILED, make sure that all the data you entered is correct.

    If all of the Status fields are marked as DONE, your TimesTen tables are created and loaded with the Oracle database table data.

    Locate the Close button in the bottom right of the Load Tables from Oracle dialog.

  6. Click Close.

    You have successfully loaded data from the Oracle database to the TimesTen database.

Related Topics

SQL Developer: TimesTen Tasks

SQL Developer Concepts and Usage