External Tables and Trigger

Hi,

is it possible to use a Trigger with an external Table?

thanks.

ok, i just realize that it's not possible. Because Oracle won't do any inserts or other DML Operations on the External table.

But, to perfom my task, is it possible to create a View on the external table and using a INSTEAD OF Trigger to transform and copy the data to an internal Oracle table?

Am i'm missing something?

thanks...

Why do you need a trigger and view to insert external table rows into another table?

Just use simple insert statement.

Tamil

Hi,

where would i use the simple insert statement, to do the insert into a table automatically (as soon as the external table is available)?

thanks...