Re: Where is a temp tables DDL stored?

From: Martijn Tonies <m.tonies_at_upscene-removethis.nospam.com>
Date: Wed, 14 Sep 2005 16:29:33 +0200
Message-ID: <11igcsd82n9g70d@corp.supernews.com>

> > Im on Win2k3 server Standard Ed.
> > Oracle9i ( 9.2.0.6 )
> >
> > Creating several temp tables that are transaction specific.
>
> WHY?
> This smell like a MS-SQLServer code being ported to Oracle.
> Only in rare case are temporary tables needed in Oracle.
>
> What problem are you really trying to solve?

From what I understood, temp tables in MS SQL Server are not at all the same as temp tables in Oracle.

-- 
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Received on Wed Sep 14 2005 - 09:29:33 CDT