partition resides in offlined tablespace

Solution ID:ORA-14117

Type: Oracle

Cause

User attempted an operation requiring that we access data in a partition which resides in a tablespace which was taken offline. Such operations include trying to drop a tablespace of a table which has indices defined on it or is referenced by a constraint.

Actions

object data types are not supported with partitioned tables. Create table without object column or change table to not partitioned. If adding column, do not use object datatypes. If modifying attributes of a column to change data type to object, it has to be a non partitioned table.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


http://docs.oracle.com/cd/E16655_01/timesten.121/e21636/awt_trouble.htm


https://community.oracle.com/message/9321276


https://community.oracle.com/message/10536126


https://community.oracle.com/message/10535178


Browse all solutions to database errors from Oracle, MS SQL, or MySQL