Database Administration (MOSC)

MOSC Banner

ORA-14206 drop subpartition KO

edited Jan 31, 2019 11:02AM in Database Administration (MOSC) 1 commentAnswered

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.

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