Re: Migrate with exp + imp

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 01 Apr 2006 00:22:06 +0200
Message-ID: <uqar22dcer0i9276lh6q6ge6npldo8revf@4ax.com>

On Fri, 31 Mar 2006 16:44:12 +0200, Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

>I would *never* advise to do exports as SYS. There is a point
>of concern: grants given by SYS will not be exported; better
>check on those, and create a script to grant them again in
>your 9.2 environment

If you are using FGAC in your database, you *must* use SYS, as SYS ignores FGAC by default. Other DBA account observe FGAC.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Mar 31 2006 - 16:22:06 CST