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

try using the oracle copy command

Prem Gadey 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.
>
> I am wondering if there are any tools to copy from one table and write
> to the other (existing table with same structure) pretty fast like
> sqlldr.
>
> sqlldr works only with the data files. spool in Oracle creates not just
> data but all other commands which cant really be used to insert
> directly. If there is some utility to write to file other than spool and
> then I can use sqlldr, that may be good too.
>
> export/import do not work on tables in the same database.
>
> Any hints would be appreciated.
>
> Thanks.
>
> --
> With regards,
> Prem
>
> "Thomas J. Kyte" wrote:
> >
> > In article <38BD6F5F.C63D3BC7_at_nortelnetworks.com>,
> > User Name <UserName_at_nortelnetworks.com> wrote:
> > > Hi,
> > >
> > > Is there any Oracle/3rd party tool/utility to copy data from one table
> > > to the other (existing with the same structure) on the same (Oracle
> > > 8.1.5) database.
> > >
> >
> > do you mean like:
> >
> > create table as SELECT .....
> >
> > > Thanks in advance.
> > >
> > > --
> > > With regards,
> > > /Prem
Received on Thu Mar 02 2000 - 00:00:00 CST