ORA-02231: missing or invalid option to ALTER DATABASE
hi,
i using oracle 8i in solaris
i am trying to rename the datafile at mount state but itz throwing error i dont know why ..... i did every thing perfectly
shutdown the database
used operating system to copy the file to different location('/export/home/oracle8i/relocate/kalyan.dbf')
now
started up to mount state and trying to rename but itz throwing this error
sq>startup mountORACLE instance started.
Total System Global Area 48378016 bytes
Fixed Size 73888 bytes
Variable Size 27734016 bytes
Database Buffers 20480000 bytes
Redo Buffers 90112 bytes
Database mounted.
SQL> ALTER DATABASE RENAME DATAFILE '/export/home/oracle8i/migdb/data/kalyan.dbf
' to '/export/home/oracle8i/relocate/kalyan.dbf';
ALTER DATABASE RENAME DATAFILE '/export/home/oracle8i/migdb/data/kalyan.dbf' to
'/export/home/oracle8i/relocate/kalyan.dbf'
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
can any one help me to solve this issue......
With Regards
Boo