OraFAQ Forum: Server Administration » Problem with renaming datafile

Home » RDBMS Server » Server Administration » Problem with renaming datafile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with renaming datafile [message #124483]

Sun, 19 June 2005 06:14

Achchan
Messages: 86
Registered: June 2005

Member

Hi all,
Scenario:
I want to move a recovered datafile from "C:\Windows\System32" to "%ORACLE_BASE%\oradata\myinstance".
I made the tablespace offline and move the file to destination in mounted state. Now I am trying to rename file using this command:
ALTER DATABASE RENAME FILE 'dest_path\old_name.dbf' TO 'dest_path\new_name.dbf';
It throws these errors:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile "E:\oracle\product\10.1.0\oradata\myinstance\old_name.dbf"

What is the problem?! I can see my datafile using OS but Oracle cant see it?

Report message to a moderator

Re: Problem with renaming datafile [message #124487 is a reply to message #124483]

Sun, 19 June 2005 07:14

salmansh
Messages: 14
Registered: June 2005
Location: Al-Khobar

Junior Member

Hi,

Use ALTER TABLESPACE tablespace_name RENAME DATAFILE old_name TO new_name;

However you should know that this command will work only for non-system tablespace and tablespaces that doesnot contain active undo and temporary segments. If the datafile belongs to system tablespace you should shutdown the database, startup mount and use the ALTER DATABASE RENAME FILE old_name TO new_name.

HTH

Report message to a moderator

Re: Problem with renaming datafile [message #124488 is a reply to message #124487]

Sun, 19 June 2005 07:29

Achchan
Messages: 86
Registered: June 2005

Member

Thanks but that did not solve the problem.It throws the same errors as I mentioned in original post.
Note: tablespace is not system ts. It was created by omwb when I was migrating from sql server.

Report message to a moderator

Re: Problem with renaming datafile [message #124624 is a reply to message #124483]

Mon, 20 June 2005 09:28

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Originally you said you were trying to move the datafile from c:\windows\system32. But your error message says you are trying to move the file from ORA-01516: nonexistent log file, datafile, or tempfile "E:\oracle\product\10.1.0\oradata\myinstance\old_name.dbf". Which is it? Double check your file names and paths.

Report message to a moderator

Previous Topic:	Can i use stream to capture change from archivelog-file of 8i???
Next Topic:	calculating space for new table?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:45:31 CST 2025