Online Documentation for DB Extract for Oracle

Step 6 - Selecting tables for data extraction 


At this step you should select the tables from which data is to be extracted.

 

hs2114 - Step6 - Selecting tables for data extraction

 

 

In the Available data tables tree you can see the tables belonging to the schemas specified at the Selecting objects for metadata extraction step. Initially the tables are grouped schemas. You can change grouping by dragging column headers to the grey group boxes above the grids or cancel grouping by dragging them back to the grid headers. Additionally, you can use the Custom Filter dialog allowing you to set conditions for filtering data tables in the trees.

 

hs2111 - Step5-6 - Custom Filter

 

 

To select tables, move the items from the Available data tables tree to the Selected data tables tree. To cancel table selection, just remove it from the Selected data tables tree. Use the Move to Selected Move to Available Move all to Selected Move all to Available buttons or drag-and-drop operations to move the tables from one list to another.

 

Hint: To select multiple tables, hold down the Shift or Ctrl key while selecting the table names.

 

 

The context menus of the Available data tables and the Selected data tables areas allow you to browse the tables in the tree more effectively: you can expand/collapse the tables viewed in the tree or specify filter conditions within the Filter Builder dialog.

 

Step 4-5 - Context Menu

 

 

The Filter Builder dialog allows you to facilitate creating and applying filter criteria for the tables viewed in the trees. It is also possible to save filter criteria to an external *.flt file and load them from that file any time afterwards by using the Save as... and the Open... buttons.

 

hs2111 - Step5-6 - Filter Builder

 

 

When you are done, press the Next button to proceed to the next step of the wizard.