Re: Import data but without SPs/Packages

From: C. R. Soza <crsoza_at_hotmail.com>
Date: 23 Aug 2001 05:27:54 -0700
Message-ID: <c18ea449.0108230427.2b53d53c@posting.google.com>

"Sean" <nospam_at_nothankyou.com> wrote in message news:<9m186j0u1f_at_enews1.newsguy.com>...
> Platform : Oracle 8.1.7 on NT 2000.
>
> Trying to export the data that belongs to a user and then import it into
> another database where the tables are the same but the stored procedures and
> packages are the "new version". My understanding is that when you use the
> export utilty, the packages and stored procedures with the user are exported
> as well.
>
> My question is how do I import JUST the data with no triggers, stored procs,
> packages, etc. I know you can do CONSTRAINTS = N, INDEXES = N, etc. but
> there is no documentation on preventing the packages from coming in. If
> they do come in, they end up overwriting the ones I have in place.
>
> Any help would be appreciated.
> Sean Dolan

prior to import, revoke all grants that deals with stored proc creation. eg: revoke create procedure from user_name;

when importing, since you have revoked grants, all sp's will fail with errors.
hope this helps - chris. Received on Thu Aug 23 2001 - 07:27:54 CDT