Database Utilities (MOSC)

MOSC Banner

IMPDP: ORA-00922: missing or invalid option

edited Mar 31, 2018 5:01AM in Database Utilities (MOSC) 17 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center