Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: exp/imp - Problems with procedures and trigger

Re: exp/imp - Problems with procedures and trigger

From: Alexander Peters <apeters_at_ap-data.de>
Date: Mon, 12 Feb 2007 17:03:21 +0100
Message-ID: <eqq346$9id$01$1@news.t-online.com>


StefanKapitza wrote:

> 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

Thanks for the Tipp with user_errors. I think its a characterset problem, because he says:

PLS-00103: Fand das Symbol "`" als eines der folgenden erwartet wurde:

   . ( ) , * @ % & | = - + < / > at in is mod not range rem =>    .. <an exponent (**)> <> or != or ~= >= <= <> and or like    between ||
Das Symbol ". wurde vor "`" eingefügt, um fortzufahren.

But i dont know how i can solve it.

-- 
Received on Mon Feb 12 2007 - 10:03:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US