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: Export data from Mainframe to Unix solaris

Re: Export data from Mainframe to Unix solaris

From: Ron Reidy <rereidy_at_uswest.net>
Date: Wed, 26 May 1999 20:47:50 -0600
Message-ID: <374CB256.A16B9642@uswest.net> 







Seigmund Akinwande Johnson wrote:



> Hi,


> Does any one know if you can export data from mainframe to Unix or NT using


> oracle export command, and what are the issues to consider


>


> SAJ




Yes, exp will do this.  Remember to ftp the file in binary mode.



Another thing to consider...



The imp utility is slow.  You may be better off to use the CLIO/S util from IBM
and SQL*Loader to get the data into the database.



--


Ron Reidy


Oracle DBA


Reidy Consulting, L.L.C.


Received on Wed May 26 1999 - 21:47:50 CDT












Original text of this message













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