Depending how big the dmp file is, you can edit it deirectly to strip out
the package definition.
Else you could try to an import with ignore=y, which will skip existing
objects.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Bill Buchan wrote in message <7costv$1aj$1_at_phys-ma.sol.co.uk>...
>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
>
>
>
Received on Wed Mar 17 1999 - 14:03:06 CST
