First page Back Continue Last page Graphics

…External Tables

Notes:

This example demonstrates:
The definition of an external table using the dump file set created in the previous example. For this example, I used the OS to copy the dump files from my Windows server to my Linux server, and created the external table on the Linux server.
Importing the dump set with a CREATE TABLE AS SELECT statement and using the external table as the source. Therefore, I have successfully moved a Windows table to another server on another platform.
Problem (bug?) Report
Note that this statement:
SELECT * FROM WEBHITS_EXTERNAL
worked fine here. However, any reference to a column name in the SELECT list caused the following error:

Notes for this slide continue on the next page…