Re: Oracle Trigger Problem

I think there is an issue with triggers and import in that if the trigger was created mentioning the schema name (create trigger mytrig on myschema.mytablename...) this ends up hard coded in the export file, and the "touser" option does not change it.

It seems to me that I had to export the trigger definitions using a separate tool, change the schema names, and reload them after using import.

-Peter

ghoward_at_isx.com wrote:
>
> 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 Thu Apr 04 2002 - 07:09:15 CST