One problem is that if you use CONSISTENT=Y it will be ignored. We
learned this the hard way when we imported some tables from a full
export using the SYS account and there were a few dozen inconsistencies.

-----Original Message-----
From: Stephen Price
[mailto:oracledba-ezmlmshield-x47570561.[Email address protected]
Sent: Wednesday, April 04, 2007 8:17 AM
To: LazyDBA Discussion
Subject: Automate Export using exp without exposing system password

I want to thank Humberto for providing the solution I was seeking.
However, I was 'told' that performing full schema/data exports using the
SYS account as SYSDBA was 'trouble' and 'not recommended'...

Why?

Cheers,
Stephen

Stephen Price
Oracle Database Administrator
Compusearch Software Systems, Inc.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page