IMPDP: ORA-00922: missing or invalid option
Export from 11.2.0.4
exp.par
directory=objddl
content=metadata_only
logfile=exp.log
dumpfile=export.dmp
schemas=MYUSER
metrics=YES
cluster=NO
nohup expdp "'/ as sysdba'" parfile=exp.par &
IMPDP to 12.2.0.1
imp.par
directory=objddl
logfile=import.log
dumpfile=export.dmp
sqlfile=output.sql
metrics=YES
cluster=NO
nohup impdp "'/ as sysdba'" parfile=imp.par &
And in the output sql. when execute in the dest DB . there is error
PARTITION BY RANGE ("XXXXXXX") INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) TRANSITION ("XXXXXXXX") STORE IN ("XXXXXXXX")
*
ERROR at line 16:
ORA-00922: missing or invalid option
I look into the output.sql, this problem query is actually creating a table with partition. But I can't find any option : TRANSITION in any online docs.