Re: Oracle to Informix migration

Posted in 2005

Topics: Stored Procedures & SPL, Triggers, Constraints & Referential Integrity, Migration, Import/Export & Data Conversion

Joerg Volz — Tue, 5 Apr 2005 23:14:05 +0200 — source: Usenet: comp.databases.informix

"Richard Kofler" <richard.kofler@chello.at> schrieb im Newsbeitrag news:t3D4e.30983$zY6.19367@news.chello.at... > > Joerg, if you have some experience in using Perl I'd go the > DBI/DBD way. > Read the ORACLE FAQ, this should be a starting point on how to > use the meta information to at least know > - tables & their structure > - indexes > - views > > However, stored procedures triggers and such won't be that easy ..... > > dic_k > -- > Richard Kofler > SOLID STATE EDV > Dienstleistungen GmbH > Vienna/Austria/Europe Hallo Richard, I have little experience with PERL, but I will take a closer look to your suggestion. Thank good I only need the pure data. Thank you very much Joerg PS: falls ich das nicht geregelt bekomme melde ich mich bei euch... :-)

↪ replying to Joerg Volz

DA Morgan — Tue, 05 Apr 2005 22:23:57 -0700 — source: Usenet: comp.databases.informix

Joerg Volz wrote: > "Richard Kofler" <richard.kofler@chello.at> schrieb im Newsbeitrag > news:t3D4e.30983$zY6.19367@news.chello.at... > > >>Joerg, if you have some experience in using Perl I'd go the >>DBI/DBD way. >>Read the ORACLE FAQ, this should be a starting point on how to >>use the meta information to at least know >>- tables & their structure >>- indexes >>- views >> >>However, stored procedures triggers and such won't be that easy ..... >> >>dic_k >>-- >>Richard Kofler >>SOLID STATE EDV >>Dienstleistungen GmbH >>Vienna/Austria/Europe > > > Hallo Richard, > > I have little experience with PERL, but I will take a closer look to your > suggestion. > Thank good I only need the pure data. > > Thank you very much > > Joerg > > > PS: falls ich das nicht geregelt bekomme melde ich mich bei euch... :-) Go into Oracle using SQL*Plus and just do the following: SQL> set pagesize 0 SQL> set linesize <longest output row plus extra> SQL> set trimspool on SQL> spool /home/oracle/output.lst SQL> SELECT column_name || ',' || column_name .... FROM table_name; SQL> spool off Then load it as a CSV file. No programming required. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)