ORA-14117: partition resides in offlined tablespace



ORA-14117: partition resides in offlined tablespace..

Answer / guest

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.

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-08020: including standby controlfile in backupset

1 Answers  


ORA-21601: attribute is not an object

1 Answers  


EXP-00008: ORACLE error number encountered

1 Answers  


ORA-12827: insufficient parallel query slaves available

1 Answers  


ORA-01308: initialization parameter utl_file_dir is not set

2 Answers  






ORA-26571: %s.string.string: number of arguments (string) does not match replication catalog

1 Answers  


ORA-06531: Reference to uninitialized collection

1 Answers  


ORA-06561: given statement is not supported by package DBMS_SQL

1 Answers  


NPL-00309: requested ASN.1 type tag string does not match received type tag string

1 Answers  


ORA-39304: during sync/swap, object "string" conflicts: "string"

1 Answers  


ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

1 Answers  


ORA-07578: szprv: $FIND_HELD failure

1 Answers  


Categories