Re: PL/SQL Tip of the Month

> Speaking of which,does anyone know a way to export the *packages* (+proc's,
> functions) of a *user*
> and only the packages (so no tables, not even the empty versions of them) ?
> This in a way that these can be imported in another database (so without
> exporting
> the whole database).

There is a tool, called the SQL Navigator (http://www.TechnoSolutions.com/),
which helps quite a bit. Although the process remains manual, it makes quite
easy to copy a package from a schema and paste it into another one.

I hope that this helps

Emmanuel Baechler
Lausanne
Switzerland Received on Mon May 11 1998 - 00:00:00 CDT