On Jan 30, 2:33 am, "Ed Prochak" <edproc..._at_gmail.com> wrote:
> On Jan 26, 3:30 pm, Fred Pierce <l..._at_avialantic.com> wrote:
>
> > Would some of you be so kind as to comment on the veracity or lack
> > thereof of the following definition for a "data only" import?
>
> > "a data-only import would be a refreshment of tables - and
> > consequentally their indexes, views and triggers. Packages,
> > procedures and functions aren't supposed to be modified."
>
> > Oh - and the definition quoted also apparently includes dropping the
> > tables, though it's not stated.
>
> If the tables are dropped, aren't procedures and functions invalidated
> and need to be recompiled after the tables are imported? So, they may
> be unmodified in the source code sense, but they are not untouched.
>
>
>
> > I'm intentionally leaving out any background or context since I just
> > want your reaction to the statement as it stands.
>
> Well you got my reaction.
> ed
Hi Ed,
But, what about trigger refreshment. Is that required?
-Venu
Received on Tue Jan 30 2007 - 03:04:38 CST
