Re: Oracle Trigger Problem

From: <ghoward_at_isx.com>
Date: Wed, 03 Apr 2002 23:03:12 -0500
Message-ID: <r0knauccvshf4pg2e2d6d5d1sl02hgq35o@4ax.com>

No, the import itself doesnt have any errors. The error occurs when I do an Insert into the table with the trigger. When the trigger is supposed to fire it says that it cannot resolve the trigger name. The schema name is test_context and the trigger name is TriggerClient. The error I get says that TEST_CONTEXT.TriggerClient cannot be resolved.

On 04 Apr 2002 02:49:09 GMT, sanjaykunal_at_aol.com (Sanjaykunal) wrote:

>Does it occur when you are importing the data ? If so, then please check the
>order in which you imported objects from the export dump file.
>
>If you import the table definitions and triggers first and then in the second
>run import the data you may have problems with triggers that go/verify against
>data in other tables.
Received on Wed Apr 03 2002 - 22:03:12 CST