is it possible to use a Trigger with an external Table?
Oracle Version: 220.127.116.11.0
OS Client & Server: Windows XP Pro
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?
Last edited by buck; 01-10-2006 at 05:31 AM.
Why do you need a trigger and view to insert external table rows into another table?
Just use simple insert statement.
where would i use the simple insert statement, to do the insert into a table automatically (as soon as the external table is available)?