External Tables and Trigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: External Tables and Trigger

  1. #1
    Join Date
    Feb 2005
    Location
    Luxembourg
    Posts
    28

    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

  2. #2
    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 05:31 AM.
    Oracle Version: 9.2.0.1.0
    OS Client & Server: Windows XP Pro

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Why do you need a trigger and view to insert external table rows into another table?

    Just use simple insert statement.

    Tamil

  4. #4
    Join Date
    Feb 2005
    Location
    Luxembourg
    Posts
    28
    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
  •  



Click Here to Expand Forum to Full Width