Re: Oracle to Informix migration

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)