Re: Triggers are not imported

"Nicolas Bronke" <nb_at_trinity.de> wrote in message news:9s6kt4$hjb$01$1_at_news.t-online.com...
> I imported a dumpfile (which has been exported using Oracle 8.0.5) into a
> 8.1.7.1.1 database. It worked nearly as expected, but then I had to
> recognoize, that the triggers are not imported. How could that be?
>
> If cause I created the triggers again using my scripts.
>
> The I tried to create a dumpfile. All tables are exported but at the end
> (after all tables has been exported) there comes the error 904, which
means
> invalid column name. But not which table or view or which column.
>
> Any idea hiw to find that out?
>
> Regards.
>
> Nicolas
>
>

ora-904 during import is in 99.5% percent of all cases caused by not running catexp.sql connected as internal.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address