ORA-02152: Invalid ALTER TABLESPACE ... RENAME option



ORA-02152: Invalid ALTER TABLESPACE ... RENAME option..

Answer / guest

Cause: An option other than DATAFILE or TO follows by ALTER
TABLESPACE ... RENAME.

Action: The user must specify either DATAFILE or TO
following ALTER TABLESPACE ... RENAME.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01017: aggregate argument cannot be converted to canonical form

1 Answers  


PCC-01008: Multiple element records not allowed in DECLARE section

1 Answers  


ORA-24186: wrong object type, could not transform message

1 Answers  


TNS-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

1 Answers  


ORA-31199: Warning in processing file string

1 Answers  






IMP-00071: Object identifier of imported table mismatches object identifier of existing table

1 Answers  


ORA-31698: Error stack buffer size must be specified and must be greater than 0.

1 Answers  


O2F-00321: Error opening the OUTTYPE file for writing

1 Answers  


RMAN-08018: channel string: starting archive log restore to user-specified destination

1 Answers  


ORA-09853: snyRemovePort: bad return code from request.

1 Answers  


ORA-07237: slemcl: invalid file handle, seals do not match.

1 Answers  


ORA-19015: Invalid XML tag identifier (string)

1 Answers  


Categories