Home > SQL Developer: TimesTen Tasks > Load Data from an Oracle Da...
To load data from an Oracle database table into an existing TimesTen table, follow these steps. Make sure you are on the main SQL Developer page and that your TimesTen connection is expanded.
Click the + located next to Tables to expand the TimesTen tables list.
The TimesTen tables list expands.
Right-click the name of the table and select the Table option, then select the Load from Oracle option.
The Load Tables from Oracle dialog displays. The Schema name, TimesTen Username, and TimesTen Table Name are auto-filled and you cannot edit these fields. Prepare to enter the SQL query and the Parallel Thread Count.
In the Select Query field, enter the SQL query to execute on the Oracle database. The result of the SQL query is loaded into your TimesTen table. For more information on valid Oracle Database SQL queries, see Oracle Database SQL Language Reference.
In the Parallel Thread Count field, enter the number of parallel threads that will be used to load the Oracle database table into the TimesTen database. An error dialog displays if you attempt to use a number of parallel threads that is less than two.
Click Load.
A progress dialog displays. Once TimesTen loads the data from the Oracle database table, the progress dialog closes. If you execute the query on a small Oracle database table, the progress dialog may close almost immediately.
Related Topics