Re: exp/imp - Problems with procedures and trigger

On Feb 12, 10:37 am, "Alexander Peters" <apet..._at_ap-data.de> wrote:
> 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

And what was the Error message ?

regards

s.kapitza Received on Mon Feb 12 2007 - 05:32:54 CST