-
I have a flat file of data and I want to insert that into a table.
How can I do that. Doing an insert sql statement wouldnt be feasible since ive got about 1000s of records to be inserted.
Thanks in advance.
-
check out Oracle documentation on SQL*Loader, or if you're more comfortable you could just write a script that creates insert statements from the flatfile, just make sure to commit after a certain batch size so you don't overload a rollback segment.
-
You should consider the size & type of the flat file also. If it is going to be binary data use BLOB type which can store 4GB of data. If it is a ascii file use LOB type column.
AD
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|