Oracle: creating a temporary table using a SELECT statement

Question

I tried to mix the CREATE TABLE table_name AS SELECT .... statement with the GLOBAL outer table statement. They do not mix well.

Is my example wrong?

CREATE GLOBAL TEMPORARY TABLE a AS ( SELECT * from b ) ON COMMIT PRESERVE ROWS;

+7

Revious Mar 22 '13 at 12:03

source share

1 answer

Dazzal · Accepted Answer · 2013-03-22T12:07:57+0000

it should be:

 CREATE GLOBAL TEMPORARY TABLE a ON COMMIT PRESERVE ROWS AS select * from b;

(add where 1 = 0 too, if you do not want to fill it first for the current session with all the data from b).