7 Loading Data from an Oracle Database into a TimesTen Database
SQL Developer allows you to load data using parallel threads from an Oracle database into a TimesTen database without creating a cache group or cache table.
Note:
SQL Developer uses functions from the ttLoadFromOracle
built-in procedure to load data from an Oracle database into a TimesTen database. For more information about the ttLoadFromOracle
utility, see "ttLoadFromOracle" in the Oracle TimesTen In-Memory Database
Reference.
This chapter provides information about loading Oracle database data into a TimesTen table.
Topics include:
Loading data from Oracle database tables
Before attempting to load data from an Oracle database into a TimesTen database:
-
Ensure that you are using Oracle TimesTen In-Memory Database Release 11.2.2.4 (or higher).
-
Ensure that you have specified the Oracle database connection information (Oracle Database Password and Oracle Net Service Name) for your TimesTen SQL developer connection. For more information on defining your TimesTen database connection, see Defining a TimesTen database named connection.
Ensure that you are on the main SQL Developer page and that your TimesTen connection is expanded.
Advanced
The advanced mode enables you to select the mapping of Oracle database data types to TimesTen data types and get data compression recommendations through compression analysis. Before using the advanced mode, ensure that you have completed all the steps from Loading data from Oracle database tables.
Note:
The data type mapping and compression settings set in this section are applied to all the tables that you load from the Oracle database.
Note:
You can click the Reset Factory Defaults button to set all configuration values to factory defaults.
Simple
The simple mode enables you to load data from the Oracle database without selecting the mapping of Oracle database data types to TimesTen. However, if you are using advanced mode, you can follow these instructions after specifying the mapping of your data types and compression.
If you are using advanced mode, ensure that you have completed all the steps from Advanced.
If you are using simple mode, ensure that you have completed all the steps from Loading data from Oracle database tables.
In this dialog you need to select the tables from which you want to load data from the Oracle database. By default, the dialog shows the tables from your Oracle database schema. Optionally, you can perform these operations to help you select tables from other database schemas:
If you do not want to select tables from other database schemas, you can move directly to the procedure for loading tables:
Add an Oracle database schema
To add tables from another Oracle database schema, follow these steps.
Remove an Oracle database schema
To remove an Oracle database schema, follow these steps. This only removes Oracle database schemas from being available for the Load from Oracle database feature. You cannot remove the Oracle database schema of the connection user.
Apply a filter to Oracle database schema tables
To apply a filter to the Oracle database schema tables, follow these steps.
Load custom query results
To load custom query results for an Oracle database schema, follow these steps.
Loading data from an Oracle database table into an existing TimesTen table
To load data from an Oracle database table into an existing TimesTen table, follow these steps. Ensure that you are on the main SQL Developer page and that your TimesTen connection is expanded.
Resume loading data from Oracle database tables
In some cases when you attempt to load data from Oracle database tables, you may run into some errors that prevent all data from being loaded from the Oracle database tables. If you saved the load profile after your load operation failed, you can resume the load operation using the load profile.
To resume loading data from an Oracle database table, ensure that you saved the load profile, that you are on the main SQL Developer page, and that your TimesTen connection is expanded.
You have successfully resumed loading data from Oracle Database tables.