Re: Triggers are not imported

From: David Southerland <david.southerland_at_turner.com>
Date: Mon, 05 Nov 2001 15:58:52 -0500
Message-ID: <3BE6FD8C.3069B2CE@turner.com>

Just guessing here, but try running ORACLE_HOME/rdbms/admin/catexp.sql on both of your databases and then try the import again...

Nicolas Bronke wrote:

> 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
Received on Mon Nov 05 2001 - 14:58:52 CST