-
External Tables and Trigger
Hi,
is it possible to use a Trigger with an external Table?
thanks.
Oracle Version: 9.2.0.1.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?
thanks...
Last edited by buck; 01-10-2006 at 06:31 AM.
Oracle Version: 9.2.0.1.0
OS Client & Server: Windows XP Pro
-
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...
Oracle Version: 9.2.0.1.0
OS Client & Server: Windows XP Pro
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|