| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/3rd party tool/utility to copy data from one table to the other
What does "insert into table2 select" or "create table2 as select" have to do with table1's indexes? You mean since table1 has indexes, running the two SQL commands is slowed down?
Yong
In article <38BD97F1.94665430_at_nortelnetworks.com>,
Prem Gadey <prem_at_nortelnetworks.com> wrote:
> I mean "insert into table2 select * from table1", which works but
since
> my table2 is pretty huge with several indexes, it is taking very long
> time to complete the task.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Mar 01 2000 - 00:00:00 CST
 |
 |