ORA-14407: partitioned table contains subpartitions in a
different tablespace



ORA-14407: partitioned table contains subpartitions in a different tablespace..

Answer / guest

Cause: An attempt was made to drop a tablespace which
contains tables whose subpartitions are not completely
contained in this tablespace

Action: find tables with subpartitions which span the
tablespace being dropped and some other tablespace(s). Drop
these tables or move subpartitions to a different tablespace

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2I-00129: No Java file specified

1 Answers  


ORA-23346: primary key or object ID is undefined for table or materialized view string

1 Answers  


ORA-24044: source string and destination string object types do not match

1 Answers  


ORA-09712: orasrv: log archiver already connected.

1 Answers  


TNS-00553: read failed

1 Answers  






ORA-39094: Parallel execution not supported in this database edition.

1 Answers  


ORA-12479: file label string must equal DBHIGH string

1 Answers  


ORA-01031: insufficient privileges

1 Answers  


PCB-00222: Size for host variable string exceeds maximum size

1 Answers  


ORA-06608: LU6.2 Driver: Reset occurred in receive state

1 Answers  


ORA-40106: positive target value not specified for computing Lift

1 Answers  


ORA-14032: partition bound of partition number string is too high

1 Answers  


Categories