Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Tablespace issue

650575Jun 10 2011 — edited Jun 13 2011

Hi,

I am getting below error and my database is in no archive log mode.

I have physically move data file location from /u01 to /u02

but after i do rename data file then i get below error

SQL> alter tablespace JISPBILCORBILLINGDEV501 RENAME DATAFILE '/u01/app/oracle/oradata/vtelar/JISPBILCORBILLINGDEV501_01.dbf' to
2 '/u02/vtelar/JISPBILCORBILLINGDEV501_01.dbf';
alter tablespace JISPBILCORBILLINGDEV501 RENAME DATAFILE '/u01/app/oracle/oradata/vtelar/JISPBILCORBILLINGDEV501_01.dbf' to
*
ERROR at line 1:
ORA-01525: error in renaming data files
ORA-01121: cannot rename database file 28 - file is in use or recovery
ORA-01110: data file 28:
'/u01/app/oracle/oradata/vtelar/JISPBILCORBILLINGDEV501_01.dbf'

Please suggest me what should i do?

Thanks in advance.

This post has been answered by 779621 on Jun 10 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2011

Added on Jun 10 2011

#general-database-discussions

4 comments

1,440 views