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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/3rd party tool/utility to copy data from one table to the other

Re: Oracle/3rd party tool/utility to copy data from one table to the other

From: Prem Gadey <prem_at_nortelnetworks.com>
Date: 2000/03/02
Message-ID: <38BEC244.55B40A23@nortelnetworks.com>#1/1

copy command has a bug in 8.1.5, fixed in 8.1.6: when there any NULL fields, it throws an exception. Although I am not sure if this would have been any faster than the "insert into table1 select as * from table2".

--
With regards,
Prem

>paula perrin wrote:

>
> try using the oracle copy command
Received on Thu Mar 02 2000 - 00:00:00 CST

Original text of this message

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