Will an IMPORT fire database triggers? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Will an IMPORT fire database triggers?

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    hm I wish we can do import direct=true as well heh so I can get more sleeps

  2. #12
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    I got it imported eventually.

    Dropped the user (and their objects)
    Re-created the tables, sequences, functions etc.
    Did NOT re-create the constraints or triggers.
    Did the import - fine!
    Re-created the contstraints and triggers - and Hey presto! It works fine.

    But there must be an easier way? If people use exports as a sort of back-up do they have disable constraints and db triggers to get the data back into the db?

    Thanks anyway Guys

    JMac

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