How to create a table from a fixed length file?
dosullivan_328 <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <1974784.435091320771341312.JavaMail.SYSTEM@alvqcfw02> |
Message from: dosullivan_328 Is there a means to take a fixed length ascii file and build a sqlloader control file that could then in turn be used to build the Oracle target table? The sqlloader utility allows me to view the text file and mark the fixed length fields, however I need to have a target table already created to go any further. I thought in the past I could choose to just create a control file... Essentially looking for fastest way to get from file to table. Any help greatly appreciated, Thanks, Dan _______________________________________ Historical Messages Author: dosullivan_328 Date: Tue Nov 08 08:55:11 PST 2011 Is there a means to take a fixed length ascii file and build a sqlloader control file that could then in turn be used to build the Oracle target table? The sqlloader utility allows me to view the text file and mark the fixed length fields, however I need to have a target table already created to go any further. I thought in the past I could choose to just create a control file... Essentially looking for fastest way to get from file to table. Any help greatly appreciated, Thanks, Dan __ _______________________________________