Dave Henley -
The problem is that USER_SOURCE is not really a table, it is a view. The
underlying table for that view is a data dictionary table owned by SYS.
Exporting a user doesn't really export any rows in the data dictionary
tables, it exports CREATE object commands for the objects owned by the user.
When you import, Oracle executes the CREATE commands, and when the objects
get re-created, the corresponding rows in the data dictionary are a by-
product of creating the objects.
So to re-phrase what you are trying to do, you want to re-create the stored
procedures owned by a particular user, but not the user's other objects.
Export and Import can't easily do this, since they want to give you
EVERYTHING owned by the user, not just procedures. The best way to do this
is to write a SQL*Plus script to write CREATE PROCEDURE (or CREATE PACKAGE
and CREATE PACKAGE BODY) commands for the objects owned by the user, move the
resulting file to the other database, and execute it in SQL*Plus. You could
do this yourself, or as I mentioned before, look for somebody else's working
script to do it. If I find one, I'll send it to you by private e-mail.
Received on Mon Mar 20 1995 - 09:08:17 CST
