Creating temp tables in Oracle.
772715May 13 2010 — edited May 21 2010Hi All,
It seems that I don't have enough privileges to create a queries with temp tables in it in oracle? Is this actually true that I need to be inlogged as sysdba for that? I'm coming fromm a sql 2005 and 2008 environment so I'm just asking. Also, if someone could show me a sample script of how to create a temp table would be much appreciated. Thx