Re: exp/imp question

gapinski_at_lerc.nasa.gov (Gary Gapinski) wrote:

>Hello, Chuck:
>
>I think you may have a problem. The privileges aren't owned by the
>grantee - they're owned by the grantor(s). You might try a no-rows
>export and peruse the export file to see if they're there, but I
>suspect they aren't.
>
>You'll probably have to write a program to extract the privileges
>separately, and, as long as you have to do this, you may as well go
>the whole way and export the data, cascade drop the user, and import
>everything back in.

Thanks for the reply. I thought there might be an easier way.

With a little luck someone at ORACLE is reading this thread and will either add it to the exp/imp utilities, or come up with another backup program that does it.

I can understand the logic for not doing it automatically. They have no way of knowing that you're importing the user into the same database as it was exported from. But I still think there should be an option for this because 90% of the time you are importing back into the same database.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!