| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing Packages Only
Bill Buchan wrote:
>
> I have accidentally dropped some packages that I wanted to keep.
> Fortunately these were in the full export file which I had just generated.
> But I can't find any way of importing just these packages without importing
> the whole export file back into another schema and then copying them.
>
> I can see how to import individual tables from a dump file,
> TABLES=tablename, but I can't see any way of being selective about any other
> objects.
>
> Is this correct? Do I have to wait for a huge import job to run to get at a
> couple of small packages? There must be a better way!
>
> Any advice gratefully received as ever!
> Many thanks,
>
> - Bill
>
> PS: Oracle 8.04 on NT4
Haven't tried this - but you could try:
create user xxx;
grant create session, create procedure to xxx;
import the file - all the table create stuff etc will fail with
insufficient prvs
at the end you'll have a lot of pl/sql
export out the xxx user
import into target environment
Cheers
--
 |
 |