Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Global Temporary Table
Hi Buck.
The book is wrong (alas there are more errors than that one ...). You can hook up the global temp table to anything you like (irregardless of the "on commit ..." clause).
Regards,
Dave Haas
"Buck Turgidson" <remove-me_jc_va_at_hotmail.com> wrote in message
news:EmFj6.3302$TD1.260245_at_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 - 20:22:20 CST