ORA-14630: subpartition resides in offlined tablespace



ORA-14630: subpartition resides in offlined tablespace..

Answer / guest

Cause: User attempted an operation requiring that we access
data in a subpartition 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.

Action: Bring tablespace online before attempting the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06038: recovery catalog package detected an error

1 Answers  


ORA-31047: Could not retrieve resource data at path string

1 Answers  


DRG-10516: failed to perform DDL operation due to an Oracle error

1 Answers  


ORA-13148: failed to generate SQL filter

1 Answers  


QSM-01095: no suitable grouping_id found in MV with grouping sets

1 Answers  






ORA-27486: insufficient privileges

1 Answers  


NNO-00260: loading configuration data from checkpoint file "string"

1 Answers  


TNS-12622: TNS:event notifications are not homogeneous

1 Answers  


NID-00422: Change of database ID failed during validation - database is intact.

1 Answers  


ORA-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


RMAN-06444: %s created with compilation errors

1 Answers  


ORA-27123: unable to attach to shared memory segment

1 Answers  


Categories