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

Volker%20Barth's gravatar image

Volker Barth
29.6k293444650
accept rate: 32%

What is the point? Proxy tables don't contain any data, so the "permanent versus temporary data storage" difference between permanent and temporary tables doesn't apply. Is it the scope? You want the name FT to be visible only to the current connection? If so, you could use EXECUTE IMMEDIATE to include the @@SPID in the table name so the name would effectively be local to the current connection. IMO proxy tables already act like GLOBAL TEMPORARY TABLES because the data is provided by a secondary connection to another server, and that underlying connection exists only within the current client connection.

(18 May '11, 07:50) Breck Carter
Replies hidden

My point is primarily the opinion that "temporary stuff" should not have effect on the system catalog (and on the translog/recovery). Usually, I use proxy tables for general/long-lasting access of remote data. In this case, it's just for "testing purposes" - just like usage of the FORWARD TO statement... - Feel free to consider this an academical approach:)

(18 May '11, 08:00) Volker Barth

Volker,

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.

Karim

permanent link

answered 18 May '11, 07:46

Karim%20Khamis's gravatar image

Karim Khamis
5.6k53870
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×406
×106
×62

question asked: 18 May '11, 05:22

question was seen: 1,305 times

last updated: 18 May '11, 08:00