1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Triggering across versions of Oracle

Discussion in 'SQL PL/SQL' started by eustet, Sep 11, 2009.

  1. eustet

    eustet Guest

    Can I use triggers created on the V8 Oracle database to move the data to other versions of Oracle such as 9i or 10g?

    Thank you for your time
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You'll need to use the Oracle 10 client to do that, as connections from the 8 client to 10 are not supported.
     
  3. debasisdas

    debasisdas Active Member

    Messages:
    46
    Likes Received:
    3
    Trophy Points:
    90
    Location:
    Bangalore, India
    Yes you can do that , but why you need a trigger for all that. There are other better ways for achieving the same.