RE: How to create a table from a fixed length file?

Maybe going down this road?

http://www.dba-oracle.com/t_sql_loader_sqlldr_external_tables.htm

 

From: [email protected] [mailto:[email protected]] On Behalf Of
dosullivan_328
Sent: Tuesday, November 08, 2011 5:55 PM
To: [email protected]
Subject: [toad] How to create a table from a fixed length file?

 

  

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
__
_______________________________________