I'm quite sure this is not currently possible with v12.0.1:
create temporary existing table FT at '...';
My intent would be to use a proxy table just temporarily (and from a single connection), say to dump/compare the contents as in this question. With local tables, I would usually use a temporary table in this case. For proxy tables, that seems to be not possible.
Is there a way to do so? Otherwise, I'd like to ask for this as an enhancement request. IMHO, this would only make sense for already existing remote tables/views.
asked 18 May '11, 05:22
As you surmised, this particular feature is not available at the moment; but the feature request has been brought up before. I will add your vote to the already existing enhancement request.
answered 18 May '11, 07:46