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-29823: object being analyzed is not a table

1 Answers  


RMAN-06011: invalid level specified: number

1 Answers  


ORA-12731: invalid collation class in regular expression

1 Answers  


ORA-06706: TLI Driver: service not found

1 Answers  


ORA-29820: the statistics type is not present

1 Answers  






ORA-02345: cannot create a view with column based on CURSOR operator

1 Answers  


PCC-01513: FIPS warning: Unsupported datatype in line number of file string

1 Answers  


ORA-01581: attempt to use rollback segment (string) new extent (string) which is being allocated

1 Answers  


PLS-00120: inappropriate argument in OPEN statement

1 Answers  


RMAN-12005: error during channel cleanup

1 Answers  


ORA-01912: ROW keyword expected

1 Answers  


ORA-28116: insufficient privileges to do direct path access

1 Answers  


Categories