ORA-14404: partitioned table contains partitions in a
different tablespace



ORA-14404: partitioned table contains partitions in a different tablespace..

Answer / guest

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

Action: find tables with partitions which span the
tablespace being dropped and some other tablespace(s). Drop
these tables or move partitions 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

ORA-30550: index depends on a package/function spec/body which is not valid

1 Answers  


ORA-02818: Less than the number of blocks requested was read in

1 Answers  


ORA-29263: HTTP protocol error

1 Answers  


ORA-00362: member is required to form a valid logfile in group string

1 Answers  


TNS-00008: INTCTL: could not contact destination Navigator

1 Answers  






TNS-12557: TNS:protocol adapter not loadable

2 Answers  


ORA-03296: cannot resize datafile - file string not found

1 Answers  


PCC-02350: cannot equivalence this SQL type

1 Answers  


ORA-27069: attempt to do I/O beyond the range of the file

1 Answers  


ORA-01295: DB_ID mismatch between dictionary string and logfiles

1 Answers  


NZE-29177: certificate serial number is not in CRL

1 Answers  


ORA-14011: names assigned to resulting partitions must be distinct

1 Answers  


Categories