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

IMG-00803: invalid attribute value

1 Answers  


ORA-02703: osnpopipe: pipe creation failed

1 Answers  


ORA-38309: object not purgable

1 Answers  


ORA-32736: Hang analysis aborted due to wrong message type

1 Answers  


ORA-19610: directory block string is corrupt

1 Answers  






EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$

1 Answers  


ORA-02049: timeout: distributed transaction waiting for lock

1 Answers  


ORA-22062: invalid input string [string]

1 Answers  


ORA-14405: partitioned index contains partitions in a different tablespace

1 Answers  


ORA-06432: ssaio: Buffer Not Aligned

1 Answers  


ORA-31417: column list contains control column string

1 Answers  


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

1 Answers  


Categories