Problem in creating temporary tables
Posted by:
Na Fazileh
Date: April 22, 2007 02:25AM
Hi
I'm new in create temporary table and when I run this statement:
create temporary table test.MyTempTable ENGINE=MEMORY SELECT * FROM `new table`;
But when I running this querey "select * from test.MyTempTable;",
I get this error message:
Table 'test.mytemptable' doesn't exist.
please help me to solve this problem.
Thanks a lot.
Subject
Views
Written By
Posted
Problem in creating temporary tables
8431
April 22, 2007 02:25AM
4639
July 11, 2007 05:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.