Re: Exporting / importing a whole schema

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 13 Oct 2005 15:12:15 -0700
Message-ID: <1129241520.383471@yasure>

Andy Kent wrote:

>>Recreate with the appropriate privileges.

>
>
> Most efficient way to do that... ? I assume you don't mean enter them
> manually.
>
> Andy

Yes.

Sometimes I just grant DBA before an import. Import knowing everything will work.
Then revoke DBA.

There are some dangers if you don't know what the import contains. But if you don't know ... you shouldn't be importing it in the first place.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Oct 13 2005 - 17:12:15 CDT