Global Temporary Table

From: Buck Turgidson <remove-me_jc_va_at_hotmail.com>
Date: Sun, 18 Feb 2001 01:15:16 GMT
Message-ID: <EmFj6.3302$TD1.260245@bgtnsc05-news.ops.worldnet.att.net>

According to an Oracle Education book, a view between a GTT and a regular table are not allowed. However, I can do the following;

CREATE GLOBAL TEMPORARY TABLE emp_temp
( emp NUMBER, ename VARCHAR2(20), sal NUMBER)
ON COMMIT DELETE ROWS; CREATE TABLE my_table
( emp NUMBER, ename VARCHAR2(20), sal NUMBER, address VARCHAR2(50));

create or replace view my_view
as select a.emp,b.address
from emp_temp a, my_table b
where a.emp = b.emp;

A select against dba_objects shows the view as valid. Is this a bug, or is my training manual wrong? I am on the linux version of:

Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production Received on Sat Feb 17 2001 - 19:15:16 CST