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

Home -> Community -> Usenet -> c.d.o.misc -> Re: From one DATABASE to another, not TABLE!

Re: From one DATABASE to another, not TABLE!

From: Shashank Tripathi <shanx_at_shanx.com>
Date: Tue, 23 Nov 1999 01:30:25 GMT
Message-ID: <3839ed93.992774@news.netvigator.com> 





One more idea: 



Use the UTL_FILE utility to write out a comma delimited file (CSV) and
then use SQLLDR80 to easily load this into your new database



This is especially useful if you wish to perform some processing on
the exported data before importing it back..



Gd luck!


Shanx



---


Shashank Tripathi


http://shanx.com



Received on Mon Nov 22 1999 - 19:30:25 CST












Original text of this message













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