For doing a consistent expdp backup to use flashback_time , documentation provides to use systimestamp where it will fail always (as in my case now)
Error:-
Conneted to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production
With the Partionining,OLAP, Data Mining and Real Applicatiojn Testing options
ORA-39001: invalid argument value
ORA-39150: bad flashback time
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-00911: invalid character
I am sure and remember well systimestamp should work, but some how not working
Instead of flashback_time=systimestamp
use flashback_time="TO_TIMESTAMP('16-10-2012 00:30:00', 'DD-MM-YYYY HH24:MI:SS')"
Hope this helps
-Thanks
Geek DBA
Follow Me!!!