Oracle UTL_FILE function - Divide the file into equal parts?
I have a batch job I am running where I am writing a large amount of data to one file. I need to be able to split this file into 4 equal size parts before I ftp it due to it's large size. Is there anyway I can do this in Oracle? I cannot do the splitting while I am querying for the data because the data is always changing. That's why I need to split it after the data is written to the file. Any help would be appreciated!!!
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.