Re: exp/imp - Problems with procedures and trigger

StefanKapitza wrote:

> 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

Hello Kapitza,

It says only
IMP-00041: Warnung: Objekt wurde kompiliert aber mit einigen Warnungen (IMP-00041: Warning: object was compiled, but with warnings)

The Export runs without any errors.

--