ORA-14206 drop subpartition KO
Hi,
I’d like to rebuild a table
For this I have planned these actions
I'd like to rebuild a data subpartition :
For this, I have planned these action :
1/ export data : expdp user/pwd tables=schema.table.SYS_SUBP107 DIRECTORY=DATAPUMP DUMPFILE=myfile.dmp LOGFILE= my_file.log
2/ alter table schema.table drop subpartition subpartition_name ;
3/ impdp user/pwd tables=schema.table.SYS_SUBP107 DIRECTORY=DATAPUMP DUMPFILE=myfile.dmp LOGFILE= my_file.log
the action 1 is ok
the action 2 is ko with ORA-14206 error
I haven’t found the solution yet. may be necessary to rebuild all the partition ?
thanks for your help.