Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import problem

Re: import problem

From: Dmitry Melekhov <dm_at_belkam.com>
Date: 5 Jan 2002 11:20:47 -0800
Message-ID: <48f1f058.0201051120.4c2d1f9e@posting.google.com>


s.kapitza <skapitza_at_volcanomail.com>
&#1054;&#1061;&#1068;&#1045;&#1056; &#1041; &#1071;&#1053;&#1053;&#1040;&#1067;&#1045;&#1052;&#1061;&#1061;:26703915.0201050913.4073e17a_at_posting.google.com...
> hi dmitry
>
> i had the second error once.
> Someone renamed a table with a trigger.
> The Table was renamed, but it seems the Trigger was "residing"
> on the old tablename , all went fine
> until the next export/import.
> we had to extract the triggersource from the
> destination database , rewrite the triggersource for the new
> tablename and aplied it to the target database.
>
> maybe this is the same problem with your db.
>

Thank you for reply!

I see in import log that table was imported. And I can do select from it.
Very strange but true... :(

> > IMP-00003: ORACLE error 25001 encountered
> > ORA-25001: cannot create this trigger type on views
> > IMP-00017: following statement failed with ORACLE error 25001:
> > "CREATE TRIGGER RUTJOURNAL.AR_&#1056;&#1055;&#1056;_JN"
> > " AFTER DELETE OR INSERT OR UPDATE"
> > " ON

&#1056;&#1059;&#1058;_&#1056;&#1040;&#1057;&#1061;&#1054;&#1044;&#1067;_&#10 47;&#1040;_&#1055;&#1045;&#1056;&#1048;&#1054;&#1044;&#1067;"
> > " FOR EACH ROW"
Received on Sat Jan 05 2002 - 13:20:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US