Re: Imp.exe and trigger

   I believe you have to run the export as a user with the EXP_FULL_DATABASE role in order to get the triggers. Normally system has the dba role which has that privilege, but you might check.

OR

   You actually may have exported the triggers but they are disabled after the import.

OR

   It's a long shot but the triggers may accidentally be owned by SYS. Van

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Jul 18 2000 - 00:00:00 CDT