Re: Importing Packages Only

There's a workaround:

You have just to reimport the dump file specifying ROWS=N, FULL=Y and IGNORE=Y. On this way you reimport all objects and if anynone already exists, Oracle ignores the error on the object creation and goes on with the import.

Good luck.

Gianmaria

Bill Buchan wrote in message <7cqtra$83i$1_at_phys-ma.sol.co.uk>...
>
>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
>
>
>
>
Received on Fri Mar 19 1999 - 06:19:41 CST