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: Moving a large # of rows from one table to another ?

Re: Moving a large # of rows from one table to another ?

From: Richard Elliott <Richard.A.Elliott_at_WGP.TWC.COM>
Date: Tue, 25 May 1999 19:06:23 GMT
Message-ID: <01bea6e1$5a179560$4b03c896@isbarae.transco.twc.com> 





SQLPLUS Copy requires the source and dest tables to be in different
databases. The DBA''s here are not likely to create a new instance for just
one history table. I do use this approach for loading test and it works
great! Thanks, any more ideas ?



ethanpost_at_my-dejanews.com wrote in article <7iem35$50l$1_at_nnrp1.deja.com>...


> Try using the SQLPLUS Copy Command.  - Ethan



Received on Tue May 25 1999 - 14:06:23 CDT












Original text of this message













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