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-38612: FI item length cannot exceed half of one database block.

1 Answers  


ORA-09779: snyGetPort: failure to allocate a port.

1 Answers  


ORA-24147: rule string.string does not exist

1 Answers  


ORA-07468: spwat: mset error, unable to set semaphore.

1 Answers  


ORA-07493: scgrcl: lock manager error.

1 Answers  






ORA-24343: user defined callback error

1 Answers  


RMAN-11003: failure during parse/execution of SQL statement: string

1 Answers  


ORA-12715: invalid character set specified

1 Answers  


ORA-13455: GeoRaster metadata TRS error

1 Answers  


NCR-01020: NCRS: Operation would block.

1 Answers  


CLSR-00514: Unable to locate PMON [pid=string]

1 Answers  


ORA-29346: invalid tablespace list

1 Answers  


Categories