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

ORA-12839: cannot modify an object in parallel after modifying it

1 Answers  


ORA-32637: Self cyclic rule in sequential order MODEL

1 Answers  


ORA-14402: updating partition key column would cause a partition change

2 Answers  


NZE-29023: The buffers are not empty.

1 Answers  


ORA-15013: diskgroup "string" is already mounted

1 Answers  






PCC-02388: Arrays not allowed in FROM/WHERE clause of SELECT statement

1 Answers  


TNS-00520: Syntax error

1 Answers  


ORA-23444: duplicate template parameter

1 Answers  


ORA-31002: Path name string is not a container

1 Answers  


ORA-17611: ksfd: file 'string' cannot be accessed, global open closed

1 Answers  


ORA-29816: object being disassociated is not present

1 Answers  


ORA-15092: I/O request size string is not a multiple of logical block size string

1 Answers  


Categories