Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SELECT INTO new_table
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_at_gmail.com]
Sent: Monday, November 21, 2005 12:53 PM
To: oracledba.williams_at_gmail.com
Cc: Goulet, Dick; gints.plivna_at_gmail.com; dominik_at_ttsm.net;
oracle-l_at_freelists.org
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_at_gmail.com> 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_at_vicr.com> wrote:
> > Gina,
> >
> > Regrettably this is one place where Oracle has something to
> > learn from their open source competition.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 21 2005 - 12:33:32 CST
![]() |
![]() |