Re: SQLLDR deprecated?

Paul, the movement of data into and out of the database in a delimited flat file format is very common and pretty much every major rdbms has a utility to do just that. 10g adds a new external table load option: data pump but still supports the sql load option. I do not see the option going away and since the basis for the option is sqlload I do not see it going away any time soon. And if it did conversion of sqlldr steps in OS script files to steps that run insert selects on external tables is not a difficult conversion.

The way I see the feature is to use OS scripts with sqlldr for tasks whose timing is controlled outside the database and to use external tables for those tasks that are best triggered from within the database.

Any possibility of not being able to use sqlldr is probably version 12 or farther away.

IMHO -- Mark D Powell -- Received on Wed Oct 12 2005 - 12:55:24 CDT