Re: [re-post] import problem

In article <39D8B046.9E86741C_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> 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 is correct. If only some of the procedures, triggers etc... are missing you will want to import using the ignore=y option along with the rows=n option to only bring the missing objects. If you want to replace existing code you need to drop the bad objects as Brian suggested.

For future reference it sometimes results in additional ideas in the responses if besides what you specifically ask if you provide a little background information about why you need to do what you want to do. Say as in the case that several user imports was done but you now realize that the the public synonyms are missing. If the instance the data was exported from still existed you could generate the create public synonyms statements. The same option might exist for you if the list of members to be replaced is known and is not too large.

The indexfile parameter of the imp utility can also be used to capture the input code to a file which can be edited, copied, and cut to produce source code. This might be another option for you.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.