Re: Data pump run as sysdba

The warning applied to exp as well. CONSISTENT (in exp) and FLASHBACK_SCN do not work with SYSDBA.

Hemant K Chitale
http://hemantoracledba.blogspot.com
http://hemantscribbles.blogspot.com

On Jun 10, 2017 05:00, "Yong Huang" <dmarc-noreply_at_freelists.org> wrote:

> Oracle warns against running data pump as sysdba:
>
> http://docs.oracle.com/database/122/SUTIL/datapump-import-utility.htm
> <http://docs.oracle.com/database/122/SUTIL/datapump-import-utility.htm#SUTIL890>
> Do not start Import as SYSDBA, except at the request of Oracle technical
> support. SYSDBA is used internally and has specialized functions; its
> behavior is not the same as for general users.
>
> http://docs.oracle.com/database/122/SUTIL/oracle-
> data-pump-export-utility.htm
> <http://docs.oracle.com/database/122/SUTIL/oracle-data-pump-export-utility.htm#SUTIL200>
> Do not start Export as SYSDBA, except at the request of Oracle technical
> support. SYSDBA is used internally and has specialized functions; its
> behavior is not the same as for general users
>
>
> <http://docs.oracle.com/database/121/SUTIL/GUID-D5455260-C28C-475F-9E0E-2BE227E7F0E3.htm#SUTIL824>
> Technically, what could be wrong if data pump is run as sysdba? Suppose I
> never use the query=... clause, which may bypass VPD.
>
> Yong Huang
>

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