Re: exp/imp - Problems with procedures and trigger

On Feb 12, 1:50 pm, "Alexander Peters" <apet..._at_ap-data.de> wrote:
> 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.
>
> --

maybe you could logon with the user in question and query user_errors to narrow down your problem.

regards

stefan Kapitza Received on Mon Feb 12 2007 - 08:25:35 CST