I've got a flat file with about 450 columns in it (from an old VSAM database) that I want to load into a huge Oracle table.
Can sqlldr automatically create this table for me?
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
You are doomed!!!
Life is a journey, not a destination!
Yes you can do one thing open that data base data in Excel Worksheet and Save as comma delimated text file then you can load from SQLLDR....
SQL Loader cannot create a table. But you can do like this. Convert that flat file as Excel worksheet. Import that excel sheet into Access Database as a table. From there you can export to an oracle database. Access DB can create a table in Oracle Database.
Click Here to Expand Forum to Full Width