Using the create proxy_table command

create proxy_table is a variant of the create existing table command. Use create proxy_table to create a proxy table, but (unlike create existing table) you do not specify a column list. CIS derives the column list from the metadata it obtains from the remote table.

The create proxy_table command creates proxy tables which automatically inherit all the columns, column names and datatypes of the external table using the following syntax:

create proxy_table table_name
[ external type ] at pathname

create proxy table allows external object type table, file and directory.The location information provided by the at keyword specifies the pathname to the remote object.

External type can be one of the following: