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

ORA-01982: invalid auditing option for tables

1 Answers  


ORA-06561: given statement is not supported by package DBMS_SQL

1 Answers  


ORA-06440: ssaio: the asynchronous read returned incorrect number of bytes

1 Answers  


PCB-00500: No EXEC SQL CONTEXT USE statement encountered

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  






ORA-15026: disk 'string' is not an ASM disk

1 Answers  


ORA-16219: This database is not preparing to switch over.

1 Answers  


PLW-06002: Unreachable code

1 Answers  


PCC-01512: Invalid EXEC SQL INCLUDE of file string found at line number in file string

1 Answers  


DRG-11521: encounter error when updating a LONG or LONG RAW column

1 Answers  


CLSS-02204: voting device not configured. [string] [string]

1 Answers  


ORA-16731: Error executing dbms_logstdby.unskip_txn procedure

1 Answers  


Categories