Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Migrate with exp + imp

Re: Migrate with exp + imp

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 01 Apr 2006 11:17:50 +0200
Message-ID: <e0lgeu$l6o$2@news3.zwoll1.ov.home.nl>


Sybrand Bakker wrote:
> 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

In combination with FULL exports?
-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Apr 01 2006 - 03:17:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US