There is no way to export/import only procedures and not tables (at least
in 7.x versions).
I think the best thing you can do is to generate scripts by querying the
TEXT column in the ALL_SOURCE (or USER_SOURCE) view, restricted to the
NAME of your procedure and ordered by LINE number.
Margaret Burwell <aj739_at_FreeNet.Carleton.CA> a écrit dans l'article
<862bah$sv4$1_at_freenet9.carleton.ca>...
>
> Please forgive me if this seems like a basic and obvious question, it
> isn't to me.
>
> I have a development database in which there are procedures which are
> owned by the user devl. I want to move them to the production database
> where they will be owned by administrator. I don't want to export the
> entire devl schem because I will pick up tables and views I don't want in
> the production database.
>
> Is the an easy way to move only specified procedures?
>
> Marg
>
Received on Wed Jan 19 2000 - 05:02:51 CST
