This question probably been asked before, but I'm not able to find it, so here goes (again):
I've read in Oracle docs that it is usually adviseable to export (exp or expdp), or import (imp or impdp) using the SYSTEM account rather than the SYS account (mainly for FULL exports and imports).
I guess my question is if this is really true, and if so, why?
Is it because sys and system data will not be exported or imported, or something related to that?
Also, in our scripts, while using the SYSTEM account, I have to pass a password to run expdp (or impdp), such as
expdp system/$SYSTEM . . .
but this method allows someone who queries the system processes to see the password (bad).
but as sys, I can simply use
expdp \'/ as sysdba\' . . .
But I recall that exporting or importing as SYS was not recommended by Oracle.
Can anyone help clear this up?