Re: Bug in import?

On Mon, 11 Aug 1997 11:07:02 +1000, email_at_bisinfo.com.au (Business Information Services) wrote:

>User called TOM.
>TOM accidentally deletes a package.
>TOM asks me to get it back for him.
>
>I create a user called TEMP_TOM and using the last export file I import
>user TOM to TEMP_TOM.
>I then restore the code from TEMP_TOM to TOM. So far so good.
>
>If I straight-away delete TEMP_TOM then everything is back to normal. If
>I don't delete TEMP_TOM then problems start happening with the triggers
>on TOM's tables! In fact suddenly I have twice as many!! eg. table
>TOMS_TABLE which had one "before insert" trigger now has two!!!
>
>If I then delete TEMP_TOM, TOM's table has one trigger again. Very
>strange.
>
>Is this a known bug or am I doing something wrong?
>

        The problem is in trigger code. The trigger code was created declaring the schema name. So, when you import to TEMP_TOM the trigger are being created in the TOM schema.

        Reengineer the triggers code to not declare the schema name in the creation.         

Best Regards,

--
Luis Santos
Banco InterAtlântico