Execute SQL*Loader statements from client

[MetomEnTodo]

The best solution for me would be that a client application could sent to the server a SQL*Loader statement as if it were a regular SQL statement.

Is it possible?

thanx in advance,

[slimdave]

I infer from your question that you have files on the server and you want to initiate a SQL*Loader session from the client, right?

One simple methodology is to use 9i's "external table" feature, where the database can execute a query directly against an external flat file, sing SQL*Loader control file format statements embedded in a table definition.

[MetomEnTodo]

Hi slimdave,

many thanks for your help.

At last we decide to start the process from a main shell script, which is also the most reasonable, who gets the CSV files via FTP, then runs SQL*Loader, and at last runs the PHP-aplication to analiuze the imported data.

We can't use External Tables since we still use Oracle 8.1.7, but that's good to know. I work with 9i in other projects.

The matter came out because we develop on MySQL 4.x, then we'll migrate the DB to Oracle 8.1.7 . MySQL accepts statements similar to the content of a SQL*Loader control file, as if they were SQL statements, being sent from a PHP-application. This does not work with Oracle.

Bye,


Originally posted by slimdave
I infer from your question that you have files on the server and you want to initiate a SQL*Loader session from the client, right?

One simple methodology is to use 9i's "external table" feature, where the database can execute a query directly against an external flat file, sing SQL*Loader control file format statements embedded in a table definition.