Database Reference
In-Depth Information
Loading Data with the Data Workshop
Utility
Now that you have your two base tables defined, you can begin working to migrate the
old data into your shiny new data structure. You can use SQL Workshop's Data Work-
shop utility to load and unload data from an Oracle schema in a number of ways, as
shown in
Figure 4-9
. The Data Load option allows you to choose Text Data, XML
Data, and Spreadsheet Data.
Figure 4-9.
Data Load and Unload methods provided by the Data Workshop utility
Although three separate options are presented, the Text Data and Spreadsheet Data
options actually use the same Data Load Wizard. There is little or no discernible differ-
ence in the actions of the wizard regardless of which option you select.
The third option (XML Data) allows you to load data that has been exported in
Oracle's proprietary XML Data Transport format. The format looks like this:
<ROWSET>
<ROW>
<USER_ID>2</USER_ID>
<USER_NAME>DOUG</USER_NAME>
<PASSWORD>A69856770A9AB9CBB0479573FCB3E2A5</PASSWORD>
</ROW>
<ROW>
<USER_ID>3</USER_ID>
<USER_NAME>DAVID</USER_NAME>
<PASSWORD>E2E89134B8AC6E1FFC14139A6FB2C10B</PASSWORD>
</ROW>
</ROWSET>
