DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: External Tables and Trigger

Threaded View

  1. 01-10-2006, 05:58 AM #2
    buck
    buck is offline Junior Member
    Join Date
    Feb 2005
    Location
    Luxembourg
    Posts
    28
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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