Does anyone know how to specify the current date and time for FLASHBACK_TIME in a 10gR2 expdp ?
11gR2 Data Pump helpfully provides the systimestamp setting so you can specify
However 10gR2 Data Pump does not have this option. I could use the SCN or explicitly specify a date & time but I was just wondering is there a way to easily define the current date / time in 10gR2 expdp
A setting of
in 10gR2 this gives an invalid argument
in 11gR2 this works
in 10gR2 I have to use something like
flashback_time="to_timestamp('13-APR-2012 12:00:00','DD-MON-YYYY HH24:MI:SS')"
I was just hoping there was something that would allow me to use sysdate in the parfile at the point of kicking off the export without have to explicitly state a date and time ( and hence having to change the parfile for each run )
I know there was some work for specifying
in the 11 timeframe but don't remember if it was a bug or not. Seem to recall it was. I also don't know if it was backported. It may have been. You could contact Oracle Support to see if there is a patch available for the release that you are on.
If you invoke this from a script, you may be able to use something like:
> set echo off
> set linesize 132
> connect user/password
> set heading off
> spool expdp.par
> select 'flashback_time=' || TO_CHAR(sysdate, ''YYYY-MM-DD HH24:MI:SS'') from dual;
> spool off
Then you can use this:
expdp user/password parfile=expdp.par ...
Hope this helps