Andy Kent wrote:
> What's the best way to copy a complete user / schema and all associated
> objects and permissions from one instance to another?
>
> The user had already been created on the target box but when I did the
> import some objects, e.g. sequences, failed to create, I think due to
> missing privileges. If I drop the user can I get exp / imp to do it all
> for me and preserve the privileges from the source box?
>
> Thanks
>
> Andy
Drop the schema.
Recreate with the appropriate privileges.
Reimport.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 13 2005 - 10:50:36 CDT
