Example: create external table emp (lname varchar(80), sid integer(6), fname varchar(80), id integer(6) not null, dob timestamp(6)) organization (loadtype='remote' SERVER='myserver' REMOTETABLE='mytablename' SCHEMA='myschema' WHERE='id > 1000');
create external table emp (lname varchar(80), sid integer(6), fname varchar(80), id integer(6) not null, dob timestamp(6)) organization (loadtype='remote' SERVER='myserver' REMOTETABLE='mytablename' SCHEMA='myschema' WHERE='id > 1000');
Note : We have tested this for Oracle 8i/9i/10g , SQL Server, Sybase and DB2.