Re: Flatfiles from oracle tables

In article <dtb.731904576_at_otto>, dtb_at_otto (David Bath) writes:
> GO.MSB_at_isumvs.iastate.edu writes:
>
>
> >This bounced from mail so am posting.
 

> >In article <1993Mar5.211729.12302_at_newsgate.sps.mot.com>,
> >beutel_at_chdasic.sps.mot.com (Jim Beutel) writes:
> >>

.
.
Stuff deleted
.

> Other ways (on UNIX) involve running an export file through strings(1)
> and then hacking the file produced. Basically you need to join all
> lines, avoiding those that start with "CREATE", "INSERT" et cetera. Use
> perl or awk to do the hacking. This will give you a SQL script.
>
>

I would ask David to try this suggestion of his 1st before recommending it. There is no way (that I know of, currently) where you can import or extract data
from an Oracle export to be imported into another DBMS.

This is because Oracle exports the data in their native format. They are not in
a form that is legible to the outside world. You may be able to extract the DDL
stamenents but not the data.

> --
> David T. Bath | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)
> Senior Tech Consultant | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
> Global Technology Group | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
> "The robber of your free will does not exist" - Epictetus

-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Invest Mgmt,Aust (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu_at_cmutual.com.au
 \_______/                   |PHONE:  +61-3-6418448       FAX:  +61-3-6076198