sqlldr: how put the name of the current datafile into a column ?
Hi all,i have to load a lot of csv-files into a table. That's simple and it works.
But i need to know the name of the datafile from which the row is loaded from.
I found a workaround here http://www.experts-exchange.com/Database/Oracle/10.x/Q_23597962.html
It works, but for every existing file it calls the sqlldr. So i got a lot of log-files, which i have to inspect.
I think that i have seen somewhere in the internet, that with 11g there comes a functionality to write the filename into a row. But today i'm searching and find nothing.
But i need to know the name of the datafile from which the row is loaded from.
I found a workaround here http://www.experts-exchange.com/Database/Oracle/10.x/Q_23597962.html
It works, but for every existing file it calls the sqlldr. So i got a lot of log-files, which i have to inspect.
I think that i have seen somewhere in the internet, that with 11g there comes a functionality to write the filename into a row. But today i'm searching and find nothing.
0