Database Administration (MOSC)

MOSC Banner

Datapump tool query

Hi

I have been told that we should NEVER use sysdba to export or import data

e.g.

expdp \'/ as sysdba\' parfile=partipar.par

and instead use

expdp system/<password> parfile=partipar.par

is this true and why is that the case as I have seen many cases where sysdba has been used?

thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center