5 Jan
2008
5 Jan
'08
7:08 p.m.
In sql we have some problems in locate temp tables. If I create the following table: create global temporary t1(id int); If I do: select * from t1; or select * from tmp.t1; I can see the table. However, When I do alter table, copy into, create trigger, create index statements I cannot detect the table even if I use tmp.t1 Should I open a bug? Or there is a special reason for this? Regards, Romulo