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

IMP-00052: Warning: Unable to set event for freelist communication with server

1 Answers  


TNS-00305: The Navigator encountered an invalid/unknown trace level

1 Answers  


NID-00129: Invalid DBID for datafile "string", expecting number, found number

1 Answers  


ORA-25457: evaluation function string returns failure

1 Answers  


ORA-14021: MAXVALUE must be specified for all columns

1 Answers  






SQL*Loader-00292: ROWS parameter ignored when a LOB column is loaded

1 Answers  


NNF-01008: XDS attribute syntax string incorrect for Oracle Names syntax string

1 Answers  


NNL-01052: Server has been running for: string

1 Answers  


ORA-22371: Table contains data of type string.string, version string, which does not exist

1 Answers  


ORA-06956: Failed to get local host name

1 Answers  


ORA-23465: flavor already includes column string of "string"."string"

1 Answers  


UDE-00010: multiple job modes requested, string and string.

1 Answers  


Categories