Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: insert into select ... very very slow

Re: insert into select ... very very slow

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Tue, 23 Apr 2002 15:08:47 GMT
Message-ID: <3CC578EF.47D41666@exesolutions.com>


bruno nogent wrote:

> I'm testing to insert into a table the datas of a select statement
>
> insert into mytable select ......
>
> but it's very very slow
> The table to copy is : 200 lines and 50 columns
>
> Where is the problem ?
>
> Thanks

The problem is that you don't have any hardware.

You don't have an operating system
You don't have a version of Oracle installed on the machine
You don't have a SQL statement

And you don't define 'very very slow'

The group's crystal ball is broken this century. If you want help give us something to work with.

Daniel Morgan Received on Tue Apr 23 2002 - 10:08:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US