Re: impdp error

Posted by Arsala on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/impdp-error-tp1444p1470.html


Thanks for guide

While I importing data if it give error then I recreate user,,

one my friend give me this script for export and import ..

exporting is don without errore

expdp system/aone@dwh directory=backup dumpfile=scott2.dmp logfile=scott2.log schemas=scott PARALLEL=4  flashback_time=to_timest
amp(to_char(systimestamp\,'mm/dd/yyyy\ hh24:mi:ss.ff9')\,'mm/dd/yyyy\ hh24:mi:ss.ff9')


but while we I import dumpfile it give errore like this.


impdp system/aone@dwh directory=backup dumpfile=scott2.dmp logfile=scott2.log schemas=scott PARALLEL=4  flashback_time=to_timest
amp(to_char(systimestamp\,'mm/dd/yyyy\ hh24:mi:ss.ff9')\,'mm/dd/yyyy\ hh24:mi:ss.ff9')



Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39005: inconsistent arguments
ORA-39208: Parameter FLASHBACK_TIME is invalid for IMPORT jobs.