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:
external table specifies that the object is a remote table or view. external table is the default, so this clause is optional.
external directory specifies that the object is a directory with a path similar to the following: “/tmp/directory_name [;R]”. The option “R” indicates recursive
external file specifies that the object is a file with a path similar to: “/tmp/filename”
