|
-
You could use the sqlldr to import the file on to oracle. One of the issues on using sqlldr is that the file has to be a flat one. So what you could do is that write a cron job that would flush the records into a flat file and then use the sqlldr to load it on to the tables. Fixed filed format of the flat file would help you to load the data into multiple tables in a single run.
Sam
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
|
Reply With Quote