Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating temp tables in Oracle.

772715May 13 2010 — edited May 21 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2010
Added on May 13 2010
9 comments
3,450 views