Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: [re-post] import problem
If you use ignore=y the procedures will be overwritten, without problem.
Regards,
Sybrand Bakker, Oracle DBA
"Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message
news:39D8B046.9E86741C_at_edcmail.cr.usgs.gov...
> Not exactly. The original post hast if importing would overwrite
> EXISTING stored procedures & triggers. If the procedure or trigger
> already exists, then it will not be overwritten on import. An error will
> be raised instead. You'll have to drop the existing procedures &
> triggers before importing.
>
> HTH,Brian
>
>
> Andy Hardy wrote:
> >
> > Yes, imp will import the entire schema including the stored procedures.
If
> > you *only* want the procedures, you will need to stop the data from
loading
> > by using the 'ROWS=N' argument.
> >
> > Andy
> >
> > --
> > Opinions are mine and may not reflect those of BG Technology Ltd
> > ilkaos <ilkaos_at_trae.ka> wrote in message
> > news:8r9eqv$h4u$1_at_fe1.cs.interbusiness.it...
> > > (I put this post again hoping someone can help me).
> > >
> > > Is possible , with imp73 , to import the stored procedure ( and
triggers
> > > too)overwriting the existing ones?
> > > thanks and bye.
> > >
> > >
> > >
> > >
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Mon Oct 02 2000 - 12:06:22 CDT
![]() |
![]() |