XPost: comp.databases.oracle.server   
   From: alistair@despammed.com   
      
   Why not use sqlldr to load the data from the text file into table2? You can   
   use the fixed column position or a delimiter to separate the data into   
   different columns.   
      
   Alistair   
      
   "Demetris"  wrote in message   
   news:c5285638.0402050340.3e482dc0@posting.google.com...   
   > Hello there!   
   > I have a table (table1) and one of its columns DATA_X is CHAR(660)   
   > I will create another table (table2) similar to the above but i will   
   > replace the DATA_X column with several columns (different data types)   
   >   
   > The table1 is populated with data using a text file.   
   > After the loading is finished on table1 i want to select all the data   
   > from table1 and load it in table2. The DATA_X must be split in several   
   > columns.   
   >   
   > How do i perform this?   
   >   
   > Thank you.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)