Re: Importing Packages Only

Connor McDonald wrote in message <36F0B0BC.6D3B_at_bhp.com.au>...
>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
>--

Thanks for your suggestion. Unfortunately, being a newbie, I'm going to have to ask you to expand!
My understanding is that to import a full database export you need to the IMP_FULL_DATABASE role.
And having this role over-rides any existing system privileges. (i.e. Having tried it I just end up importing the entire dump file - so using patience solved my immediate problem - but I was just wondering how to get your suggestion to work for next time I make a blunder!)

Many thanks,

• Bill