Regrettably database engines, like everything else it seems, have differences. What is one case is a strength is in another a weakness. Those are just the facts of life. What you end up with is a compromise between all of them. Now if you'll excuse me, I've a SQL*server 2000 system to go put back together. Darned this corrupted itself when the server crashed. Funny thing though, 10 Oracle instances crashed too, power problem in the computer room, but they all survived. -----Original Message----- From: Dominik Smatana [mailto:dominik.smatana@xxxxxxxxx] Sent: Monday, November 21, 2005 12:53 PM To: oracledba.williams@xxxxxxxxx Cc: Goulet, Dick; gints.plivna@xxxxxxxxx; dominik@xxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: SELECT INTO new_table Thanks for all answers, my opinion: Oracle is VERY static database, we are developing total DYNAMIC application (MS SQL 2000 - no problems, Oracle 9.2i -> uuuuuffff!) :-) On 11/21/05, Dennis Williams <oracledba.williams@xxxxxxxxx> wrote: > Dick, > > I totally agree with your statement about changing the approach from > other databases. > Maybe I'm missing something here. Oracle 8i introduced Global > Temporary Tables and if I'm not mistaken Oracle9i improved the > concept. Would this help Gina? > > http://www.oracle-base.com/articles/8i/TemporaryTables.php > > Dennis Williams > > On 11/21/05, Goulet, Dick <DGoulet@xxxxxxxx> wrote: > > Gina, > > > > Regrettably this is one place where Oracle has something to > > learn from their open source competition. > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l