exp/imp - Problems with procedures and trigger

From: Alexander Peters <apeters_at_ap-data.de>
Date: Mon, 12 Feb 2007 10:37:15 +0100
Message-ID: <eqpcg9$9ni$03$1@news.t-online.com>

Hello NG!
I have a problem with the tools imp and exp. When i export a user with exp and reimport the dump into an other user or server all procedures and trigger compiled with warnings/errors. But when i recreate the procedures (with SQL), they are compiled without any error. How can i export and import a database user without destroying the procedures and trigger?

Export:
my Parfile:
STATISTICS=NONE userid=%1/%2
file=%3
log=%3.log
exp parfile=parfile.txt

Import:
imp %1/%2 fromuser=%3 touser=%1 file=%4 log=%4.log

Thanks in advance
A. Peters Received on Mon Feb 12 2007 - 03:37:15 CST