Re: import terminology

From: Ed Prochak <edprochak_at_gmail.com>
Date: 29 Jan 2007 13:33:09 -0800
Message-ID: <1170106389.386815.172760@v33g2000cwv.googlegroups.com>

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 Received on Mon Jan 29 2007 - 15:33:09 CST