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: How to copy large table between instances

Re: How to copy large table between instances

From: <fitzjarrell_at_cox.net>
Date: 24 Apr 2006 12:03:43 -0700
Message-ID: <1145905423.217154.263470@e56g2000cwe.googlegroups.com> 






0ktalmagik wrote:


> Hi,




> I have a table with about 10 million records, and would want to copy it

> from one db instance to another. could anyone tell me what the fastest

> way(s) to do this is(are).





> thanks






Reading the manual at tahiti.oracle.com springs to mind ...



I'd search for information on exp/imp and COPY.



And stop posting to every newsgroup you can spell.




David Fitzjarrell
Received on Mon Apr 24 2006 - 14:03:43 CDT












Original text of this message













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