Unanswered: problem in sequence generator using SqlLoader
problem in sequence generator using SqlLoader in ORACLE 9i :
I've 2 input files and these two files will be loaded into a single table using 2 parallel sessions simultaneously. Now in this case , if each table has 100 records , the sequence of the table becomes 1 to 100 and then for second file again 1 to 100 . but it should be 1 to 200 . Can I set the RECNUM function to a specific value , so that it starts from a specific no , such as from 101.