Re: Lost privileges on import

Chris,

 You might want to try the following if you are not doing a full database export
 Export:
 exp80 system/manager owner=x1,x2,x3... file=my_export.dmp

 Import:

 imp80 system/manager fromuser=x1 touser=x1 file=my_export.dmp
 imp80 system/manager fromuser=x2 touser=x2 file=my_export.dmp
 imp80 system/manager fromuser=x3 touser=x3 file=my_export.dmp

 Let me know if this fixed your problem

Xuening Sun
--
In article <7m0j7v$5cd$1_at_msunews.cl.msu.edu>,   "Chris Weiss" <weisschr_at_pilot.msu.edu> wrote:
> Yes, I am exporting and importing with grants, and I have tried
different
> configurations. The lost privileges seem to be affect only some
schemas and
> some users. It is not consistent between exports.
>
> Chris
>
> tmgn <tmgn_at_excite.com> wrote in message
news:3783C322.AB20C177_at_excite.com...
> >
> > Did U Export and import with GRANTS ?
> >
> > -Thiru

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 10:54:31 CDT