We are using SQL developer for this activity. In SQL developer, we were using offline data migration method to unload/load data from DB2 to Oracle. As part of this when we unload the data from DB2, LOBs are getting created as separate files (in the db export command lobsinsepfiles option is used). If we use lobsinfile option instead of lobsinsepfiles withdb2 export command, all the LOBs get unloaded as a single file and data will be loaded as one file, so that we've only 2 files to move across database servers& easy to manage& migrate the data. In this case, how can we write controlfile for the sql loader to load data from single file.
In our case, we have records more than 100 millions and it'll generate 100 million of LOB files. Will it be a good solution to load 100 million files. I hope Operating System will not allow those many number of files get created under one directory.
Can you suggest us any other option for this.