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-06258: NETNTT: cannot allocate context area

1 Answers  


PCC-01515: FIPS warning: Undeclared host variable "string" at line number in file string

1 Answers  


DGM-16943: You must connect to instance "string" and issue the command again.

1 Answers  


Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value

1 Answers  


TNS-01413: "string" established:string refused:string current:string max:string state:string

1 Answers  






ORA-01611: thread number string is invalid - must be between 1 and string

1 Answers  


DRG-13312: user CTXSYS does not own USER_LEXER stored procedure string

1 Answers  


ORA-01338: Other process is attached to LogMiner session

1 Answers  


ORA-04010: the number of values to CACHE must be greater than 1

1 Answers  


ORA-06102: NETTCP: cannot allocate context area

1 Answers  


ORA-27463: invalid program type string

1 Answers  


ORA-24151: no evaluation context is associated with rule string.string or rule set string.string

1 Answers  


Categories