Re: Full database export as user ' / as sysdba'

I can think of one:

If you implement audit_sys_operations=TRUE in 9i (per security requirements, etc), you can end up with some _HUGE_ .aud files. Had this one bite us when we upgraded to 9.2.0.5.

--Scott

On Wed, 29 Sep 2004 10:26:11 -0400, Mohammad Rafiq <rafiq9857_at_gmail.com> wrote:
> OS: WINDOWS 2000, HP-UX 11.11
> Oracle Version : 8.1.7.4 and 9.2.0.5
>
> Is there any issues while exporting full database as user ' / as sysdba'?
>
> We have to do it because of implemention of row level security as in
> this case as system it generates errors for all those tables where RLS
> implemented and not able to export those rowson .
>
> In certain Oracle Notes for full exports (except for transportable
> tablespaces) and even in Datapump export doc for 10g it is suggested
> not to export as ' sysdba' for full database.
>
> I personally exported and imported full database export dump as sysdba
> without any issues.

--
http://www.freelists.org/webpage/oracle-l