Data pump parameter flashback_time=to_timestamp_tz(systimestamp)
Hello.
I cant understand what the porpuse of parameter: flashback_time=to_timestamp_tz(systimestamp).
Specially this part: =to_timestamp_tz
I am asking this question because I tried with this option: flashback_time=systemtimestamp and it did not work. It displayed error:
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
So after searching a bit I got this one: to_timestamp_tz(systimestamp).
How should I import from a data pump dump file when such parameter was included into the export string (anything special to take into account or just a normal import).
I cant understand what the porpuse of parameter: flashback_time=to_timestamp_tz(systimestamp).
Specially this part: =to_timestamp_tz
I am asking this question because I tried with this option: flashback_time=systemtimestamp and it did not work. It displayed error:
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
So after searching a bit I got this one: to_timestamp_tz(systimestamp).
How should I import from a data pump dump file when such parameter was included into the export string (anything special to take into account or just a normal import).
0