ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER nor READ ON

ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER
nor READ ONLY

Question Posted / guest

ORA-29314: tablespace 'string' is not OFFLINE FOR RECOVER nor READ ONLY..

Answer / guest

Cause: Tablespace clean SCN is either 0 or invalid.

Action: ALTER the tablespace OFFLINE FOR RECOVER.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

PCC-02020: Preprocessor error at line number, column number, file string:

ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive

RMAN-06025: no backup of log thread number seq number lowscn string found to restore

DRG-51804: failed to write to file: %(1)

PLS-01473: Use <> instead of != or ~=

NID-00310: Control File string - reverted

ORA-02020: too many database links in use

ORA-02855: Number of requests is less than the number of slaves

ORA-22924: snapshot too old

RMAN-08002: starting full resync of recovery catalog

PCC-02106: Userid only used when SQLCHECK = FULL, userid ignored.

ORA-00378: buffer pools cannot be created as specified

For more Oracle Errors Interview Questions Click Here