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

PLS-00623: FLOAT precision constraint must be between 1 and 126

1 Answers  


ORA-01029: internal two task error

1 Answers  


ORA-01072: cannot stop ORACLE; ORACLE not running

1 Answers  


ORA-04028: cannot generate diana for object stringstringstringstringstring

2 Answers  


RMAN-04020: target database name "string" does not match channel's name: "string"

1 Answers  






NZE-28815: Cannot convert a number in native format to Oracle format.

1 Answers  


ORA-00277: illegal option to the UNTIL recovery flag string

1 Answers  


NZE-28869: Peer's certificate is expired.

1 Answers  


ORA-14304: List partitioning method expects a single partitioning column

1 Answers  


ORA-12353: secondary stored object cannot reference remote object

1 Answers  


ORA-00024: logins from more than one process not allowed in single-process mode

1 Answers  


NNL-00351: Scheduled configuration save to occur in string

1 Answers  


Categories